Unanswered

Trigger Condition for equals specific column field value

(0) Share

Report

Posted on by MMORGAN

Hello, I'm new to Power Automate and looking for assistance on a trigger condition when the field value equals one specific value, The column name is Approval Status, and value is Approved. I have the flow working working, but it triggers every time any field value in the column is modified.

I have tried to write the input but it errors each time. Any assistance would be greatly appreciated.

Thank you in a advance, MM

Categories:

Power Automate Desktop

I have the same question (0)

All responses (6)

Answers (0)

eetuRobo 4,484 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

If I understand correctly you are trying to create Power Automate cloud flow and not Power Automate Desktop flow since you are trying to create trigger condition? If so the appropriate forum would be Building Flows section and not Power Automate Desktop. This is for the desktop application and the Building Flows (https://powerusers.microsoft.com/t5/Building-Flows/bd-p/BuildingFlows ) is for the browser version of Power Automate (make.powerautomate.com)

Is the trigger Sharepoint "When an item is created or modified" or something else?
Maybe something like this: @equals(triggerBody()?['Approval Status']?['Value'],'Approved')

If that doesn't do it then maybe this thread could help: https://powerusers.microsoft.com/t5/Building-Flows/Triggering-flow-only-on-specific-Sharepoint-column-change/td-p/891580

Was this reply helpful? Yes No
MMORGAN 19 on at

Like (0)

Report
Copy link

Link copied!

You are correct, Power Automate cloud flow (as I said, I'm new).
I am using the trigger SharePoint "When an item or a file is modified". I tried your code (thank you) and unfortunately, it didn't trigger anything. I've reviewed the provided thread (thank you, again) and tried a few various, all with no luck.

Was this reply helpful? Yes No
eetuRobo 4,484 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

No worries. Naming of Power Automate and Power Automate Desktop is very similar even though they are very different product.

So it doesn't trigger at all and there is no error message? And you have made sure that you changed the Approval column status to Approved after you saved the trigger condition?
Have you tested the trigger without any trigger condition? So that we can be certain that the problem is the trigger condition.

If the trigger condition is preventing the flow from triggering then I think its either the syntax or a typo(maybe the column name or value). Or the value in that column is not being modified to that certain value.

Was this reply helpful? Yes No
MMORGAN 19 on at

Like (0)

Report
Copy link

Link copied!

It doesn't trigger at tall. No error. I've reviewed the column names and values, no issue. I've also tested without any trigger condition and changing any status in the Approval Column does trigger the automation. Knowing that it is the trigger condition, I'm at a loss how to modify to get it to work.

Was this reply helpful? Yes No
MMORGAN 19 on at

Like (0)

Report
Copy link

Link copied!

Here are a few iterations I've tried so far:
@equals(triggerBody()?['(ApprovalStatus)'],’Approved’)
@equals(triggerBody()?['ApprovalStatus']?['Approved'])
@equals(triggerBody()?['Approval Status']?['Approved'],'Value')
@equals(triggerBody()?['ApprovalStatus']?['Value'],'Approved')

Again, any help is appreciated,

MM

Was this reply helpful? Yes No
eetuRobo 4,484 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Maybe try this:
@equals(triggerBody()?['Approval Status']['Approved'])

Maybe try with triggerOutputs() instead of triggerBody
like this:
@equals(triggerOutputs()?['Approval Status']['Approved']
@equals(triggerOutputs()?['Approval Status']['Value']['Approved'])
@equals(triggerOutputs()?['body/Approval Status/value'], 'Approved')
And with these options maybe:

This could be useful: https://powerusers.microsoft.com/t5/Power-Automate-Community-Blog/How-to-write-TRIGGER-CONDITIONS-for-a-specific-text-or-choice/ba-p/1510429
What is the type of the column? Is it a choice column?

Was this reply helpful? Yes No