Answered

How do you get the text value for a Choice field in a Power Automat Flow?

(0) Share

Report

Posted on by DVader

In our Power Apps application we have a Choice Field with three options.

As part of our business process we have a Flow that populates a Word template that gets e-mailed. In the flow I have an "Initialize Variable" step that is supposed to get the value from the choice shown above.

But instead of getting the text value I'm getting the internal ID for the Choice.

What do I need to do to get the text value for the choice and not it's internal ID?

Thanks!

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

Expiscornovus 33,876 Most Valuable Professional on at

Like
a
(6)

Report
Copy link

Link copied!
Hi @DVader,

You could use an expression to retrieve the label via the OData.Community.Display.V1.FormattedValue.

Below is an example with customertypecode.

The value would be:

outputs('Get_a_row_by_ID')?['body/customertypecode']

The label is:

outputs('Get_a_row_by_ID')?['body/customertypecode@OData.Community.Display.V1.FormattedValue']

Was this reply helpful? Yes No
DVader 6 on at

Like
a
(0)

Report
Copy link

Link copied!

@Expiscornovus Thanks so much. That worked!

Was this reply helpful? Yes No
FelipePanza 84 on at

Like
a
(0)

Report
Copy link

Link copied!

@Expiscornovus Hi, I tried your method with List row, but I do not work. Does it only with Get ro by id?

Was this reply helpful? Yes No
ar87 353 on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @FelipePanza,

this post is quite old, but in case you still need a solution, you could try retrieving the value of choice field with the following formula:

first(outputs('List_rows')?['body/value'])['column_name@OData.Community.Display.V1.FormattedValue']

Was this reply helpful? Yes No
asdfaf4 on at

Like
a
(0)

Report
Copy link

Link copied!

Microsoft keeps making massive design mistakes. All display values used to be provided years ago by using the native Dynamics 365 Action or the first batch of Dataverse Action (the purpose or grey ones). Now, it's ten times more complicated to get those basic values. BAD MOVE... Why not display them in the picker? Why? No one from the product management is answer such question.

Was this reply helpful? Yes No