Unanswered

Copy file from one SharePoint folder to another if the file name contains certain word

(1) Share

Report

Posted on by arit

Hi,

As the title suggests, I'm trying to copy files uploaded to one SharePoint folder to another if these files contain a specific text in their name. For example all files inside Folder A with names containing "What-If" will be copied to another folder named "What-If", files containing "Banquet Model" will be copied to a folder named "Banquet" etc. I tried different solutions posted in the forum but none of them seem to work. Any help would be greatly appreciated. TIA!

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

GeorgiosG 1,013 Super User 2024 Season 1 on at

Like (0)

Report

Hi @arit ,

assuming that you want to do it just one time you can use the manual trigger. With the following process flow you can achieve this:

- Manually Triggered

- Get files (with filter which is checking your contains formulas)

- move files (all files to the correct folder)

I would work with scopes and copy them for all expressions.

In the filter you have to use FileLeafRef instead of Title.

Example:

Was this reply helpful? Yes No
arit 17 on at

Like (1)

Report

Hi,
Thank you for the reply. I'm completely new to power automate, so I'm still trying to navigate through and make sense of all the different elements.
Here are some more details if that helps: New files will be uploaded to the source folder constantly, so it won't be a one-time activity. Also, the file needs to be copied to the new folder not moved altogether. I'm trying to create a backup folder of some sort.
Would it be possible to do this?

Was this reply helpful? Yes No
Verified answer

GeorgiosG 1,013 Super User 2024 Season 1 on at

Like (1)

Report

Hi @arit ,

if you are new to Power Automate I just recommend to just test things out 😉

From the main logic it is the same what you want, instead of move file action simply use copy file.

Trigger is changed from manually to When a file is uploaded, the construction with the condition is fine for your use case with two folder.

Was this reply helpful? Yes No
arit 17 on at

Like (1)

Report

Thanks @GeorgiosG!

I've recreated this flow and it works.

Was this reply helpful? Yes No
arit 17 on at

Like (1)

Report

Hi @GeorgiosG,

I realized that the file from the source folder disappeared altogether after being copied to the new folder even though the action is set to "Copy file" not "Move file". I was wondering if you had any idea on what went wrong with the flow. Here's my flow:

Was this reply helpful? Yes No
GeorgiosG 1,013 Super User 2024 Season 1 on at

Like (0)

Report

Shouldn't be the case. Can you check the recycle bin of the SharePoint site via site settings if the is the file you are searching for ?

Was this reply helpful? Yes No