Unanswered

How can I copy files to individual folders based on different keyword contained in both (file name and folder name)

(0) Share

Report

Posted on by AlexAlex81

Hi All,

Can you please help with suggestions how can I setup a PowerAutomate flow to help me with the following Archiving issue:

I want to create a flow where different files are copied to different folders automatically, based on a Keyword contained in both (file name and folder name).

1. I am filing .pdf of .doc or .xls files to different folder names, i.e.:

- files named "295OE005 - MCB.pdf" and "295OE005 - SINC.pdf" are archived in folder named "295OE005 - AM Sydney" AND

- files named "294AS003 - BI.pdf" and "294AS003 - SINC.pdf" are archived in folder named "294AS003 OP Melbourne"

- and so on, for hundreds of key words and folders alike.

Is there any setup of PowerAutomate or AI to allow me to have this automatic flow (copying individual files from 1 folder TO multiple folders based on the keyword contained in both - file name and Folder name ?

Attached visual sample of what I described above.

thank you

Expected Result.png

Expected Result.pdf

All responses (7)

Answers (0)

AlexAlex81 6 on at

Like (0)

Report

Re: How can I copy files to individual folders based on different keyword contained in both (file name and folder name)

hi Dezhi,
I am not yet too familiar on how to set it up. can you please type the path-way ?
Really appreciate it !
v-dezhili-msft Microsoft Employee on at

Like (0)

Report

Re: How can I copy files to individual folders based on different keyword contained in both (file name and folder name)

Hi @AlexAlex81 ,
Sorry, for some reason, I can't use the screen recording tool, you can try to build the flow based on my screenshots.

Best Regards,
Dezhi
AlexAlex81 6 on at

Like (0)

Report

Re: How can I copy files to individual folders based on different keyword contained in both (file name and folder name)

hi Dezhi,
Thanks a bunch ! I am a newbie in P.A. and do not really know how to set it up. would it be possible for you to use the Recorder to show me the steps in setting this up ?
thanks anyway.
v-dezhili-msft Microsoft Employee on at

Like (0)

Report

Re: How can I copy files to individual folders based on different keyword contained in both (file name and folder name)

Hi @AlexAlex81 ,

Please try this way.

Rest Regards,
Dezhi
AlexAlex81 6 on at

Like (0)

Report

Re: How can I copy files to individual folders based on different keyword contained in both (file name and folder name)

hi Dezhi,
Thanks for quick reply.
I want the files we copy into a "Source folder" to automatically copy to individual folders that we created, based on the keyword that is found in Both File_name and Destination_Foldername.
For example, if I drag a file named "295OE005 - MRC sbn" into the Source_folder, the Keyword is 295OE005. So, I want the flow to copy it to a folder who's name Starts with 295OE005, i.e. Folder_Name: "295OE005 - OE Singapore" for example.
Same to happen for any other file - to be copied to the relevant folder with common keyword.
Not sure if I explained in a clear manner, please let me know. thank you
v-dezhili-msft Microsoft Employee on at

Like (0)

Report

Re: How can I copy files to individual folders based on different keyword contained in both (file name and folder name)

Hi @AlexAlex81 ,
Do you want the files to be copied to folders with the same name with file names?
I made a test for your reference.
In my scene, both the file name and the folder name contain '-', I use split() to split them with '-' and put the same first half into the same folder.

Best Regards,
Dezhi
v-dezhili-msft Microsoft Employee on at

Like (0)

Report

Re: How can I copy files to individual folders based on different keyword contained in both (file name and folder name)

Hi @AlexAlex81 ,
Do you want the files to be copied to folders with the same name with file names?
I made a test for your reference.
In my scene, both the file name and the folder name contain '-', I use split() to split them with '-' and put the same first half into the same folder.

Best Regards,
Dezhi