Forum Discussion
SharePoint list flow that triggers an email every time an item is modify (even the same item)
llopez685 in your flow you can check if a specific column has been changed. First you need to make sure that you have turned versioning on for your list in List Settings.
In your flow the trigger should be "When an item of file is modified". The first action will be "Get changes for an item or a file (properties only). For the Since and Until fields you select the Trigger Window Start Token and Trigger Window End Token from the dynamic content:
Next you need a condition to check if the specific column (or columns, you can put more than 1 in the condition) has changed. So in the image below we want to check if the Completed column has changed. We are also checking if the Completed column - a Yes/No column - is set to Completed.
In this example we're setting the Status column to Archive but your real life version will have different actions.
Usually when working with Yes/No columns in a flow you need to use true (for Yes) and false (for No).
Rob
Los Gallardos
Microsoft Power Automate Community Super User
RobElliott, Thank you very much for your response. I fallowed your flow and it is not working for me. This is the flow I created. I just need the Column Email sent to update from NO to YES after I update the Column Event Status from Blank to Technician Assigned and the stop sending email after I update the same item with any other information.
Thank you,
Louie