cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
calvares
Impactful Individual
Impactful Individual

Why is my flow running an infinite loop?

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...

One of the conditionsOne of the conditionsversions in sharepointversions in sharepoint

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?

4 REPLIES 4
Pstork1
Dual Super User
Dual Super User

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.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
calvares
Impactful Individual
Impactful Individual

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?

 

Thanks!

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

Power Automate Trigger Conditions made EASY - Power Platform Community (microsoft.com)



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
hemrhk
Responsive Resident
Responsive Resident

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:

https://365stack.in/index.php/2021/12/12/how-to-stop-infinite-flow-trigger-in-power-automate-using-f... 

CSOM Update:

https://365stack.in/index.php/2021/12/31/how-to-stop-infinite-flow-trigger-in-power-automate-using-c... 

Multiple Lines of Text as Flag Column:

https://365stack.in/index.php/2021/12/30/how-to-stop-infinite-loop-using-in-power-automate-using-mul... 

 

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power automate tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Users online (2,417)