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'
Rob Ellis I realise this is an older thread, but I am just wondering exactly how to follow your instructions. I have completed everything as mentioned above but am probably to new to this to realise the steps needed.
Do I create a new column in my list called 'FlowHasRun'?
Is there a step in the Flow that actually sets the value of the column in the SharePoint list?
Any help would be great thanks
- You're exactly right - you need a column in the list called 'FlowHasRun' (or whatever you want to call it) - then have a SharePoint 'update item' action in your Flow that sets the value.
