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
------------------------------

markshnier__you · Answer

Sharon, I like your low tech excel sheet method to planing out a Pipeline. I tend to do most of my native Quickbase work "on the fly", but since we can't natively insert steps in Pipelines or change the trigger, it make more sense to be more "planful".

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

elenalarrabee1 · Answer

Thank you so so much! After a ton of trial and error yesterday, this is basically what I have set up... The issue I'm running into though is that the pipeline just gives me an error message whenever it encounters an "empty list" of folders. It tells me that one of the arguments is invalid, but when I test it where I know all the folders exist it works just fine. Have you experienced this? I have a support ticket open on it, but I wonder if it's a common issue.

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

jeremymyer · Answer

Elena, I have a similar issue, albeit in Box instead of Sharepoint. If I have a pipeline step of create a folder, and a follow up step of create a subfolder, it fails....like the quickness of pipelines doesn't acknowledge that parent folder exists *yet. I'm curious if adding a pause (5 min or something will help your pipeline work...) it does for mine. Just something to try.

Thanks

------------------------------
Jeremy Myer
------------------------------

elenalarrabee1 · Answer

Hey Jeremy, yep, I've definitely experienced the issue of the pipeline getting ahead of itself and not recognizing newly created records. My typical solution is to make the system search for the record it's just created and then move forward, which works great for me.Unfortunately, this is an issue where the pipeline is supposed to return empty queries, and then move forward by creating a folder in Sharepoint where one doesn't currently exist. It's falsely giving an error whenever it gets an empty list of results, and the same step works just fine (without errors) when it does find results. I've got a support ticket going, so fingers crossed it gets resolved!------------------------------Elena Larrabee------------------------------

Forum Discussion

Pipeline to create Sharepoint folders