Flow runs a long time

[Frosty8467]

I have a flow that based on data in customer fields in the user table it generates records in a customer capacity table that stores 2 years worth of future availability for the user. Now sometimes the flow takes around 30 mins and works fine I get my 730 days worth of data so all good but other times the flow can run up to 4 hours finish saying it succeeded but it only creates at most 625 records or less.

The flow says its is succeeding so no errors it just seems to pause and stop working then after 3-4 Hours stops.

Any ideas Why?

Thanks in advance

Matt

[Sundeep_Malik]

Hey @Frosty8467 

Pretty unsure why this is happening.

Though I have two solutions for you, first is universal and second is topic wise:

1) If you are using Apply to each loop, you can use the feature called concurrency. So, currently your loop would be running 1 record at a time, but with concurrency you can work on 50 records at a single time which will improve the performance. 

To open the concurrency option click on the three dots of apply to each loop, then click on settings. 

Then open the option of concurrency and set the parallel limit to 50.

Note: If you are using a variable inside that loop, the concurrency feature won't work properly so, if you have any change it to compose.

2) Second method is limited to data coming from Excel files. So, if you are using Excel to get data, it's pretty slow in Power automate. For this you can make scripts that are pretty fast and will improve your performances a lot. Giving you a link for the scripts: 

https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/SQL-Batch-Create-Read-Update-and-Delete/...

I hope these techniques help you 🙂

Just one more thing, could be possible there is an action in your flow that is failing on the first attempt and then trying to connect again. And in the second try it must be connecting, probably for this power automate might not show an error. So this could be also responsible for more time taken.

So in retry it tries to connect for the first time, if it is not able to, it will stop for 5 minutes then try to again connect it, and if it fails again, then again it takes 5 minutes. So by default this happens 4 times. 1st failed, and then three more attempts.

[VictorIvanidze]

Could you show the flow?

[VictorIvanidze]

Could you show the flow?

[Frosty8467]

Sorry just to be clear the issue isn't that the flow takes so long it is the fact when it works completely it only take 30 mins but when it runs for 3-4 hours it only partially works but still says it completed successfully and I would like to know why it doesn't actually work it's like it just pauses and then ends. 

[Frosty8467]

I have added a pdf with the flow in it as it is quite large. 

[milenachen]

Hi @Frosty8467 

There are 3 performance profiles (Low/Medium/High) based on the license. For different performance profiles, you have different action request limits per time period. Your flow could have been throttled if your flow exceeds the limit.

How to check:

1. In your Power Automate portal, press Ctrl+Alt+A and search for "isCurrent": true to confirm the license in use.

2. Go to Limits and configuration - Power Automate | Microsoft Learn to check the performance profile based on the license.

3. Check flow details page => Analytics => Actions tab for the number of actions your flow has run.