Power Automate Create record based on filter criteria

Question

I have a flow that is supposed to update OR create a record in list B based on if an item is added or updated in List A.

But I want only this to apply to a subfilter of list A, i.e. where a column A in list A = "Yes" then update or create. I am not sure how to build this into my functionally.

Here is my flow:

This is my condition statement: length(outputs('Get_Items')?['body/value'])

Answer 1

As mentioned by Chris in his answer, best and recommended way to achieve your requirements is to use the "Trigger conditions" in Power automate flow.

You can write flow expressions for this requirement in either of below ways:

1. Single trigger condition:

You can add all conditions in single expression like:

@and(equals(triggerBody()?['ColA'], 1234),equals(triggerBody()?['ColB'], 'Cool'))

2. Multiple trigger conditions:

You can also use +Add option to add multiple trigger conditions and those will be taken as And conditions by default:

@equals(triggerBody()?['ColA'], 1234)

AND

@equals(triggerBody()?['ColB'], 'Cool')

Answer 2

If you are saying you want the flow to run when an item is created/modified in List A but ONLY when Column A in List A = "Yes", then you can do this with a Trigger Condition.

1. In your trigger action (the first one) use the 3 dots menu in the upper-right and select Settings:

2. Click the plus beneath Trigger Conditions and add @equals(triggerBody()?['ColumnA'],true) replacing ColumnA with the actual INTERNAL name of the column:

Now the flow will only execute when Column A has a value of Yes. This keeps things simple but also prevents a Flow run happening when you don't need it.