web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : BkWezC/2ctRysr6W8bxAHA
Power Automate - Using Connectors
Answered

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

Like (0) ShareShare
ReportReport
Posted on 5 Apr 2023 07:48:45 by

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!!

I have the same question (0)
  • Verified answer
    v-wenjuan-msft Profile Picture
    Microsoft Employee on 06 Apr 2023 at 06:17:41
    Re: Slow performance in Get attachments and Apply to each after turning pagination on for another flow

    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

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

MS.Ragavendar – Community Spotlight

We are honored to recognize Ragavendar Swaminatha Subramanian as our September…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 783 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 515 Moderator

#3
trice602 Profile Picture

trice602 299 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics