cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Symira
Helper III
Helper III

Foreach Loop speed

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

4 REPLIES 4
VictorIvanidze
Community Champion
Community Champion

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?

--------------------------------------------------------------------------------------
Contact me if you are interested in custom Power Automate development.
Symira
Helper III
Helper III

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
Community Champion
Community Champion

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

--------------------------------------------------------------------------------------
Contact me if you are interested in custom Power Automate development.

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

Symira_0-1651655207845.png

 

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

 

 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (1,534)