Thank you for visiting my site!

Home / Power Automate - Flows / Run a flow when an item is created and based on the value of a field

Run a flow when an item is created and based on the value of a field

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

ADD YOUR COMMENT