I have files (‘abc 1000.xlsx’, ‘def 1001.xlsx’, ‘ghj 1002.xlsx’, etc…) in ‘source_folder’. I want to copy each of these file to the corresponding ‘1000’, ‘1001’, ‘1002’, etc… folder in ‘dest_folder’. how can i accomplish this using Power Automate Manually Trigger A Flow.
Results are folder ‘1000’ will contain ‘abc 1000.xlsx’, folder ‘1001’ will contain ‘def 1001.xlsx’ and so on.
Many thanks
I don’t know how to do this
I would do it with a list of folder names. Next, use List Files to get all files from the sharepoint server. Then for each folder, filter the files list where “filename contains current item”. Move all files in this list to the “current item” (it will be the folder name)
Here’s a rough structure
please accept the solution if this makes sense to you.
2