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...
At the moment flow that triggers when a specific SharePoint column is changed. A UserVoice request for it is at https://powerusers.microsoft.com/t5/Flow-Ideas/Trigger-flow-When-Item-is-Modified-only/idc-p/239328#M12798
Possibly the only thing you could do is to start with a recurrence schedule, perhaps to run once or twice a day, then add a Get items action from the SharePoint list, then add a condition that if the field you are interested in equals Yes then send an email, otherwise don't. So it won't happen as soon as the column in the SharePoint list is modified but it will trigger soon after.
Rob
Los Gallardos
oh ok thanks
Would you have details on how to setup the recurring schedule?
For the first item in the flow type recurrence into the box and select Recurrence Schedule. Set the frequency - in my image below it's set to once a day but could be several hours or even after x minutes.
Then set your time zone and the time it needs to run. After that do your Get items action and the rest of the flow.
Rob
Los Gallardos
