Answered

ID of a choice appearing instead of the question in Approval Email

(0) Share

Report

Posted on by smital

I am writing a flow where the approver will get an email to approve/reject. In the details, I want to provide information what the user filled. However, they are in choices and when I take the dynamic expression, the approver see's the choice ID instead of the actual name of the choice. For example, for the Faculty column, the user will see Faculty: 921090002 instead of Faculty: Arts in the email. How do I fix this in the flow?

All responses (6)

Answers (1)

smital 29 on at

Like (0)

Report

Re: ID of a choice appearing instead of the question in Approval Email

Yes I checked it. Your solution worked! For my case, I just needed to initialize a variable so I can add it to the details. It now works:

Thanks for your help!
SudeepGhatakNZ 14,381 Most Valuable Professional on at

Like (0)

Report

Re: ID of a choice appearing instead of the question in Approval Email

Are you able to investigate the JSON for the Law request?
smital 29 on at

Like (0)

Report

Re: ID of a choice appearing instead of the question in Approval Email

Thanks for the solution. I did manage to see the code like you showed:

Issue is when I do the second part (apply to each and compose with the item expression), it just gives me "Engineering" as the output. That I think is because in the list rows code, "Engineering" is the value there.

In the test I did, it was a "Law" request. In the body of the email, I put the faculty dynamic content (you can ignore the title - I did not put it there):

As you can see, the value is there - not the faculty name. I tried doing the same process but by initializing a variable and then putting the same item expression as the value. It did not work. Is there any way to get the faculty name as a variable?

Thanks for your help.
Verified answer

SudeepGhatakNZ 14,381 Most Valuable Professional on at

Like (1)

Report

Re: ID of a choice appearing instead of the question in Approval Email

This is by design. Dataverse returns the value of the Choice field. To display the text, inspect the output of List rows

Find the fields that displays the Text and Value

You can extract the Value by specifying the tag name
smital 29 on at

Like (0)

Report

Re: ID of a choice appearing instead of the question in Approval Email

Sure, here are the choices for my column:

When I try putting this into the flow, I want the text column to appear. In the details, I add the Faculty column in the dynamic content:
I have tried initializing the Faculty variable into string but as expected, it is just taking the ID value and converting it from a number into a string (but it is still the ID, not the text).
SudeepGhatakNZ 14,381 Most Valuable Professional on at

Like (0)

Report

Re: ID of a choice appearing instead of the question in Approval Email

Please share a screenshot of the action where you have used the Choice column from Dynamic content.