Forum Discussion
Send a Mail When a Field in a SharePoint List has a value of Yes
Hello We have a SharePoint List that people can add to / edit etc... We want to have a Flow that monitors this list and when a field changes to Yes we want a email sent to a person that basic...
You could have the flow set the value of an extra column - e.g. set 'FlowHasRun' to 'True' - then check that value in the Flow, so the email is only sent if your column is 'Complete' AND 'FlowHasRun' column is 'false'
I have used this approach but my problem is the update the hidden field action via FLOW is essentially a modification, so TWO emails are sent.
