Dataverse web api retrieve text values instead of numeric label values for a multiple choices column

[Anonymous]

Hi, I am trying to retrieve a table from dataverse with web api of Dataverse. The table I want to retrieve contains some columns with multiple choice type. When I retrieve it i dont get the actual text value of the choice, instead I get a numerical value that is useless for me. WHat do I have to put in the query part of the url to get the values I want?

[v-kkf-msft · Accepted solution]

Hi @Anonymous ,

Please see if these documents are helpful.

https://docs.microsoft.com/power-apps/developer/data-platform/multi-select-picklist?tabs=webapi 

https://docs.microsoft.com/power-apps/developer/data-platform/webapi/retrieve-entity-using-web-api 

https://debajmecrm.com/how-to-get-optionset-choice-label-value-from-dataverse-in-power-automate/ 

https://sites.google.com/kushalnagar.net/d365/home/multiselect-option-set 

Best Regards,
Winniz