Copy Existing Folders into New Folder

(0) Share

Report

Posted on by Ebonastix

Hello,

I'm new to Power Automate and wondering how to go about achieving the below.

We have seperate teams working towards the same Project and once Live would like to pool their related Folders into a New Folder. For example once Live I want to create a New Folder in Documents > General > Live Project > "XXXXX - Project 1"

Within the same library there are Sub Folders in Documents > Sales > Contracts > "XXXXX - Project 1 Contracts" that I would like copied into the New Folder upon creation.

The search needs to match the New Folders first 5 values (numbers XXXXX - (Variable)) and copy any matching Sub Folders into the New Folder.

Kind Regards

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (1)

Gareth1 308 on at

Like (1)

Report

Hi @Ebonastix
In order to copy a folder you need to know the full path to the folder. One way to achieve this is to list the folders and filter the array for folders that contain the project number

This can be applied to both the folders outside of the live projects and for the folder inside the Live Projects folders
Once you have both of these you can copy the folders

Hopefully this helps

Was this reply helpful? Yes No
Ebonastix 10 on at

Like (0)

Report

Hi Gareth,

Thank you for the response. In the Path actions could you explain what you've done to have "ProjectNo" in there?

I assume this is the referenced search number prior to manually triggering the flow, what is the formula?

Kr,

Was this reply helpful? Yes No
Gareth1 308 on at

Like (0)

Report

I just had added a manual input on the Manual trigger called ProjectNo

Are you trying to have this happen automatically when a folder is created in the Live Projects folder or is it a manual process you are running?

Was this reply helpful? Yes No
Ebonastix 10 on at

Like (0)

Report

Ideally automated daily or upon creation of a folder in "Live Projects". so Documents > General > Live Projects > XXXXX Project1 has the latest copies of any folders across that library with the first 5 values "XXXXX".

Was this reply helpful? Yes No
Verified answer

Gareth1 308 on at

Like (1)

Report

Hi @Ebonastix
You could use a scheduled flow to run daily, however the risk you could run into is that if someone works on files in the Live Projects version of the folder then the files could be overwritten, however if the Contracts folder outside of the Live Projects folder is the working folder then that should be ok

In the example below I use the Select action to extract the project no (first 5 characters from the folder name in the Live Projects folder)
Hopefully this helps

Was this reply helpful? Yes No
Ebonastix 10 on at

Like (0)

Report

I'm having an issue that files related to Live Projects > 70000 - Project1 are landing in Live Projects > 70001 - Project2

Was this reply helpful? Yes No
Gareth1 308 on at

Like (0)

Report

Hi @Ebonastix
Are you able to send through a screenshot of your flow so that I can check it out

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Can you explain in more details how you got the "Body" and "Path" functions in the "Apply to each 2"action?

Was this reply helpful? Yes No