web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / I can't display the va...
Power Automate
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 286

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

Categories:
I have the same question (0)
  • creativeopinion Profile Picture
    10,508 Moderator on at

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

    creativeopinion_0-1714928331672.png

     

    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

     

  • AliceW Profile Picture
    286 on at

    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 😞

     

    AliceW_0-1714929338448.png

     

  • creativeopinion Profile Picture
    10,508 Moderator on at

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

  • AliceW Profile Picture
    286 on at

    Like this? the rest is the Email itself. 

    The Role field is in the first table: 'Opp AM Teams'. Thank you!!

    AliceW_0-1714929718328.png

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 77 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 68

#3
Expiscornovus Profile Picture

Expiscornovus 56 Most Valuable Professional

Last 30 days Overall leaderboard