Unanswered

Move file to a dynamic folder based on file name

(0) Share

Report

Posted on by Mack98

Looking to create a Flow for a file management system to move a file in a specified Sharepoint folder to another Sharepoint folder with a name that has the final 6 digits matching the first 6 digits of the file name. All done within the same site. I would like the flow to run once a day.

Example:

Drop Off Folder contains file with file name- "XYZ123 Document"

Move "XYZ123 Document" to folder with FolderName "Client XYZ123"

Completely new to this, looking for some guidance

Thanks

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @Mack98

Please have a look at my tutorial video.

https://www.youtube.com/watch?v=B9ZxAd9JVVo&t=25s

I will get back to you later about what you need to do.

Thanks

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @Mack98

As promised here are the rough guide lines what you need to do. Here I am using a manual trigger.

Above the compose expression to get the filename is as follows:

substring(outputs('Compose'),0,6)

Above Compose 3 action step constructs the file folder you want to move to. The output which I mapped under Compose 3 is from Compose 2 output. Then the next step Create File Folder Path Output is mapped using the compose above (Compose 3). Once the file is moved I am deleting the file from the original directory. For the delete file step the Id I am using is from 'Get file metadata using path' Dynamic properties.

Note: Above I am using Doc1 and Doc2 as my libraries. Change that accordingly.

Hope it make sense. If you have any questions please let me know.

Thanks

Was this reply helpful? Yes No
Mack98 6 on at

Like (1)

Report

Thank you for the response and detail!

Perhaps I was not fully explaining my scenario in regards to where the file is to be moved to. The destination folders are already existing, therefore I do not want to create a new destination folder. I have 100 folders, each of which has a 6 digit account number at the end of the folder's name. Each file to be moved has a 6 digit account number at the start of the name that corresponds with one of those folders. I would like the flow to move the file to the correct folder (the one that matches the account number)

I hope that clarifies things. Thank you so much

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @Mack98

Thanks for your reply. Create File Path does take care of that. If folder don't exists then it will create automatically. I would say try the solution I provided and run the flow. Later you could decide what to change or not?

Was this reply helpful? Yes No
Mack98 6 on at

Like (0)

Report

Thank you very much!

This is my understanding of your solution applied to my situation... the Outputs you see correspond to the correct "Compose" sections in the same manner as yours.

This is the error I receive

Was this reply helpful? Yes No
Bibi 10 on at

Like (0)

Report

Hello @Mack98 ,

I would like to know if you have managed to solve the error that is generated

Thank you in advance

Was this reply helpful? Yes No