Power Platform Community Forum Thread Details

Slow performance in Get attachments and Apply to each after turning pagination on for another flow

I have several flows that we running just fine with Get attachments and Apply to each. I added a new scheduled flow, to run once per day and update utcNow() in a column so that a formula is calculated based on the day. Had to turn on Pagination and set Threshold to 1000 to get all lines in Sharepoint updated, but ever since all the other flows started low performing. Some of the runs have been running for days now and many failed. Tried turning Concurrency Control on and setting Parallelism to max but didn't work.

What is the connection and how do I solve? Thanks!!

Hi @gabrielalu ,

According to your statement, seems your flows touch SharePoint connector throttling limits already.

For SharePoint part, it can only afford 600 calls and 1000 megabytes each 60 seconds, per connection. When your scheduled flow is started to update the 1000 items in SharePoint list, it will queued up calls from other flows.

Please refer to this document for details: SharePoint - Connectors | Microsoft Learn

Other than SharePoint limits, your license may have limits for total actions each day. If a cloud flow exceeds one of the limits, activity for the flow will be slowed and will automatically resume when the sliding window has activity below the limit.

Please refer to "Throughput limits" part for details: Limits and configuration - Power Automate | Microsoft Learn

Throttling limits of connector cannot be changed, you may need to modified your flows/Sharepoint list to adapt to it.

As for performance profile, you can escalate your license level to get higher throughput limits.

Refer to this link for detailed resolution: Troubleshooting Slow Running Flows - Microsoft Support

Best regards,

Wenjuan Zou

Quick Links

Leaderboard > Power Automate