Slow running Flow - or not running at all

[Andrew260z1]

Hi All, I have a fairly busy flow that's task is to send email alerts based on when an item is changed and matches a criteria;

The flow was running OK but now has degraded to Slow performance and it might have cases where it doesn't run for hours or not run at all. The trigger is when an item is created or modified - there is a value in SharePoint that I am tracking a "Status" against a "Previous Status" and if those match then the flow bails out (no action is needed) so 80% of the time there is nothing happening. The flow can execute around 5000 times a day and perhaps send a couple hundred emails;

Im getting alot of instances where it just isn't doing anything and will show me that is stalled on doing something simple like just setting up a variable; Is it too much - I'm not really sure of tracking a way to send an alert other than to track a previous value against the current one - is the Per User Plan to light?

[rsaikrishna · Accepted solution]

@Andrew260z1 

We need to check the flow for following questions:

a. How many actions you have in the flow?

b. How often you are running the flow?

c. How many Apply to each loops you have in the flow?

d. How many other flows are running with same user account? How often they are running? How many actions they have?

Each action in the flow is an API call. There is a limit on the number of API calls per day. Also, in the Apply to each loops, there is a limit on the number of items it can process. 

Important note is each action has throttling limits and time duration.  

You can find the Power Automate configuration limits at https://docs.microsoft.com/en-us/power-automate/limits-and-config

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

[Andrew260z1]

Thanks - I reviewed the flow and have moved the blocks around so it only does the lookup calls if needed. Seems to be helping it run.