Sharepoint Folder Creation

(0) Share

Report

Posted on by Andrew_J

1,962 Moderator

Hi All,

I have following flow:

When I ran it recently for 154 items, it missed several folders out.

I am keen to see if I can make sure that every folder is created first time is there a way that I can check if the folder has been created before moving onto the next one. I do not mind if this takes a long time to process but want to know I will get this to work consistently.

Regards,

Andrew

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Unknown geen idee 1,757 on at

Like (0)

Report

Re: Sharepoint Folder Creation

Dear Andrew_J,

This would seem easy enough. You can include an action after the 'supposed' creation of the folder which tries to access that folder. For example 'Get folder metadata' or 'List folder' ... anyone will do.
If this action is successful, it confirms that this folder was created. You may want to include some delays via a Do Until loop.

Hope the suggestion works for you, if it does, please state so in the thread for others.
Happy flowing,
Koen

Was this reply helpful? Yes No
Andrew_J 1,962 Moderator on at

Like (0)

Report

Re: Sharepoint Folder Creation

@Koen5

That seems simple enough, I will try it at the weekend when I have more time. But I need to set the delay to around 20s but that mean 30 minutes to create 154 directories.

But once I have created all the directories, the flow will only run when I have to create new fee proposal. And a minute to do this will not be an issue.

Andrew

Was this reply helpful? Yes No
grantjenkins 11,063 Moderator on at

Like (0)

Report

Re: Sharepoint Folder Creation

Are you creating nested folders, or just a flat folder structure?

And saw your last action is named Create New Document Library - is this just creating the folder?

Also wondering when you said you did this with 154 items: Did you bulk upload that many items to your list?

Was this reply helpful? Yes No
Andrew_J 1,962 Moderator on at

Like (0)

Report

Re: Sharepoint Folder Creation

Hi @grantjenkins

I have a SharePoint site called fees, in there are two sub-sites, the general one (comes with all SP Sites) and one called quotes. In the quotes sub-site I will have a folder for each quote. I spent last weekend getting a list of quotes from year one to year seven in date order in excel.

With another flow I uploaded the excel file into a blank list in SP, all well and good, but although this list was created it missed out several quotes. When I uploaded the excel file I did not add any delay like 10s or 20s between row, or any check to see if the row and list item had been created. I did not think I had to, I thus have around 10 missing quote folders from a folder point of view and also missing quote numbers (I want to add a quote number to all future quotes). I also have more quotes I have tracked down since then that I have added to the excel file, therefore I am up to around 163.

I spent time looking at checking the folder got created from the list, this did not work in my view and output was a '0' which I knew should have been a '1'. I do not want to cut and paste from excel into the list, I want to use the two flows to make this work for the bulk upload and creation of folders. The other flow is as follows:

But once the bulk work is complete I can then use the list for any new quotes and then there wont be a problem.

So where am I going wrong this has to be possible to create a folder from an excel sheet, input information into a list and then create the folder. And in doing so not miss out any rows of the excel sheet.

Regards,

Andrew

Was this reply helpful? Yes No