Get choice column value (not label)

(0) Share

Report

Posted on by CU17101437-0

Hi,

I am new to power apps and I am trying to solve a few issues.

I have a dataverse table with a choice column. For each value of the choice column we assign a label. Is there a way so that in power apps I can get the value of the choice (not the label) and compare it. In the dataverse table in a formula column if I call the choice column I automatically get the value. However, in power apps I do not see the option to get the value.

Any help on that would be much appreciated.

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Gabriel G. 831 Super User 2025 Season 2 on at

Like (1)

Report

Hi!

You can use JSON to get the option value:

JSON(yourOptionset)

As an example of mine:

JSON(First(Choices(Reservation.Status)).Value)

First(Choices(Reservation.Status)).Value

I hope it helps!

_________________________________________________________

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.

Was this reply helpful? Yes No
MS.Ragavendar 4,983 Super User 2025 Season 2 on at

Like (1)

Report
Hi,

A choice column in Dataverse treated as Record since it has two parts:

Label: The user-friendly text displayed in the app.

Value: The underlying numeric or string value associated with the label.

so you must explicitly reference .Value.

If your choice column is called Status, you can get its Value like this - ThisItem.Status.Value

If you want to filter records where Status.Value = 2, you would use Filter('Dataverse Table', Status.Value = 2)

Hope this helps. Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item.

Was this reply helpful? Yes No