Dynamically create a folder with multiple subfolders with multiple subfolders

(0) Share

Report

Posted on by User_Naami

So I have a share point list that contains the following columns.

Year

Month

Day (Monday to Sunday)

I would like to create a folder system on Power Automate such that when I run my flow, it creates a unique folder for each year, month and day. If a folder already exists, then don't do anything. For example if I already have a folder called 2022 then skip. If I already have a folder called January in 2022 skip. If i already have a folder in January called Monday then skip.

For example,

2022/January/Monday

2022/January/Tuesday

...

2022/March/Monday

Is this possible?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

GeorgiosG 1,013 Super User 2024 Season 1 on at

Like (0)

Report
HI @User_Naami ,

You can use easily the Create new folder action.
SharePoint will skip an already existing folder by default.

Please think about when you have not a String column to convert the value to string with string().

A Flow can look like this 🙂 I simply used the action When an item is created

concat(triggerOutputs()?['body/Year'],'/',triggerOutputs()?['body/Month'],'/',triggerOutputs()?['body/Day'])

Was this reply helpful? Yes No
User_Naami 82 on at

Like (1)

Report

Hi Thank you for that, it worked!

Just a really quick question. Suppose I have created a file down my flow and then would like to move that file into the folder (the day folder that is linked to a dynamic content) how would i go about doing that?

I've tried this.

Was this reply helpful? Yes No
Verified answer

GeorgiosG 1,013 Super User 2024 Season 1 on at

Like (0)

Report
Great that it works for you !
You can use the same concat but you have to insert the library name in front.
I.e.
/Shared Documents/2022/February/Monday
You can achieve this with concat again.

concat("/Shared Documents/",triggerOutputs()?['body/Year'],'/',triggerOutputs()?['body/Month'],'/',triggerOutputs()?['body/Day'])

Or retrieve the library name dynamically if it is necessary.

Was this reply helpful? Yes No
User_Naami 82 on at

Like (0)

Report

Thank you, I manage to figure it out as soon as i posted the reply haha. But nevertheless thank you for your help!

Was this reply helpful? Yes No