How to trigger only on particular Multiple choice value?

[Kran]

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?

[Expiscornovus]

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.

[Kran]

@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.

[Expiscornovus]

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 😅

[Kran]

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

[Raia-K]

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...