This is a simple Sharepoint list add/edit item approval loop
But despite its simplicity, it`s falling to loop and sending itself twice. So I receive an approval email when I approve it change the status on SharePoint list from Pending to Approved
But then without a reason, I receive a second email asking for approval for the same item despite that the status on the site is already approved.
I got only one flow active in my flow list
This is how the SharePoint list approval setting look like
It looks like it's looping because the final action of the flow involves updating the item that triggered the flow (setting the approval status). This action of updating the flow ends up triggering the flow again.
Can you discuss your requirements further? Are there any actual edits to the item happening or is approving on the initial create sufficient? If so you can change the trigger to "When an item is created".
If you also need approvals on edits, can you enforce that the user manually resets the approval status when they make edits? You can then add a check in the flow to terminate if the approval status is set to approved.
If that's difficult to get people to do, you might consider breaking out approvals status into a separate list which you can modify in the flow without re-triggering the flow.
Hope this helps!
I agree with the comments made by @TravisB but would like to add an alternative.
It sounds as though you want the Flow to run only when a new item has been created. If that is the case, your best bet is to change the trigger as to When an Item is Created as suggested by @TravisB. That will likely cause you to re-write most of your Flow. Alternatively, try putting a condition at the top of your Flow immediately after the trigger. The condition should compare the created and modified columns. If they are the same, then this is a new item and proceed with the approval. If they are not the same, then this item has been modified and you should do nothing and exit the Flow.
If this addresses your issue, please mark you post as Solved.
Thank you for posting on the Flow Community Forum! Have you had an opportunity to apply @ScottShearer‘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
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.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.