Run a flow when an item is updated and the value of a column equals a defined value
Case one:
add a condition in the flow:
Case two
run the flow only if condition is met.
conditional trigger, add a condition to my trigger
equals(triggerOutputs()?[‘body/Status/Value’], ‘Analysis’)
multi condition
@and(equals(triggerOutputs()?[‘body/Status/Value’], ‘Draft’), equals(triggerOutputs()?[‘body/Status/Value’], ‘Task’))
@or(equals(triggerOutputs()?[‘body/Status/Value’], ‘1-Draft’), equals(triggerOutputs()?[‘body/Status/Value’], ‘2-Task/Team Review’))
Run a flow when an item is Updated and the a column value is changed
Create new field: runtheflow
add it to the form temporary
and for the default value check if you are editing the form
I want to change only when Category value is changing
Find the default value of Category = ThisItem.Category
Get the changed value:
click on the dropdow get the DataCardValue2.Value
Go back to runtheflow default and add
&& DataCardValue2.Selected.Value <> ThisItem.Category.Value
All toghether:
If(SharePointForm1.DisplayMode=DisplayMode.Edit && DataCardValue2.Selected.Value <> ThisItem.Category.Value,”yes”, “no”)
——————
Create a condition to run the trigger only if runtheflow = “yes”
@equals(triggerOutputs()?[‘body/runtheflow’],’yes’)
add the condition to flow settings