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 basically says "ID 123" has changed
Any idea how this can be done?
Based on your original details, this sounds like a pretty straightforward Flow.
Here is how I understand your question and the result you are looking for:
1. An item in a SharePoint list is modified
2. If a specific field value is changed to "Yes", then send an email.
You can accomplish this with the following steps in Flow:
1. When an item is created or modified (set this up for your specific list)
2. Condition (check to see if your field is equal to "Yes")
3. If the condition is true/yes, then use the Send an Email action
4. If the condition is false/no (your field does not equal "Yes"), then do nothing.
This Flow will run every single time that an item is modified in your list. However, it will only send the email if your field value is equal to "Yes".
If there are more nuances or requirements to the Flow scenario you are trying to create, please include them here. Otherwise, based on the initial ask, I believe this will suit your needs.
- amazing tip - is there a way to run a condition for the same value across multiple columns?
I have built a MS form with 40+ questios - each question answer is "yes", "no" or "maybe"
I have built the PA flow to do
'When a new response is submitted >>
get response details >>
Create Item (Sharepoint)
I've then put a condition then Send to email as you mention above...i've tested by putting in ONE dymamic field from the Get Response Detasils.....it works........BUT i want the condition to look across the full sharepoint list entry and trigger the email when ANY of the SP columns contain a "no"
Please help !! I created a similar flow that sends an email when a condition in a Share point list column is met i.e. send an email when 'status' eq replenish, send an e-mail. I used a scheduled flow but the problem is it keeps going through the entire table as scheduled and sends to the same people repeatedly except I delete the row. Is there a way to check only a new row and send a mail if condition is met?
- what if, when my column change i want to send an email that states the value of the column.
Ex: Column A will be the remarks column.
so when user add a list on sharepoint, after then i will edit the the remarks field then when it saved it will send an email to the user
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 Gallardosoh 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
