Pipeline to create Sharepoint folders

Question

Hey everyone, I'm in need of some help formatting a pipeline to create/update Sharepoint folders. Is there good documentation anywhere on it? I haven't found much more than general information on the channel yet. I'm trying to format the file path properly. Basically things are formatted in our sharepoint as proposals\year\client\job. So I need the pipeline to search folders to see if there's an existing folder for a year, then client, and then create itself a path and new folder if there aren't. I'm assuming that each layer of the file path is a separate step in the pipeline?

Thank you!

------------------------------
Elena Larrabee
------------------------------

QuickBaseJunkie · Answer

Sadly there aren't many resources for the non-Quickbase channels.

I'm gathering these for myself and may one day put together a document for others to reference for specific 'non-Quickbase' channels like SharePoint.

I haven't had a lot of success querying on the Path, the Web URL seems more reliable.

Below is the structure/approach I would use which assumes your first step is a trigger where the Year, Client, and Job information are populated.

PLEASE NOTE: I won't be able to help you troubleshoot, but hopefully this will get you started on the right path.

When testing I find it helpful to create mini-pipelines with just the search step, where I delete the 'For Each - Do' loop. Then run the pipeline with my criteria to make sure I'm getting back what I would expect. This way I can adjust until it's just right without worrying about the rest of the pipeline or creating a lot of trigger records.

Please let me know if this was helpful 👍
-Sharon

------------------------------
Quick Base Junkie
------------------------------

Sign up

Login to the community