
Announcements
I want to create a trigger condition for "only trigger flow if lookup column does not equal this value."
Note: I am not interested in changes in the lookup, only its value.
The trigger is: when a Sharepoint item is created or modified.
To filter objects in a Get items action, this works:
LookupColumn/ReferenceColumn eq 'X'
So I tried, for the trigger condition:
@equals(triggerBody()?['LookupColumn/ReferenceColumn']?['Value'], 'X')
But that is simply ignored and the flow runs on every change, regardless of the vaule in the lookup column
I'm doing something similar where if a specific supplier is selected from the lookup value then a flow runs to alert that this particular supplier is the current selection.
I'm not sure if
LookupColumn/ReferenceColumn
is the name you're actually using or you've used it a placeholder, but for me this trigger is working
@equals(triggerOutputs()?['body/ColumnName/Value'], 'X')// If the value is X then flow triggers
to change for your requirement of NOT running on this value
@not(equals(triggerOutputs()?['body/ColumnName/Value'], 'X'))// If the value is not X then flow triggers
change ColumnName to the name of your column and X to the value that your require:
My example trigger for reference:
@not(equals(triggerOutputs()?['body/Supplier_x0020_Name/Value'], 'Supplier Name Here'))