I've had a flow running on an infinite loop and I don't know why it would be.
It runs when a SharePoint item is modified.
There is one condition - then a send email followed by an update item.
Then there is condition 2- send an email followed by update item.
The update item is for fields which says send email = yes which would prevent the condition running again.
The thing is, it runs again even when the conditions have been false and with no apparent updates to the item. The flow run shows many of them as cancelled. The attached shows the version history for one item - the last actual update was at 10.06 but then it continued...
I have put an extra condition now to run subsequent conditions if modified by is not equal to the flow author, but old flows are continuing to run. Will they eventually stop with this new condition?
It's undoubtedly the Update Item action causing the issue. Instead of adding a condition inside the flow you really need to fix this by adding a trigger query that checks the field you are changing to say it shouldn't be re-started.
for your second question. Changing the definition of the existing flow will not affect any of the flow instances that are already running. They will continue to run with the old definition. However, when they finish and restart the restarted flow would run with the new logic. So eventually it should settle.
Thank you for your quick and helpful reply @Pstork1.
I know you're right about Update Item being the issue but I just don't understand how it can cause it to run in loops if the action only ran the first time and not subsequently since the conditions weren't met.
Could you tell me more about how to go about adding a trigger query please?
I would need to take a look at your whole flow to figure out why its re-triggering if the update doesn't happen in the condition. But here's the best article at this point on Trigger Queries. Let me know if you have more questions after going through the article
There are multiple ways to stop the infinite loop in Power Automate, Kindly read the below articles for a better idea,
Power Apps Form and Flag Column:
Multiple Lines of Text as Flag Column:
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Did you know that you could restore a deleted flow? Check out this helpful article.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
At the monthly call, connect with other leaders and find out how community makes your experience even better.