Answered

How to get the name from a choice field in a Dataverse record instead of the value?

(0) Share

Report

Posted on by ac1drain

I'm using 'Get a row by ID' to populate an email action with information from a Dataverse record. One of the fields happens to be a choice field, but in the body of my email I'm getting the value of the choice (eg. 717750001) instead of the name.

I feel like I've done this in the past, but that would've been under the Microsoft Dataverse (legacy) triggers/actions so I'm not sure if there is something I need to be doing differently now?

Thanks in advance for the help!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (6)

Report

Hi @ac1drain

Try the below using the expression

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

Here above 'Get_a_row_by_ID' is my previous step action name and ajb_type is my option set field.

Thanks

Was this reply helpful? Yes No
ac1drain 42 on at

Like (1)

Report

Thanks for your quick reply @abm, worked like a charm!

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

thanks a lot it has worked for me as well

Was this reply helpful? Yes No