Power Automate flow HTML Table Formatting in Email | Flows & SharePoint

This video is a step by step tutorial of how to create HTML table in Microsoft Power Automate and email the table data. We will use Power Automate flows to create the HTML table from SharePoint list items using flow "Create HTML Table" action and add it to the email body. We will cover various filter query scenarios to get the tabular data from SharePoint list, send emails with dynamic content and add HTML table styling to the body of e-mail sent by the flow.

Table of Contents:
00:00 - Intro
00:26 - Asset Manager SharePoint List
01:05 - Build a flow to send an HTML table in Outlook email (SharePoint list to HTML Table in Power Automate)
01:19 - Build SharePoint like Views in PowerApps
09:47 - Add HTML Table Formatting (Styling) in Power Automate send email action
11:59 - Add Link to Item in Create HTML Table action in flow
17:00 - Send HTML table data from SharePoint list based on Date column (date formatting)
20:15 - Send HTML table data based on Date range (due in x days)
21:40 - Format SharePoint Choice column in HTML table in email
25:33 - Run flow with input form - Status column formatting
27:07 - Send Picture / Image of Person column in email using Power Automate'
28:14 - Group SharePoint list items and send formatted HTML Table for each Group
35:22 - Subscribe to Reza Dorrani channel

#PowerAutomate #Flow #SharePoint #HTMLTable

[bakaratn]

This is going to be one of those videos I bookmark multiple times w/different timestamps...There's so much good stuff throughout. AMAZING!! 🤩

[erenatis]

Reza, I can't thank you enough for all the great content you provide. I'm a financial person by trade and have been able to use your videos to leverage so much goodness for our processes. Thank you! 🙏

[hannahclor]

I just want to let you know that this video is god-tier for me. This is EXACTLY what I was working on. Thank you for putting this together, you rock!!! ❤

[hiltongiesenow]

There was way more in this video than I expected from the title - thanks Reza for a great video!

[keithmaly]

Reza, you are a rockstar! Really appreciate how you break down these tasks so they are digestible. Very classy also to give credit to other content creators the way you did with Ryan.

[linsss]

Amazing! I implemented this immediately in my flows. Thank you for all the tips and tricks and your hard work towards helping others ❤️

[hwryt]

Just wanted to thank you for an excellent video that really helped made my Power Automotive flows to email look very professional. Really do appreciate you putting this together. Not sure how many hours it saved me but it certainly helped keep me sane!

[chekoo]

Impressive as always,
Thank you man

As a support I don’t skip the ads when it shows up

I really appreciate your knowledge and how professional, easy and quick delivering the idea

[chaddraper]

This video is very clear and helpful! One thing I will point out is that by adding the styling as in this method, Gmail will remove the CSS and you are back to the point with no styling. To get around that, you need to implement the Advanced Styling method that Ryan shows on his page and put all of the CSS inline within the table tags. Email styling is always a pain.

[krishnabairi]

I was smiling most of the times while watching this video, surprising how many tips and tricks Reza knows... A great video and definitely you are awesome boss. I have many things to learn and re-apply in this video. Thank you very much 😊

[EuroWin]

It's amazing how much work was put in creating the use cases and presenting them in a smooth manner. Great job!

[stronginhim]

Thanks Reza. You are the first person the I have found that shows what to do with dates and also the filter how you can click to the different settings. Also how you showed to change the setting up the top right. Excellent Reza.

[dcireuo]

Our regional GM is telling everyone to learn from YouTube, your content is by far the best and easiest to comprehend. Keep it up. I got stuck on the HTML table in a loop. Now I know how to pull it all together in one email

[peternagyhenry]

That's really amazing .. I'm shocked by the power and customization that are available
Really I can't thank you enough for sharing this valuable info .. you are a MASTER 👌👌

[markemilyshepherd]

Amazing video. Answers so many questions! Bookmarked the video and will be returning to it many many times!

[bideyyusuf]

Amazing and indept knowledge on how to make an HTML formatted Table. Plus some little tricks here and there, to get things done. Thanks a mil Reza. CLASSY!

[ethtri]

Reza - will you be my best friend? I probably wouldn't be employed if it weren't for your videos. Thank you for everything you do.

[kelseythompson]

Wow! This video helped me reduce a flow that had 30-40 actions (darn loops) down to only 4 actions! Saving this one to reference in the future for SURE.

[omarmorales]

Hi Reza! Your videos are great and tremendously helpful! Thank you for giving us the "Power" 😀

[richardjames]

Reza. Thank you.
This is one of my favourite tutorials. It has revolutionised the way in which we promulgate information. Being able to conditionally format all elements (especially <td>) has created an incredible visual for all stakeholders involved. In addition, the hyperlink element proves incredibly useful when you require your target audience to fill out tables held in alien locations 😅.