How to get OptionSet/ Choice text from DataVerse in Power Automate

Microsoft have recently introduced an easier way to get the choice text. Check this blog out.
If you can’t see this feature yet in your environment and you need an alternative way, please continue reading.

I am back with another blog on Power Automate and this time it’s again a question from citizen developer. I get this question every time I conduct Power Automate sessions with citizen developers.

When I show DataVerse and retrieve columns of various types inside DataVerse, the first question that usually come up is – How do I get the Optionset Text?

Let’s take a very simple example here.

I have a table called Visit Requests and inside this table I have column – Relationship of type Choice (formerly optionset)

When I retrieve this table using DataVerse connector in Power Automate, I get a field called Relationship.

In the below screenshot, I am iterating through the list of Visit Requests records and taking the value of Relationship for each row of Visit Request.

But what I get in return is the choice value.

How can I get the text then? To understand that, let’s explore the raw output here.

If you check the raw output, below is the JSON output of the same.

To get the text, all I need to use an expression.

items('Iterate_visits')['cr444_relationship@OData.Community.Display.V1.FormattedValue']

If you ask me, it’s cakewalk for a Dynamics 365/ Power platform developer. But for a citizen developer, this is kind of tricky. Also tricky is the regular question as to why there can’t be a property exposed to get the text value.

The above example holds good if you are using the List rows and iterate through record. What if you use ‘Get a row by id‘ action.

outputs('VisitRequest')['body']['cr444_relationship@OData.Community.Display.V1.FormattedValue']

Here VisitRequest in the above expression is the name of the ‘Get a row by id‘ action.

Hope this helped!

Debajit Dutta
Business Solutions MVP