web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Trigger Condition Help
Power Automate
Unanswered

Trigger Condition Help

(0) ShareShare
ReportReport
Posted on by

Hello,

 

My goal for a flow is to update a SQL table when with information from Dynamics CRM. The trigger is when a choice goes from No to Yes. I am trying to set a trigger condition to reflect that but I am unsure on how to set it. Attached is a photo of the field that changes. When the approval field gets changed to yes or essentially when that column in that row gets updated, that needs to be the trigger!

 

Any help would be much appreciated!

Screen Shot 2021-05-26 at 10.03.39 AM.png

 

Screen Shot 2021-05-26 at 10.03.56 AM.png

 

Categories:
I have the same question (0)
  • Expiscornovus Profile Picture
    33,474 Most Valuable Professional on at

    Hi @Anonymous,

     

    First of all you want to setup a column filter. Make sure you configure it to use the approval column in your trigger action.

     

    columnfilter_triggeraction.png

     

    Step two is checking what the value is of the updated approval column. We need to make sure it is Yes. For that we can use a trigger condition.

     

    Just to double check. Your field is a choice field and not of type Yes/No, correct?

     

    If so, you could use an expression where you check the choice value Below is an example.

     

    Replace approval by your internal field name and 1 by the choice option value of your choice list.

     

     

    @equals(triggerOutputs()?['body/approval'], 1)

     

     

     

    Otherwise if it is a yes/no type of field you can simply use this:

     

     

    @triggerOutputs()?['body/approval']

     

     

     

  • Community Power Platform Member Profile Picture
    on at

    Hello, 

     

    I apologize for not specifying, the field name is:

     

    po_createjob

     

    and it is a Yes/No Field!!

  • Expiscornovus Profile Picture
    33,474 Most Valuable Professional on at

    Hi @Anonymous,

     

    In that case this expression should be sufficient as a trigger condition. 

     

    @triggerOutputs()?['body/po_createjob']

     

    Don't forget to add the po_createjob to your column filter field as well.

     

  • Community Power Platform Member Profile Picture
    on at

    If I only wanted to trigger the flow if the column updates to yes would I do something like this? Or is this formatted improperly 

     

    Screen Shot 2021-05-26 at 11.33.47 AM.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 339 Super User 2025 Season 2

#1
trice602 Profile Picture

trice602 339 Super User 2025 Season 2

#3
David_MA Profile Picture

David_MA 270 Super User 2025 Season 2

Last 30 days Overall leaderboard