Forum Discussion
Send a Mail When a Field in a SharePoint List has a value of Yes
Rob Ellis I added the 'FlowHasRun' column to my SharePoint list but when I come to add the action to update that column to 'Yes', I get warnings in Flow Checker 'Actions in this flow may result in an infinite trigger loop. Please ensure appropriate conditional checks to prevent this flow from triggering itself'.
I have the following working from you description: Triggered by Created or Modified (I change a SharePoint list field to 'Yes'), Condition runs the workflow to 'Send an email'. I wanted to then update the SharePoint list item in the column 'FlowHasRun' to 'Yes' to ensure the flow doesn't get in a loop.
DarrenPlant I recommend you add a trigger condition in the settings of the SharePoint When an item is created or modified trigger. That way the flow will only trigger if the FlowHasRun column is equal to No. In my SharePoint list the FlowHasRun column is a single line of text column which defaults to No and the Update item action in the flow changes it to Yes. Because it's a single line of text column the trigger condition has single quotes around the 'No'. If you are using a Choice column then you'd need to replace 'No' with false:
@equals(triggerBody()?['FlowHasRun'],'No')
Rob
Los Gallardos
Microsoft Power Automate Community Super User
- Thank you all for the tips, I was able to set this up in Power Automate. Follow-up on this, is there a way to consolidate the emails get gets sent out when the field is changed?
For example, I have a user that will submit multiple requests, like up to 20. Once I've completed the task, I'll bulk change the line items in the Sharepoint List to Complete. With the flow created, I'm afraid that it will send an email for each of the request submitted. Is there a simple way to send just one email to the requestor that the line items are done instead of 20?
Thank you!
