Unanswered

Moving files from a SharePoint folder to other SharePoint folders depending on filename

(0) Share

Report

Posted on by DEBS1644

I have a General SharePoint folder that has several PDFs in it. I want to write a flow that moves them into other folders, depending on their name, so for example:

111-Exeter.PDF will move to EXETER Folder

1352-Coverntry.PDF will move to COVENTRY folder

and so on...

I have more than 40 different folders. I tried using a a condition (i.e., If it contains Exeter move to Exeter, if it doesn't, does it contain Coventry etc.) but this is no good because there is a limit I think of 8 so I would have to have more than one flow and the locations change all the time.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

tom_riha 10,187 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hello @DEBS1644 ,

you don't need a condition, you can use an expression to define the folder dynamically. Since the folder name is in the file name, you just have to extract it from there.

remove the extension: split(fileName, '.')[0]

remove the number prefix: split(split(fileName, '.')[0], '-')[1]

that's the folder name which you can use as the destination folder.

Was this reply helpful? Yes No
DEBS1644 on at

Like (0)

Report
Copy link

Link copied!

Hi, the example in the link is for moving files from an email attachment. How do I do it from another folder? Also, when removing the condition, do I need to replace it with an Apply to each, add the identifier as the output from previous step before I create the compose action to split the name?
Apologies, but I'm new to Power Automate so have limited ability - find most of what I need by Googling or using this community.

Was this reply helpful? Yes No
tom_riha 10,187 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hello @DEBS1644 ,

the example shows you how to extract a part of file name. In your case you want to list all the files, loop through all the files, and copy them into a folder based on part of the file name.

split(split(items('Apply_to_each')?['{FilenameWithExtension}'], '.')[0], '-')[1]

the flow might look as below.

Was this reply helpful? Yes No