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.