
Announcements
I have a flow that I built incrementally as an instant flow. It's fairly simple, read a table from an excel file and insert or update (1200) rows in a sharepoint list. I added a condition check for the update which only updates the list if any specified columns change.
Without any rows to update or insert, the flow completed in 3 minutes as an instant flow. However, once I replace the manual trigger with a schedule recurrence, the flow runs for over an hour and I end up having to cancel it. I can't figure out why only changing the trigger condition has affected the performance. Any ideas how to check?
Hi @cl250
What we need is to see a Flows runtime (not a number but the run)
Please do the following
1. Go into your Flow
2. Change it to the Old UI from the New UI (top right corner)
3. save it
4. Go to the Details Page
5. First, click the Show All Runs on the right
6. when it comes up, look and verify none are already running etc. (filter by running top right)
Ok after you verify nothing is running, pick one of the flows that you said ran forever
open that run
Now, let's take a screen shot(s) so the whole run is pasted in. We want to see which actions are taking up all the time and or are timing out, or doing retries.
Because for it to be running for an hour its stuck somewhere and shouldn't.
If you can do that real quick can definitely help.
If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others
Cheers
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey