Microsoft Dynamics 365 | Integration, Dataverse...

Multi Choice select column from Dataverse in a flow

(0) Share

Report

Posted on by Jennifer23

I am currently attempting to grab the actual labels of a multichoice selection Column of a Dataverse table and send them in an email. However, I can not get just one label. I have seen in other areas that if it is just a single choice table you can initialize a variable and use a switch however this does not appear to be an option for multi-selection. How should I go about this?

//// //// ////

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Dengliang Li Microsoft Employee on at

Like (0)

Report

Multi Choice select column from Dataverse in a flow

Hi,

You can get all the labels for a specific multi-select option set in a specific entity by sending a GET request to the following address.

[Organization URI]/api/data/v9.2/EntityDefinitions(LogicalName='[Entity Name]')/Attributes(LogicalName='[Your Field Name Which uses OptionSet]')/Microsoft.Dynamics.CRM.PicklistAttributeMetadata?$select=LogicalName&$expand=OptionSet($select=Options),GlobalOptionSet($select=Options)

In my testing, I get all the labels of the Forecast category option set in the Opportunity entity.

This can be implemented via power automate flow.

body('HTTP')?['OptionSet/Options']

items('Apply_to_each')?['Label/LocalizedLabels'][0]['Label']

If my answer was helpful, please click Like, and if it solved your problem, please mark it as verified to help other community members find more.
If you have further questions, please feel free to contact me .

Best Regards,
Dengliang Li

Was this reply helpful? Yes No
Dengliang Li Microsoft Employee on at

Like (0)

Report

Multi Choice select column from Dataverse in a flow

Hi,

Has the issue been solved?
Have there been any updates? Please feel free to ask me if you have any questions!
If it has been resolved, can you mark the response as an answer?

Was this reply helpful? Yes No
Jennifer23 4 on at

Like (0)

Report

Multi Choice select column from Dataverse in a flow

Hello no the solution did not work for me, I ended up filtering the arrays to get the departments

Was this reply helpful? Yes No