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

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Get SharePoint List > ...
Power Automate
Answered

Get SharePoint List > Create HTML Table > Send Email - Value

(0) ShareShare
ReportReport
Posted on by 19

Hello! When emailing an HTML table, created from a SharePoint list, the values result as seen below when the column of a SharePoint list is a choice. In this case, the choice is "Day" or "Night" for the Shift column. I would like it to result as just "Day" or "Night". This is what the created table send in the email reads: 

 
 
 
Categories:
I have the same question (0)
  • jinivthakkar Profile Picture
    4,187 on at

    @jrod86 I think you missed the screenshot

  • Verified answer
    jinivthakkar Profile Picture
    4,187 on at

    @jrod86 I have added a column for shift with day/night just like you:

     

    jinivthakkar_0-1614105645604.png

    select shift value

    jinivthakkar_1-1614105709989.png

    My excel

    jinivthakkar_2-1614105741021.png

     

    Hope this helps.

     

    --------------------------------------------------------------------------------
    If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

     

     

  • jrod86 Profile Picture
    19 on at

    The problem presents itself when the column is a "Choice" type. It is fine when it is a "single line of text" type, but not choice. 

    jrod86_1-1614108088377.png

     

    jrod86_0-1614107989165.png

     

  • jinivthakkar Profile Picture
    4,187 on at

    @jrod86 my column is also choice and you need to select the ShiftValue in flow action as I have shown above.

  • jrod86 Profile Picture
    19 on at

    I am so sorry. Not sure how I missed that. THANK YOU SO MUCH!

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
trice602 Profile Picture

trice602 239 Super User 2026 Season 1

#2
David_MA Profile Picture

David_MA 177 Super User 2026 Season 1

#3
Kalathiya Profile Picture

Kalathiya 97 Super User 2026 Season 1

Last 30 days Overall leaderboard