Condition to prevent flow from running

[kylebunkin]

Good morning,

I'm currently building a flow which triggers off an email message when specific columns of a Sharepoint list are updated.

As part of the criteria, I do not want to trigger this message off when the item is created or deleted - I believe I've covered this issue properly by using this condition:

I now have a column called Grade, which is a choice column. I do not want to trigger the workflow when this column is changed - I think I've got a bit confused with my logic so looking for assistance.

In short the workflow needs the following conditions to work in unison:

If the Item is Created or Deleted - do not complete workflow

If the column Grade is modified - do not complete workflow 

[BCBuizer]

Hi @kylebunkin ,

Hopefully this post helps: https://powerusers.microsoft.com/t5/Power-Automate-Community-Blog/Power-Automate-Trigger-Conditions-...

You should be able to use this to terminate the flow in case Grade has changed. Be careful though, if other fields than Grade have been changed, the flow may also be terminated, so perhaps you need to add some more conditions.

[grantjenkins · Accepted solution]

If you want to control the flow based on a particular field not being changed then you would need to use Get changes for an item or a file to check if the value has changed since last time.

Below is how I would build the logic. Note that When an item or a file is modified won't trigger when an item is first created - it will only trigger when you modify an existing item.

Also, if you change the Grade, the flow will still run, but in your condition you can set it to not proceed with the flow. There isn't a way to do this with a trigger condition (changes to fields) as far as I know.

When an item or a file is modified will only trigger if you modify an existing item.

Get changes for an item or a file (properties only) will allow you to check which field values have changed since the last time the flow ran.

Condition will check if my field value has changed. In my example, I'm checking if my Vessel Choice value has changed - this would be your Grade Choice field.

The actions you put within the Yes branch will only run if you modified an existing item and the Choice field wasn't changed. In my example, I'm just outputting the Title field for testing purposes.