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

Like (0) Share

Report

Posted on 27 May 2021 12:25:56 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!

I have the same question (0)

All responses (5)

Answers (1)

asdfaf4 on 11 Mar 2024 at 15:39:49

Like (0)

Report

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

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
ar87 353 on 23 May 2023 at 15:27:11

Like (2)

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

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
FelipePanza 84 on 13 Oct 2022 at 18:48:15

Like (0)

Report

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

@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
DVader 6 on 27 May 2021 at 14:22:57

Like (0)

Report

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

@Expiscornovus Thanks so much. That worked!

Was this reply helpful? Yes No
Verified answer

Expiscornovus 32,563 Most Valuable Professional on 27 May 2021 at 13:29:37

Like (6)

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

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