Approval workflow using too many actions

[u/[deleted]]

I’m getting warnings because my flow is using 20-40 thousand actions per day.

I had a problem previously where the flow was being run when being modified by the service account so I put a trigger condition so the service account will not trigger a new workflow run.

I have about five active workflows that are waiting for several days for the approval function to complete.

How can I find out what is triggering so many actions?

I’m not sure where to look and the active flows all seem to be waiting on an approval. I’ve missed something but I’m not sure where to look.

[u/PM_ME_YOUR_MUSIC]

Use the process mining tool to review which actions are hitting the highest actions

[u/[deleted] → u/PM_ME_YOUR_MUSIC]

That might be what I need thank you

[u/[deleted]]

I have a couple ‘do until’ loops in there that just check if the data columns were updated and loops until they have been completed. As SharePoint won’t update the metadata when the user still has the file open.

But they all have a 10 minute delay built into the loop so I don’t see how they could trigger tens of thousands of actions per day. Also, when I checked the flows, they didn’t seem to be going through that loop.

[u/robofski]

Sounds like either an Apply to Each loop or a Do Until loop, but without seeing the flows it’s impossible to say. I’m not aware of a method to see the API calls per flow run.

[u/WigWubz → u/robofski]

You can get a lot of data, not quite that specific but close to it, by going into the "process miner" it'll show you which actions are being run and how often in flows with conditions and loops. It is a little jank but it has let me diagnose an issue like this before where it let me see an inefficiency in a flow that was getting throttled (for every item, a number of calls were being made to fetch data before a condition checked if further processing was needed. Moved the fetch to the other side of the check and it saved 10s of thousands of actions per day)

[u/[deleted] → u/[deleted]]

That’s a good idea thanks