Flows running very slow (multiple days)

Like (0) Share

Report

Posted on 29 Jun 2022 22:12:46 by jd71

Hi all

I'm facing an issue that i don't understand correctly.

I have a flow in a "per user plan" licensing

My flow is trigged when an excel file is added in a sharepoint library.

This flow is getting all the rows (4500) in the excel table and do an apply for each. The apply for each contain 11 steps which consist to compose some date format and check if the current record exist on a sharepoint list. If yes it's updating it, if no, it's creating it.

The flows running and take around 2 days sometimes to be in succes. I can see that sometimes the flow do some creates and updates in the sharepoint list and suddenly no more actions during hours ect....

I believe it's because the flow is limited with sharepoint api call but how can I be sure about it? How can I see how many calls are done? I've tried to check insights but it contains only time indicators and not call api indicators

Many thanks for help

I have the same question (0)

All responses (5)

Answers (0)

takolota1 4,931 Moderator on 10 Apr 2024 at 19:54:39

Like (0)

Report

Re: Flows running very slow (multiple days)

You would probably have better luck pulling the entire SP list into the flow with a Get items & using a Filter array action to check if items exist in that copy of the list data.

Also you may be able to take other parts of the 11 actions in a loop & use Select actions to alter data all at once.

Then you could also avoid looping for the Create & Update Excel actions by using Office Scripts / Excel batch actions: https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Excel-Batch-Create-Update-and-Upsert/td-p/1624706

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on 30 Jun 2022 at 11:24:09

Like (0)

Report

Re: Flows running very slow (multiple days)

Hi @jd71 ,
please open the Process Insights within your flow:

and then you'll see which action is causing the issue:

Refer also to this video:

https://www.youtube.com/watch?v=VNn0no9Y58c

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

BR,
Marco

Was this reply helpful? Yes No
jd71 on 30 Jun 2022 at 11:17:46

Like (0)

Report

Re: Flows running very slow (multiple days)

Hi @MarconettiMarco
I've already used Concurrency control but it didn't resolved the issue. The flow is still running but do nothing for hours. Still is reaching a limitation of api call or something like this.

I have a warning at the top of the flow that indicate me that the flow is reaching a limitation and is in slow performance and it will be deactived in 14 days.

How can I see which step of my flow is reaching the limit?

Best regards

Was this reply helpful? Yes No
MarconettiMarco 3,812 Super User 2024 Season 1 on 30 Jun 2022 at 09:50:30

Like (0)

Report

Re: Flows running very slow (multiple days)

Hello @jd71 ,
if there aren't constraints to perform the update concurrently, you can enable the concurrency control and set it to 50:

You can also refer to the following article:

https://vblogs.in/concurrency-control-degree-of-parallelism-in-power-automate/

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

BR,
Marco

Was this reply helpful? Yes No
365-Assist 2,316 Moderator on 30 Jun 2022 at 03:42:21

Like (0)

Report

Re: Flows running very slow (multiple days)

Try using the Process Insights
Also you can try Analytics in the Admin Center.
---------------------------------------------------
Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.
Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw
Twitter: https://twitter.com/assist_365
Regards
Darren Lutchner - 365 Assist

Was this reply helpful? Yes No