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

290

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:

Building flows

I have the same question (0)

All responses (6)

Answers (3)

Sort by

Verified answer

NathanAlvares24 1,714 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
AliceW 290 on at

Like
a
(0)

Report
Copy link

Link copied!

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:

Was this reply helpful? Yes No
AliceW 290 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

NathanAlvares24 1,714 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

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:

Was this reply helpful? Yes No
Verified answer

NathanAlvares24 1,714 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
AliceW 290 on at

Like
a
(1)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No