Unanswered

How to trigger only on particular Multiple choice value?

(0) Share

Report

Posted on by kranis

174

I´m trying to find a way so my flow is only triggered when a particular value in a multiple choice column "status" is changed.

As of now, my workaround is to trigger it on every value change on that column, fetch the opportunity, and the check if the column contains the right choice value, otherwise terminate the flow.

But there should be an easier way to do this? Any idea?

I have the same question (0)

All responses (5)

Answers (0)

Expiscornovus 32,932 Most Valuable Professional on at

Like (0)

Report

Re: How to trigger only on particular Multiple choice value?

Hi @Kran,

That would be a combination of adding the status column to the Select Columns field and adding a filter for the choice value id in the Filter rows field.

In your case you already have added the status field in the Select columns. So, you would only need to add a filter.

Below is another example.

In my example I am using a custom choice field called Approval Status on the Accounts table. Whenever it is changed to Rejected (id 309310002) the flow will trigger. 309310002 is the id of the Rejected choice label. You can find that id in the status column settings in Dataverse.

Was this reply helpful? Yes No
kranis 174 on at

Like (0)

Report

Re: How to trigger only on particular Multiple choice value?

@ExpiscornovusThanks for quick reply!

I tried, but that seem to work only on single choice column. I have a multiple choices column and the flow does not trigger when I add the filter condition

This is how I selected from the Opportunity:

I have doubled checked so the choice value is correct.

Was this reply helpful? Yes No
Expiscornovus 32,932 Most Valuable Professional on at

Like (1)

Report
Re: How to trigger only on particular Multiple choice value?

Hi @Kran,

Apologies, I was using a single choice field and not a multiple choices field.

I see in the response of a Get Row by ID action that a multiple choice field value is actually a string value with some separators. We were looking for a number in the filter, which wasn't correct.

While a single choice value is a number.

So, in case of one selected value for a multiple choice field an eq could work if we use quotes around the value

In your example that would be:

completedstages eq '284430015'

With multiple values selected in your opportunities record you could try and use a substring of function in the filter query.

substringof('284430015',completedstages)

However, in my dev environment I did notice my multiple choice field values weren't included in the trigger action response. So, hopefully that is only a bug in my tenant and not a limitation 😅

Was this reply helpful? Yes No
kranis 174 on at

Like (0)

Report

Re: How to trigger only on particular Multiple choice value?

The field values are not included in my trigger action either ☹️

Was this reply helpful? Yes No
Raia-K 2 on at

Like (0)

Report

Re: How to trigger only on particular Multiple choice value?

Hi @Kran , @Expiscornovus ,
Did you manage to get the multiple-choice field?
I am facing something similar where I do not get my field in a Get a row by id action's outputs...

Was this reply helpful? Yes No