I can't display the value from a Choice field, but only its code

(0) Share

Report

Posted on by AliceW

280

Hi everyone,

So, I have this flow where an email is sent when a change is made in a field.

I can include, as Dynamic variables, the fields in that table that are Date or Number or Text, but not the Choice ones.
For those, I only get their code.

Does anyone know how to get them, please?

Thanks,
Alice

All responses (4)

Answers (0)

AliceW 280 on at

Like (0)

Report

Re: I can't display the value from a Choice field, but only its code

Like this? the rest is the Email itself.
The Role field is in the first table: 'Opp AM Teams'. Thank you!!
creativeopinion 10,439 Super User 2025 Season 1 on at

Like (0)

Report

Re: I can't display the value from a Choice field, but only its code

@AliceW Can you show a full screenshot of your flow?
AliceW 280 on at

Like (0)

Report

Re: I can't display the value from a Choice field, but only its code

Hi Creative!
I know what you mean, buuut I can only see the one line. The field is called 'Role', and that's what I see 😞
creativeopinion 10,439 Super User 2025 Season 1 on at

Like (0)

Report

Re: I can't display the value from a Choice field, but only its code

@AliceW You need to ensure that you are selecting the correct dynamic content. For example, in my SP list i have a Choice (single choice) to display the value, I'd need to select the Choice Value dynamic content.

If you are looking for a way to send multiple SharePoint List items that have been assigned to a user in an email—check out this YT Tutorial: How to Send a SINGLE EMAIL ✉️ with multiple SharePoint list items | Build THIS Power Automate Flow

IN THIS VIDEO:

✅ How to send multiple list items in a single email with a Power Automate Flow

✅ How to create a dynamic date range

✅ How to use the Convert Time Zone action

✅ How to use a Filter Query in the Get Items action

✅ How to count number of items in an array

✅ How to use the Select action to extract a users display name and email address

✅ How to create a unique list of email addresses

✅ How to use the Create HTML Table action

✅ How to customize the HTML Table with CSS styles

✅ How to use the Send an email (V2) action

✅ How to use the Append to String Variable action

✅ How to create a custom list of items for an email

✅ How to use the Send an email (V2) action

✅ How to display singular or plural text based on the number of items returned

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram