Foreach Loop speed

[Symira]

Hi,

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!!!

Thanks

-S

[VictorIvanidze]

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?

[Symira]

Hi @VictorIvanidze 

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...

-S

[VictorIvanidze]

Have a look at this example: https://powerusers.microsoft.com/t5/Using-Flows/Slow-running-of-Apply-to-each-only-joining-data/m-p/...

[Symira]

Hi @VictorIvanidze 

Thanks. This is indeed a tempting idea. But, but looks like I am not getting something.

• Let's say I have a table in SQL with 5 rows, which reflects 5 rows in a Dataverse table (including id)
• Assume that the field "Year valid till" in the dataverse table is empty or not valid any more and needs to be updated

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.

Thanks

-S