Has anyone found the reason why the foreach loop in Power Automate Flows is so slow? Has any one found a way to speed it up? It is quite a pain!!!
Well, you know, any Power Automate action is quite slow.
It might be you do not need to use "For each" at all. Could you show your flow?
Thanks for your reply.
There are a lot of flows, which I have to use for continuous dataintegration from external databases (SQL etc.), where I query rowsets from the source and loop over them to update records in most cases in Dataverse tables. A simple and straightforward use case but so slow...
Have a look at this example: https://powerusers.microsoft.com/t5/Using-Flows/Slow-running-of-Apply-to-each-only-joining-data/m-p/...
Thanks. This is indeed a tempting idea. But, but looks like I am not getting something.
I create a flow, and SQL action to list rows.
Now you mean I can update the Dataverse rows without a loop? That would be amazinig!!!
Eager to read your views.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
The Super User program for 2022- Season 2 has kicked off!