Dynamics 365 CommunityForums Power Platform integration forum Multi Choice select co...

Multi Choice select column from Dataverse in a flow

(0) Share

Report

Posted on by Community member

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?

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

All responses (1)

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