I have a list that contains a column named Status. If someone updates the status column an email should be sent. Is it possible to trigger a flow based on the column value of a list being modified? If not, would anyone have a suggested workaround?
One thought that I had was to have a second column that would contain the status the last time the list item was updated. My flow would be scheduled and would process only list items where the status column and the secondary status column did not match, meaning that the status had changed since the flows last run. The flow would send the email and update the secondary status column to match the status column. I was thinking about also creating a view containing only those list items whose status columns did not match so that the flow wouldn't go through the entire list each time it ran. However, I'm struggling with how to look at only the items in a view using my flow.
Yep, it is possible to trigger a flow when the status field is updated.
1. Create an automated flow with the trigger action as 'When an item is created or modified'
2. Click the '...' to open the menu and choose the settings. You are provided with the below form. Just update the 'Trigger Conditions' to run the flow when the status is equal to the specific value. In my case I had checked for the value as 'Pending'
3. You can use the above step or run the flow for each update or create and then check the condition inside the flow.
Hope it helps, please like it or mark it as a solution if it resolves ur clarification or issue -Sudharsan K...