We often use sharepoint designer workflows to set list field values that we will examine later in the workflow, when the item is updated by the user at a later time. I just tried to to that with a Flow. The Flow triggers on item Creation or Edit, and then modifies several fields in the same list item. I am seeing that the flow is actually being triggered lots of times - it appears to be in a loop where the updates it makes to the list item triggers the Flow again, makes more updates, which triggers it again. Is this expected behavior? If so, is there a way around this?
Create a condition in your flow, switch to advanced mode, and add this:
@lessOrEquals(triggerBody()?['Modified'], addSeconds(triggerBody()?['Created'], 2))
That will check the modified date against the created date for the Sharepoint item. If the Modified is less than 2 seconds, then just don't set up any additoinal steps in the "yes" bucket. That way, when the flow does start again, it will just stop doing anything.
Thank you for the response I will give this a try. Where do I insert the condition? After When an iteam is created or modified? Then should I enter a condition "If no" and if so what should I do.
Sorry I am relativly new to Flow.
I can't believe this is the way this is supposed to work... am I missing something? Almost every workflow I would use involves a modification to the original list item
Interestingly, my flow retriggered six times before ending (or so I thought) by itself. Exactly one hour later, it started again and repeated for another six loops. Sort of like it detected the loop was endless and paused the workflow then restarted and paused again. I have since deleted the step that caused the retriggering but this is interesting behavior and worth taking note of.
I can't believe we need a workaround for this looping issue. This is something Flow needs to have built-in. I couldn't find a feature request in Flow Ideas, so I went ahead and created one.
They should make the When an item is modified a thing and use a check if you don't want to fire the Flow again if you update the item or file.
I still can't believe we need to have workarounds for this, and those workarounds are not that reliable at times.
If this reply has answered your question or solved your issue, please mark this question as answered.
Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.
What I would like to see is a service account able to be used for the Flow. If the update was by the service account exit the update flow, otehrwise continue. This would ensure that the flow does not trigger itself. I have users creating their own flows and not sharing with the team and this is starting to create a support nightmare. The latests was someone creating a flow to create an item when an item was created. This generated 50,000 + items as we had a public holdiay between when they created and published their flow. We now have accounts locked as they have sent to many emails and user inboxes that are unuseable due to the number of rogue emails sent.
Following on from this thread, do we know whether there is a workaround for this situation that causes the Microsoft Flow in a loop using the "When an item is created or modified" trigger?
Thanks so much
I actually rely on this feature to run a recursive flow. You can use a condition at the start of the flow so it knows when to stop. I hope this functionality is never removed.
Please check this link for you soulution -
Thank you for posting on the Flow Community Forum! Have you had an opportunity to apply @krishnangshu‘s recommendation to adapt your Flow? If yes, and you find that solution to be satisfactory, please go ahead and click “Accept as Solution” so that this thread will be marked for other users to easily identify!
Thank you for being an active member of the Flow Community!
Flow Community Manager
I'm using a control that compares 'current time' to 'modified' time as a workaround.
If the list involved a lot of users, contemporaneous changes might be missed for longer flows.
Check out the News & Announcements to learn more.
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.