web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Trigger condition for ...

Power Automate

Answered

Trigger condition for lookup column

(0) Share

Report

Report

Posted on by MM-05080756-0

442

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

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Craig Stewart ABZ 959 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
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'))

Was this reply helpful? Yes No

Join the conversation