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

Community site session details

Session Id : RFAnz57WdfeK0dObQEJOUe
Power Automate - Building Flows
Unanswered

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

Like (0) ShareShare
ReportReport
Posted on 5 May 2024 13:29:35 by 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

I have the same question (0)
  • AliceW Profile Picture
    280 on 05 May 2024 at 17:22:32
    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!!

    AliceW_0-1714929718328.png

     

  • creativeopinion Profile Picture
    10,480 Super User 2025 Season 2 on 05 May 2024 at 17:19:12
    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 Profile Picture
    280 on 05 May 2024 at 17:15:58
    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 😞

     

    AliceW_0-1714929338448.png

     

  • creativeopinion Profile Picture
    10,480 Super User 2025 Season 2 on 05 May 2024 at 16:59:31
    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. 

    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

     

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

MS.Ragavendar – Community Spotlight

We are honored to recognize Ragavendar Swaminatha Subramanian as our September…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 725 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 363 Moderator

#3
Power Apps 1919 Profile Picture

Power Apps 1919 341

Last 30 days Overall leaderboard
Loading complete