Parallel Loop in Power Automate (Microsoft Flow) – Degree of Parallelism

Hi Everyone,

Today I was exploring something on flows and came to know about “Degree of Parallelism”. Here is the more information on the same.

There are many situations, we might loop through the records and do some operation. In this example, I am retrieving records from CE and updating them by looping through each one and it took 2 minutes to complete the operation sequentially. That means only one child record is processed at a time.


We can improve the performance of this by enabling “Concurrency Control” and setting “Degree of parallelism” from Apply Each control settings.


Once we apply the setting, it took only 6 Seconds in my scenario after setting the degree of parallelism to 20 (Max value is 50).


Hope this helps.


Happy 365’ing

Gopinath

2 thoughts on “Parallel Loop in Power Automate (Microsoft Flow) – Degree of Parallelism

  1. viswa April 8, 2020 / 12:57 am

    Hello Gopi,
    Thanks for the info.
    then why don’t we to put it to max value to make it more better always ?

    Like

    • Gopinath April 28, 2020 / 9:50 am

      Hi Viswa,

      Good thought. I think, that might impact the performance of the system. End of the day, the query should run in SQL to get the results and it will have some impact there with the max value. Thanks.

      Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s