Get Selected item texts from a multi select choice field | choices in power automate
In Microsoft DataVerse we can use Choices data type to allow multiple selections for a specific field for example below I have a Choices field called as Degree where you can select multiple items.
Now if you will read the Degree values it will give you the under lying values so to get the selected texts you have to use the below code. if you check the output code of a retrieve record step you can see the below two lines for every Choices field.
“cr8eb_degree@OData.Community.Display.V1.FormattedValue”: “MCA; MBA”,
“cr8eb_degree”: “365500000,365500001”,
SO to read the text you have to use below code
outputs(‘Get_a_row_by_ID’)?[‘body/cr8eb_degree@OData.Community.Display.V1.FormattedValue’]
In my example I have updated the variable step as above expression and I can see the text after testing the flow.
Now after testing this I can get all the selected items as below.
Now I can use Split function to get separate values for my logic.
Hope this helps