Answered

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

Like (0) Share

Report

Posted on 6 Oct 2023 08:45:54 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?

I have the same question (0)

All responses (6)

Answers (1)

smital 29 on 10 Oct 2023 at 09:54:48

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!

Was this reply helpful? Yes No
SudeepGhatakNZ 14,381 Most Valuable Professional on 10 Oct 2023 at 03:49:20

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?

Was this reply helpful? Yes No
smital 29 on 10 Oct 2023 at 03:25:55

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.

Was this reply helpful? Yes No
Verified answer

SudeepGhatakNZ 14,381 Most Valuable Professional on 09 Oct 2023 at 11:14:54

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

Was this reply helpful? Yes No
smital 29 on 09 Oct 2023 at 04:00:29

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

Was this reply helpful? Yes No
SudeepGhatakNZ 14,381 Most Valuable Professional on 06 Oct 2023 at 10:03:23

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.

Was this reply helpful? Yes No