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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / timeout error in flow ...
Power Automate
Answered

timeout error in flow with large data sets and long calculations?

(0) ShareShare
ReportReport
Posted on by 1,097

I cant figure out why my flow is failing.

 

At exaclty 10 minutes i get the error "Flow run timed out. Please try again."

 

I have a very large data set, sharepoint list. It have about 40000 rows.

I do calculations with about 2000-4000 rows at a time. I cant filter it down any more.

 

I use get items connectior to the sharepoint list

then use the get items filter settings to filter on values in columns

then i use compose to count the rows

and a variable to increment values.

 

i have tried to put a delay after each apply to each, read somewhere that it could help to delay the flow if some kind of count limit?

 

i would be very sad if i cant use my flow since it is so awesome and do exaclty what i need 😄

 

 

pic.png

Categories:
I have the same question (0)
  • Pstork1 Profile Picture
    69,153 Most Valuable Professional on at

    Take a look at the following limits for Microsoft Flow.  I suspect you are running into issues with maximum processing limits and timeouts. You may need to refactor your application to be more efficient.  I would try to help, but the screenshot comes across at such poor resolution its impossible to make out any details.  You'll need to break it down into multiple images.

    https://docs.microsoft.com/en-us/flow/limits-and-config

  • Oskarkuus Profile Picture
    1,097 on at

    Here are a few pictures

     

    I took screens of the largest/heaviest calculations. The rest is way smaller.

    I have read about filter arrays but i dont understand how to use them together with get items....

     

    My flow is already sooo long it is hard to work in it. I wish there was a way to make it more compact and give a better overview when adding multiple stages like i do now.

     

     

    11.png12.png13.png14.png

  • Verified answer
    v-bacao-msft Profile Picture
    Microsoft Employee on at

     

    Hi @Oskarkuus ,

     

    You could try to set Apply to each and improve the degree of Parallelism to improve the execution efficiency of the action in Apply to each.

    Please take a try and see if this improves your current situation.

    Image reference:

    19.PNG

     

    Best Regards,

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 612

#2
Valantis Profile Picture

Valantis 344

#3
11manish Profile Picture

11manish 326

Last 30 days Overall leaderboard