I've built a flow that currently triggers when a file is created. Problem is the flow runs for every file that is created so right now my end result is about 70+ flow running when a mass of files are dropped in a specific folder it also takes a very long time to complete if it ever does. Would anyone have any advice on how i can get 1 flow to run for multiple files and moving those file to multiple folders?
Here are a few screenshots of my current flow.
the last picture is apply to each for each file i need so i currently have 70+ apply to each.
Any help would be great. Thanks in advance.
You can try to enable concurrency on the Apply to each loop. To do this click on the 3 dots, now click settings, turn on concurrency. And set it’s value to the max (50)
Alternatively. You could use a scheduled flow instead that looks in a specific folder, this way the flow wouldn’t trigger on each file but would grab them all
Yes you would have to enable this on each loop.
Your Flow has 70 separate apply to each loops??
What is your use case / business requirement?
Yes currently flow has 70+ apply to each loops.
My use case is as follows
i have a user that puts 70+ files into a sharepoint folder from that folder the flow runs as above and moves the files to specific folders based on name as follows
File1 - ABCD1234
File2 - BCDA2341
File3 - CDAB3412
File4 - DABC4123
Now the files go into folders. File1 will go to folder 4, file2 got to folder 2, file 3 go to folder1, file4 go to folder3, etc for the 70+ files.
I'm sure there is a better way to accomplish this but very new to power automate. Took me almost a month to get this process to work with the assistance of another forum user.
But this is how its working now just very slow will take a week to move the files to folders at the moment if at all.
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.