Copy or move PDF from OneDrive to SharePoint depending on filename

[DEBS1644]

I have integrated JotForm with OneDrive, so all forms are uploaded as PDF files in a specific folder. When they are created, I want to either copy or move them to a folder in SharePoint, I can do this already, but they all go to one folder:

But I want to send them to more than one folder depending on the location contained in the file name. So a file called "Manchester - FS63-022" would go to a folder on the Manchester site:

Do I need to have a flow for each of the 30+ sites and add a filter to pick up each location name, or (preferably) can I have one flow that will direct the PDF according to the location in its name?

[annajhaveri · Accepted solution]

@DEBS1644  you can add Condition action to check if the file name contains certain keywords. Then in yes branch of condition you can add actions to create file in that specific folder, and in no branch you can add more conditions to check for other keyword and so on.

[DEBS1644]

Hi, I have tried that (see below). I have tried both with and without the final terminate at the bottom.

But get the following error:

[DEBS1644]

Hi Anna, I've now added the second condition to the no branch and it worked. Thank you so much. I will keep looking for a simpler way (i.e. not adding a condition for all 30+ locations, but in the meantime this will work.

[annajhaveri]

@DEBS1644  you can also write conditions in expressions, and set the variable to different values based on different conditions. Then use that variable in switch action, and have cases for locations in switch action, that will make your flow more organized when you have more locations.

[DEBS1644]

Could you show me how to do that? I am quite new to Power Automate so rely on video tutorials or through this Community!