In the 'Send an Email (V2)' step of an Automated Flow, the 'Choice' fields display their code and not their value

(0) Share

Report

Posted on by AliceW

280

Hello everyone,

I have this Automated Flow triggered by a Dataverse table being changed ('When a row is added, modified, or deleted').

Basically, after the trigger, I am sending an email.

In the email body, I am selecting various field via the Dynamic content.

However, if the field is a Choice, the email includes the code for that value (say, '123480000' instead of 'Apples').

The field is also displayed once in the 'Dynamic content' list, so I am not choosing a wrong line...

How can I solve this, please? Surely I'm not the first person to have this problem.

Thank you!

Alice

Categories:

Business Process Flows

All responses (6)

Answers (3)

AliceW 280 on at

Like (1)

Report

Re: In the 'Send an Email (V2)' step of an Automated Flow, the 'Choice' fields display their code and not their value

Nathan, it actually works! Sweet, sweet victory!

I had to use the 'Tree 22''s unique identifier in the 'Get a row by ID' step, which you TOTALLY mentioned in your screenshot!

I had to reread it several times for it to sink in 🙂

Thanks again, man! You did a good deed today!
Verified answer

NathanAlvares24 1,673 Super User 2025 Season 1 on at

Like (1)

Report

Re: In the 'Send an Email (V2)' step of an Automated Flow, the 'Choice' fields display their code and not their value

@AliceW

See this:

Please Use Unique identifier for entity instance Dynamic value in Row ID Field of Get a row by ID Action which return By When a row is selected Action After this, I guess you are good to go.
Verified answer

NathanAlvares24 1,673 Super User 2025 Season 1 on at

Like (1)

Report

Re: In the 'Send an Email (V2)' step of an Automated Flow, the 'Choice' fields display their code and not their value

Hi @AliceW !

Can you show me the configuration of that action? Like this:

Then you can check if that table logical name is same in Power Apps only id gets added at the end:

It will be an id which is not one of your columns:
AliceW 280 on at

Like (0)

Report

Re: In the 'Send an Email (V2)' step of an Automated Flow, the 'Choice' fields display their code and not their value

Basically, if the Trigger is from the 'Tree 22' table, and I try to do a 'Get a row by ID' from the SAME table, it crashes.
AliceW 280 on at

Like (0)

Report

Re: In the 'Send an Email (V2)' step of an Automated Flow, the 'Choice' fields display their code and not their value

Hi Nathan,
First of all, thank you SO MUCH for your reply. Second, I'm not getting the 'Get a row by ID' step.
Like, the step 'When a row is added..' is taken from a table called 'Tree 22'.
I added a 'Get a row by ID' and, for the Row ID, I selected that column, 'Fruits'. I got an error:
Verified answer

NathanAlvares24 1,673 Super User 2025 Season 1 on at

Like (1)

Report
Re: In the 'Send an Email (V2)' step of an Automated Flow, the 'Choice' fields display their code and not their value

Hi @AliceW !

Use the Get Row by ID to get the row which got created, modified or deleted.

Expression used here:

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

Say I changed this to Bananas.

Output:

The reason why that error was happening, please take a look below:

Check the output of your Get a row by ID from your run history.

The choice label values comes in the red box while the choice value comes in the yellow box.

So to get the choice label values, it usually starts with the logical name of that column +

@OData.Community.Display.V1.FormattedValue

Example:

cr9c2_fruitstest@OData.Community.Display.V1.FormattedValue (As seen in above image as well)

I hope this helps.