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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Format powerapp form d...
Power Apps
Answered

Format powerapp form data in a table in an email

(0) ShareShare
ReportReport
Posted on by 70

Hi, 

Has anyone been able to format powerapp form data in a table in an email?

 

Thank you

Categories:
I have the same question (0)
  • Digital Profile Picture
    1,207 on at

    You can do this using the HTML text control. Create a HTML template that you inject your form values into. You can then use the HTML text as the content for your email.

  • anthjanz Profile Picture
    70 on at

    Sorry Digital, I'm a new to all this. Are you talking about something that can be done in Powerapps?
    is there any code you could post?

    Cheers

  • Digital Profile Picture
    1,207 on at

    @anthjanz ,

     

    Yes in Power Apps.

     

    Your best bet would be to watch this video. Shane Young's YouTube channel is a great resource for starting out with this stuff and he explains it way better than I could here.

     

    https://www.youtube.com/watch?v=vpYkOccwn4Y&ab_channel=ShaneYoung

  • Verified answer
    v-qiaqi@microsoft.com Profile Picture
    on at

    Hi @anthjanz,

    Do you want to send data from the form into a html table with an email?

    Could you please share a bit more about your scenario, do you have an edit form to submit data?

     

    Actually, it is easy to achieve this in Power Apps, all your need is to add a HTML text input, please check as below.

    1). If you have an edit form to submit data, please set the submit button as below:

    SubmitForm(Form4);
    Office365Outlook.SendEmailV2(
     "
    QiQiao@xxx.onmicrosoft.com",
     "Notify",
     HtmlText4.HtmlText
    )

    2). Add a Html Text input and set the HtmlText property as below:

    "<strong> Information: </strong>" & "<table width='100%' border='1' cellpadding='5' style='border:1px solid black; border-collapse:collapse'>" & "<tr style='background-color:#efefef'>
     <th>Title</th> <th> Name </th><th> Score </th>
     </tr>" & "<tr>
     <td>" & Form4.LastSubmit.Title & " </td>
     
     <td>" & Form4.LastSubmit.Name & " </td>
     <td>" & Form4.LastSubmit.Score & " </td> 
     
     </tr>" & "</table>"

    Note that Form4 is my edit form.

    vqiaqimsft_0-1645779086709.png

    Here is the test result:

    vqiaqimsft_1-1645779151707.png

     

     

  • anthjanz Profile Picture
    70 on at

    Thanks Qi, that was very helpful!

     

  • Motion Profile Picture
    69 on at

    @v-qiaqi-msft Thanks so much for this...saved my day.

  • PEBKAC Profile Picture
    5 on at

    Question! If there's no data, Can I add "message" in the recipients email? Example I have a Table with four header columns but since there's not data the lower table isn't there. Thx!

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 721 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 320 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard