Unanswered

Trigger Condition Help

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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:

General topics

I have the same question (0)

All responses (4)

Answers (0)

Expiscornovus 33,801 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
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.

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']

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello,

I apologize for not specifying, the field name is:

po_createjob

and it is a Yes/No Field!!

Was this reply helpful? Yes No
Expiscornovus 33,801 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No