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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022- Season 2 has kicked off!

Users online (4,579)