It'd work something like this in Power Automate for a multi-select choice column:
Use a HTTP Request to the Dynamics endpoint for the Choice Set definition
This is to get the array mapping labels to values for your choice column.
The endpoint would be:
/api/data/v9.2/GlobalOptionSetDefinitions(Name='<your_choice_set_logical_name>')?$format=application/json;odata.metadata=none
You'd set up your connection for "Invoke an HTTP Request with Microsoft Entra ID" to be your dynamics base url.
i.e.
https://<your-domain>.crm.dynamics.com
Use "Select" to create a simple array of all the choices selected in your Sharepoint Multi Select Column
The "from" will be your SharePoint multi select column. For mapping switch to "text" mode and just drop in an expression for "Item()?['Value']"
Should look something like this:
When you run it, it simplifies your sharepoint item's selected options like this:
Filter your Dataverse Choice Set Definition Options array for those that are in the current SharePoint item's Selection
From is the "Options" array property of the response you get from the Dynamics API call with the Invoke and HTTP request action.
For your filter query check if the simple array we made in the previous step contains a matching label from dataverse.
item()?['Label/UserLocalizedLabel/Label']
Select the Matching Dataverse Choice Option Values from the filter
After the filter we have all the matching dataverse choices that share the same label with the current sharepoint multiselect choice column.
But we need to drop all the excess data and select only the numeric values in a simple array. This is done with another Select action.
Select from the output of the filter above, use the "text' mode and use the expression "item()?['Value]"
on a run, this simplifies the filtered dataverse options array like this:
Join the simple array of matching dataverse choice set values into a string by commas
To set the multi-select column in Dataverse we need the values separated by commas in a string. Use the Join() function to do this.
join(body('Select_Matching_Values_Only'),',')
The output on a run looks something like:
Add a new row in Dataverse
Just use the join(body('Select_Matching_Values_Only'),',') to set the multi select column, or if you are using a compose to store the value like I am you can just reference the output of the compose.
Example:
If this helped you, please click "Does this answer your question" and give it a like to help others in the community and close the ticket
Power Platform Developer | LinkedIn: Mark Nanneman | Blog: Power Stuff | YouTube: Mark's Power Stuff
