cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Oskarkuus
Super User
Super User

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

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

1 ACCEPTED SOLUTION

Accepted Solutions
v-bacao-msft
Community Support
Community Support

 

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,

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

View solution in original post

3 REPLIES 3
Pstork1
Dual Super User
Dual Super User

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



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

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

v-bacao-msft
Community Support
Community Support

 

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,

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

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,314)