Power Automate HTML Table Formatting and Emailing

In this video you will learn how to perform html table formatting in power automate and how to email table contents to your manager.
For this demo, I have created power automate flow to retrieve all records from a SharePoint list. I have then added flow actions to generate html table from SharePoint list records and then I added the custom formatting to the table (See below to copy custom styles to your power automate flow). Finally, I used email action of power automate to send the html table with contents to the line manager.
🔎 HASHTAGS 🔎
#PowerAutomate
#PowerAutomateDataOperations
#PowerAutomateHtmlStyles
★ HTML Table Formatting Code Snippet ★
Make sure to add opening and closing Style tags (See in the video) as angled brackets are not allowed here
table {
border: 1px solid #1C6EA4;
background-color: #EEEEEE;
width: 100%;
text-align: left;
border-collapse: collapse;
}
table td, table th {
border: 1px solid #AAAAAA;
padding: 3px 2px;
}
table tbody td {
font-size: 13px;
}
table thead {
background: #02A0E1;
border-bottom: 2px solid #444444;
}
table thead th {
font-size: 15px;
font-weight: bold;
color: #FFFFFF;
border-left: 2px solid #D0E4F5;
}
table thead th:first-child {
border-left: none;
}
★ TABLE OF CONTENTS ★
• 00:00 Intro
• 01:03 How to Create Power Automate Flow
• 01:40 How to Retrieve Items from SharePoint List in Power Automate Flow
• 02:28 How to Create HTML Table Based on SharePoint List Items in Power Automate
• 04:00 Get Manager Email Address in Power Automate
• 05:44 Power Automate Html Table Formatting
• 07:45 Outro & Subscribe
🔴 *** BE OUR FRIEND ***
✅ Website: www.keapoint.com
✅ LinkedIn: hwww.linkedin.com/company/18782324/
✅ Twitter: Kea_Point
✅ Facebook: keapointuk/

[@duyhoangg793]

from Viet Nam, thank you so much!

[@KeaPointTechTips]

Welcome!

[@jswoo8640]

Great description and a very useful tutorial. Thank you very much

[@KeaPointTechTips]

Glad it was helpful!

[@adamwheeler1702]

Thank you!! I have been struggling with this!!! It worked perfectly!

[@KeaPointTechTips]

You're welcome! Glad it helped you.

[@asihasih6972]

Thank you , very helpful.... I would like to ask you , If your Custom style apply to create HTML table from Excel Online ?

[@KeaPointTechTips]

Yes, you can parse each excel row and create a html table row with custom styles.

[@annessiainniss635]

This was very helpful. Thank you so very much.

[@KeaPointTechTips]

Glad it was helpful!

[@annessiainniss635]

@@KeaPointTechTips I need some additional assistance. My formatted table looks great, but now I want to add conditional formatting based on the value in a particular column. I have a R.A.G. column so I would like the R to be red, A - yellow and G - green

[@Lamouettekamikaze]

Dude i love you so much ! It's exactly what I was looking for !

[@KeaPointTechTips]

Glad I could help!

[@Justaworkinggirl]

This is great @KeaPoint! Thank you so much :) Quick question - how did you get your email to send from Microsoft Power Apps instead of from your personal email?

[@KeaPointTechTips]

Thanks Kirti. Not sure what you are trying to ask here. You can email me with screenshots. I should be able to help. [e-mail]

[@Snowkone11]

Firstly great video! Is there a way to exclude the style from the email signature?

[@KeaPointTechTips]

Update email body in html and remove styles.

[@johnhenderson1610]

Great video - thank you for this!

[@KeaPointTechTips]

Glad you enjoyed it!

[@grantwylie76]

Hello. With the html code you gave in description, could you add a section to add an image logo at the top? (image coming from an url weblink) ? I played around with img but got a red cross placeholder only. Thanks!

[@KeaPointTechTips]

Did you investigate the source code of the email to check why you are getting the red cross instead of the image. Also try to send email to a different email server to see if current email host is blocking the contents for a web URL?

[@ceciliachan9616]

Thank you so much. May I know if it can be formatted as UTF-8 to make the email showing Chinese, Japanese... Characters?

[@KeaPointTechTips]

Yes, it is html code which can be formatted.

[@marcelschliebitz4021]

Great ... that is save my life :-).

[@KeaPointTechTips]

Glad it helped!

[@bethanyd.4525]

Hello, very useful information! Is there a way to transpose the HTML table so that rather than columns we have the headers as rows? It appears I have too many columns so the email appears very wide so I'm considering putting the values going up and down in rows rather than columns. Thanks!

[@KeaPointTechTips]

Yes, it is possible. I have not done it though. I guess you can use css to present information is a different way.

[@tysonfernandes7648]

You are a legend!!

[@KeaPointTechTips]

Thank you

[@danielmacias5880]

Thank you for the information, prety valuable. But does exist a way to auto adjust the table?, i mean, you can see that the table extend for to the screen width, it would be nice if the table adjust to the column width.

[@KeaPointTechTips]

Yes, you can inject Css if you like.

[@bradmyatt2356]

@@KeaPointTechTips Where do you inject CSS in the Style?

[@m-squaredcontractors9720]

Thank you for the great tutorial. Is it possible to send an already formatted table from Excel to an email body using the Power Automate Desktop application?

[@KeaPointTechTips]

I have never tried that.

[@huyleduy8446]

From VietNam thank you so much, btw can you teach me how to create the table as column instead row because i have many items need to show in email. appreciate!

[@KeaPointTechTips]

You need to learn html table formatting. You can always visit this site and practice your code. www.w3schools.com/html/html_tables.asp

[@jeansilva9728]

Very good!!! I'm from Brazil. I have a SharePoint list where I have more than one item with a delay status for different managers. I would like to send an email with a table of overdue items to each responsible person with only his items ... Do you have any idea how to do this?

[@KeaPointTechTips]

You can create separate managers list in SharePoint. Loop through each manager list record in power automate flow and retrieve main list items using manager and over due columns as filter. This way you will get only record of that manager with over due items. Finally you use my example to create html table of those record and email to the same manager. I hope this help you.

[@stephendemanovich3974]

@@KeaPointTechTips Great video! Do you have an example flow that shows what you describe here? That would be very helpful. Thanks!

[@zmuraliz]

Thanku So much for video its really helpful, can you make a video on parallel execution like how to collect from responses and store in excel for multiple users at a time

[@KeaPointTechTips]

You can set the concurrent processes of the flow trigger to one. This way only one form response will process at one time and rest of them will wait in the queue.

[@IIChewyBaccaII]

Super helpful video! I used it to do something similar. Instead of Sharepoint as a source I am using a shared calendar. I understand UTC is default, but how do I convert the final email output, e.g. the start and end times are shown in the email as UTC, but I want 'f'.

[@KeaPointTechTips]

Thanks. Follow this link to change the date format using power automate support.microsoft.com/en-us/topic/how-to-customize-format-date-and-time-values-in-a-flow-34a91243-2961-d98c-c010-e385858b19cd

[@GuilhermeAlves-zq2gc]

Thank you!!

[@KeaPointTechTips]

You're welcome!

[@BrunoAbrigo]

Pretty good!!

[@KeaPointTechTips]

Thanks !

[@mre_man]

can the columns be different justification? or is all left, center, or right?

[@KeaPointTechTips]

You can change the html code to achieve this.

[@annessiainniss635]

need some additional assistance. My formatted table looks great, but now I want to add conditional formatting based on the value in a particular column. I have a R.A.G. column so I would like the R to be red, A - yellow and G - green

[@KeaPointTechTips]

You can have a hidden colour column in the list and pass this dynamically to the style attributes of html tag.

[@anantjot]

I have an excel of 100 customers with 20 columns. I want to send each row to respective customer in the HTML format. What step I need to add in the flow and where to achieve it.

[@KeaPointTechTips]

You will need to run flow on excel row (as a trigger). Get the row data and then follow this video to convert it to html row and email to client.

[@balajimr2]

Thanks for this video, how to change horizontal header to vertical....

[@KeaPointTechTips]

You need to update the html table. Here is the code to help you www.w3schools.com/html/tryit.asp?filename=tryhtml_table_headers

[@muthuvijayan9388]

I have a requirement for coloring a particular column in HTML table with 3 different cell background color based on cell value. The source is from List rows from a excel table and the table which will be dynamic based on people update Need your guidance and support to crack this logic for coloring a particular status column Not started -> Red In Progress --> Yellow Completed --> Green Please explain with the Power automate connectors and expression screenshots where we are inputting the logic for cell Background colors based on cell value

[@KeaPointTechTips]

Yes, this can be done. You need to do conditional formatting with html and css.

[@JonnShea]

I followed your steps, but when it comes to running the flow, it sends me 3 emails. I don't know what may have happened.

[@KeaPointTechTips]

You must have some action running in a loop. It should only send email once.

[@BenjaGm]

Hi, does this work for a converted to PDF table? Thanks

[@KeaPointTechTips]

Yes it can. if you try to save the content with .pdf extension.

[@adrianquintanilla850]

How would I put basic information into a table? I have no 'value' from sharepoint

[@KeaPointTechTips]

If I understand your question, You can build html table in power automate using data coming from any source.

[@adrianquintanilla850]

@@KeaPointTechTips My issue is what happens if I do not have a "source". It's just 4 rows with manual content, I want to add in the email to send out. Example: Email stating maintenance outage times per country (3 simple rows plus header).

[@BrunoAbrigo]

Hi, i'm from Brazil, could you please teach about how I can view and settings environments from web virtual at agents ? I'm create a chatbot in ms teams, and I don't know how can I see or edit this topic...Tks a lot and congrats!

[@KeaPointTechTips]

Hi Bruno I have made a video on this channel on how to create chatbot. That video might help you.

[@maryamhassan2372]

Thank you! is it possible send a formatted link using Create table action

[@KeaPointTechTips]

You can add a href in the email body for sure.

[@rahuljaiswal3148]

Hi I need your assistance, I have setup flow For selected Excel row Get the list of table (Excel) Compose data (pasted the code) Compose html table Send email vs2. When I select only second row and run the flow. I am receiving same 2nd column & row 4 minutes

[@KeaPointTechTips]

Really hard for me to address this without looking at the power automate flow logic, I am afraid,

[@amanpreet87]

amazing! :)

[@KeaPointTechTips]

Thanks! 😊

[@Joe.Elston-Gardner]

I want to create a table from a form response, but not sure how to get the select option to recognise the form.

[@KeaPointTechTips]

Each form response is treated separately in Power automate. You can process form response data to SharePoint and then in a separate flow, you can call the submitted responses and formant them in a table.

[@jollyonlan]

Can you get the link to the attachments for each item as well? Can't get this to work.. :(

[@KeaPointTechTips]

Have you tried "get attachment" action and then apply for each control?

[@huyleduy8446]

so great, but when i created new item in sharepoint the Automate send mail both old date, how can we fix it? just show new item creating.

[@KeaPointTechTips]

Hi, You will need to add OData filter when retrieving the list record to only return newly create records.

[@huyleduy8446]

@@KeaPointTechTips So if i wanna to show the new item create only, what should i do?.Thanks,

[@KeaPointTechTips]

Create a flow and use "When a new Item Created" trigger.

[@huyleduy8446]

@@KeaPointTechTips sure, i'm using this format and follow your guidance in the video, the gap is system send both old and new item created. :(

[@jodfie]

Can you tell me how I can adjust the width of the table columns?

[@KeaPointTechTips]

Hi JD, I am just using standard CSS, you can learn table CSS styles here www.w3schools.com/css/css_table.asp

[@julycarolinaarevaloleon4536]

hi, the flow works in outlook but no in gmail, can u help me please?

[@KeaPointTechTips]

Do you receive emails in Gmail without table formatting?

[@julycarolinaarevaloleon4536]

@@KeaPointTechTips Yes, i receive the email without formatting

[@neelakantakanisetty6447]

How to convert same html table data sending emil to microsoft word format

[@KeaPointTechTips]

The 'Convert HTML to Word' flow action converts HTML files to work. it is a paid action by encodian

[@piyushborkar1988]

HIE HOW TO SEND ATTACHMENT WITH HTML TABLE

[@RafaEspada-z8s]

how to sort the elements?

[@KeaPointTechTips]

I will be interested to see if you have managed to do it

[@dattukoralli1708]

How to put dollar sign to Amount?

[@KeaPointTechTips]

Teh email body is html code. Use html symbol for currencies $

[@dattukoralli1708]

@@KeaPointTechTips Thank you for replaying, here is my code (where to add $ ) table { border: 1px solid #1C6EA4; background-color: #ffffff; width: 100%; text-align: left; border-collapse: collapse; } table td, table th { border: 1px solid #AAAAAA; padding: 2px 1px; } table tbody td { font-size: 13px; } table thead { background: #1C6EA4; border-bottom: 2px solid #444444; } table thead th { font-size: 15px; font-weight: bold; color: #FFFFFF; border-left: 2px solid #D0E4F5; } table thead th:first-child { border-left: none; } @{body('Create_HTML_table')}

[@mattpacewicz370]

Hi--I must be doing something wrong. The email shows all the formatting instructions as text, and then the unformatted HTML table follows: table { border: 1px solid #1C6EA4; background-color: #EEEEEE; width: 100%; text-align: left; border-collapse: collapse; } table td, table th { border: 1px solid #AAAAAA; padding: 3px 2px; } table tbody td { font-size: 13px; } table thead { background: #02A0E1; border-bottom: 2px solid #444444; } table thead th { font-size: 15px; font-weight: bold; color: #FFFFFF; border-left: 2px solid #D0E4F5; } table thead th:first-child { border-left: none; } Date Start End Program Title Subtitle Staff Language Help? Link Platform (deleted the actual data under the columns for clarity) I'm a total noob at just about all of this so grateful for any insights/help you can provide!

[@mattpacewicz370]

One update, I realized that my first Style Tag was incorrect, fixed that--now all that text has vanished, but output in the email is still an unformatted html table. Help!

[@KeaPointTechTips]

Hi, Did you included tag at the start and at the end of above code? If still does not work, email your style code at [e-mail]

[@mattpacewicz370]

@@KeaPointTechTips Hi--yes, other than that initial error with the first tag I mirrored your code exactly. I discovered something odd though--while the html table was unformatted in Outlook, there was a dialog in the e-mail header saying "if this doesn't look correct open it in a browser..." and when I did that, I could see the styled formatting. I've read that there's some oddness with how Outlook processes html, I guess it uses Word for that? Maybe that has something to do with it? But would value your further thoughts. I'll e-mail you some screenshots. Thanks!

[@209porker]

@@mattpacewicz370 - I have exactly the same issue. Whatever I do the table isn't formatted in Outlook but when I open in Browser I get what I expected Love to be able to solve this problem.

[@biancafrancisco941]

Try copy pasting the code to w3 editor, there are some spaces (you'll see red circles). Just remove those and it works perfectly. Hope this helps

[@chadsills1876]

Great video. My unit price is returning 3.8555555555 in my table when I want it to be 3.85, and my GP% is returning .5142424424 when I want it to be 51%. Any advice on when to fix formatting when doing an http table. My data is coming from excel.

[@chadsills1876]

this is in the email.

[@KeaPointTechTips]

What is the source of your data and what is teh column type?