cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Flow to add 7600 items in a Sharepoint list is slow

Hi,

 

I need to add 7600 items in a Sharepoint list.

 

In my flow, I use 2 "Apply to each" actions :

  • first one gives19 items
  • second one gives 400 items

Total items to add is 7600 items =19 * 400

 

In order to provide the execution speed of the first "for each", I set Concurrency Control to "On" and "Degree of Parallelism" to 20 

 

But the flow duration is 27 minutes.

It seems to be a long duration ... what do you think about ?

for each.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User II
Super User II

The SharePoint REST API has stringent throttling limits that affects the speed of large batch jobs. With that said, your performance is directly related to the fact that you are utilizing nested loops. Also, Degree of Parallelism can be raised up to 50 - so you may want to give that a shot. 

ConcurrencyControls.PNG

Please review the Limits and configuration in Power Automate documentation and this Tuning your Flow for performance blog post for more.

👨🏻‍💻 If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION ☑️. If you find this reply helpful, please consider giving it a LIKE 👍.

View solution in original post

2 REPLIES 2
Highlighted
Super User II
Super User II

The SharePoint REST API has stringent throttling limits that affects the speed of large batch jobs. With that said, your performance is directly related to the fact that you are utilizing nested loops. Also, Degree of Parallelism can be raised up to 50 - so you may want to give that a shot. 

ConcurrencyControls.PNG

Please review the Limits and configuration in Power Automate documentation and this Tuning your Flow for performance blog post for more.

👨🏻‍💻 If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION ☑️. If you find this reply helpful, please consider giving it a LIKE 👍.

View solution in original post

Highlighted
Community Support
Community Support

Hi @manu59 ,

 

Please take a try with @Brad_Groux 's solution.

 

Best regards,
Alice       
 
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (12,999)