Power Automate flow HTML Table Formatting in Email | Flows & SharePoint
Vložit
- čas přidán 31. 07. 2024
- 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.
Style HTML Table Power Automate - ryanmaclean365.com/2020/01/29...
Power Automate (Microsoft flow) OData Filter SharePoint - • Power Automate OData F...
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 - Věda a technologie
This is going to be one of those videos I bookmark multiple times w/different timestamps...There's so much good stuff throughout. AMAZING!! 🤩
Yay! Thank you!
Perfectly said!
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! 🙏
Glad to hear that Eren.
Thank you for watching the videos.
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!!! ❤
Thanks Hannah. You are most welcome.
There was way more in this video than I expected from the title - thanks Reza for a great video!
Glad to hear that! Thank You so much for watching.
Amazing! I implemented this immediately in my flows. Thank you for all the tips and tricks and your hard work towards helping others ❤️
Great! Thank You.
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.
Thanks for the tip! Super useful.
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!
Glad it helped! Thank You for watching & liking the video.
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
Thank You.
You can skip the ads :)
Our regional GM is telling everyone to learn from CZcams, 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
So happy to hear the content on my channel is being appreciated.
Thank you!
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 😊
Now I am smiling reading your comment.
Thank you so much for liking this video.
I had a recording of 1hr 20 mins and I only kept 35 mins of it. Many other tips were removed to keep video to around 35 mins.
Il cover them in another video or a live session.
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.
Thanks so much Keith.
Credit where credit is due.
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.
Thank You!
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 👌👌
It's my pleasure. Thank you so much for the amazing feedback.
Yet another "wow" 👍
Wow! Thank You :)
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.
Awesome!
It's amazing how much work was put in creating the use cases and presenting them in a smooth manner. Great job!
Thank you very much!
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.
Your most welcome!
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 ) 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 😅.
So happy to hear the awesome feedback. Thank You!
One more thing. I actually used this video to code a ‘blind’ email. Through Power Automate, I had huge problems with a rogue tag causing columns to move to the right and therefore not match the headers. Your clarity, though on explaining the need to replace > etc solved it. I had to add a replace function for ‘<’ and ‘>/td>’ to deliver a beautiful table. I have since, started to create an app (based on another of your videos) for that element of our work, it has opened up so many more possibilities. The email element with HTML table embedded means that the email to be sent can now at least be vetted prior to sending, which gives far better assurance to all stakeholders (all of them believe Power Automate, PowerApps and coding in general to be magic…..). The visual element, through PowerApps will add real value, especially combined with the new create PDF element.
Again, thank you.
WOW! How much useful information in just one video.I´m about to make a flow and this just have all of the answers i expected and more, this will be the 2nd time one of your videos simplifies my work.I´m not an expert and this not my area and sometimes i find myself struggling to get solutions to automatize and simplify my work, Thank you so much!
Wow! Thank you for the amazing feedback.
Hope you keep enjoying my videos and thank you for watching
Thank you Reza. This video showed me how to do a weekly report for open items that my manager can use to make tracking our work much easier.
Glad it was helpful!
Just want to thank you, as I being learning so much from your videos, thanks!!! From Mexico
Thanks so much
I spent 3 days spinning in circle trying to figure this out until I remembered you always have a solution to my problem. Please, please keep making these videos. I don't know how to thank you enough for all you've taught me.🙏
Glad I could help!
This is really awesome!!! My flow can only send text-only email, now I made a big improvement learning from you. Thanks so much!!
Awesome! Thank You for watching.
I've always done basic HTML table in email's, really like your outside box thinking. Thanks for great video
Cool, thanks!
Amazing video. Answers so many questions! Bookmarked the video and will be returning to it many many times!
Awesome! Thank you!
Thank you very much Reza: this video is full of very valuable tips & tricks. I appreciate your work because it's getting close to what I used to find in... books! There are too many videos out there where the useful content is buried in tons of b*****t. It's not the case with what you publish and it's very much appreciated.
You are most welcome. Thank You for the feedback on my videos. I try my best to stick to the topic and not include fluff.
I spend more time editing my videos than making them.
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!
You're very welcome!
Thank you. Again you have shown me possibilities of power automate beyond my imagination.
Wonderful!
Wow...This is world Class! This is what I have been looking for. Thank you Reza!
You're very welcome!
Thanks Thanks Thanks
The "Show all parameters" option is a great help for easily filtering the data in a SHAREPOINT list.
You are welcome!
You were a savior.. Awesome video. I BECAME AN ADMIRER OF YOUR SKILLS..
Thank You Sai
Thanks Reza, in single video you have covered most of the challenging features 👍
Glad it was helpful!
Reza.. I already worked on the create HTML table. This much we can do I came to know it now.. you are just brilliant. As always you are my super hero.. 🦸
Wow! Thank You :)
My brain says ..Enough watching..Now it’s time to apply. You are KING of PowerPlatform.
Thank You Sir. Only content is King.
Reza, thanks for the awesome video as always. Just what I was looking for. Keep up the good work!
Glad to hear that! Thanks for watching
Hi Reza! Your videos are great and tremendously helpful! Thank you for giving us the "Power" 😀
You are so welcome!
Thks Reza!!!! Excellent guide on how to compose emails with HTML!
Thank You
Thank you @Reza Dorrani! I really appreciate you creating this demonstration for us 👏
Most welcome
This was outstanding. Exactly what I needed to format some data in an email.
Glad to hear that
You are my hero friend, I only changed the data source connecting with SQL and it worked very well for me.
Awesome! Thanks for watching.
Great stuff! A very good training session. Trillion thanks to Reza Dorrani!
I am very much thankful to you for this video, learnt a great stuff today. You are one stop solution for all power platform issues. Thank you
You are most welcome
This was IMMENSELY helpful! Thanks so much! I've been trying to figure out how to conditionally format the dates in an HTML table and this video was clutch.
You're very welcome!
I salute you, Sir. Your content is my first go-to point when l am stuck
Thank You
Reza, Thanks a lot for providing such an step by step explanatory video. I'm short of words to tell how much this video has helped me. Thank you very much for this content.
You're very welcome!
I have no word to tell you how much this has helped me. Please keep doing such amazing stuff. Also I would be on top of the world if you could help me with more videos if you could be available to take up our problems/ challenges / proposals/ idea.
I'm always on the lookout for ideas. Post your ideas to me at reza.dorrani@outlook.com
Note: I make videos only when I get multiple requests (10+) for a similar topic.
What a great tutorial, I have learned so much from this so thanks for producing it
You are most welcome
thank you so much Reza. The godfather of powerapps!
You are very welcome
Raza, you're the best I have been searching in so many videos and couldn't find the answer to my questions till I watched this video. Thank you so much.
Great to hear!
Your videos are a godsend. Thank you so much, Reza.
Glad you like them!
This is amazing !! Works for me ! Thank you from Costa Rica :)
You're welcome!
Excellent content and examples, Reza! Definitely something I'll be able to use in the future!!
I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
Congratulations Reza, really enlightening video! Amazing!
Thank You Andrea
Sir You are Amazing, The detailing in your video is SUPERB... Lots of Respect from India.
Thanks a ton. ❤️ to India
Reza, I was stuck to apply conditional formatting. But now you help me alot. Thanks
Glad to hear that!
Thank you so much Reza for sharing this video. So far I was building my HTML string within FOR EACH LOOP (Kind of old school days). I didn't know about powerful Create HTML and Select workflow actions in flow. I'm going to watch this video again when I have to apply filter and other criteria. Thanks again for your awesome work.
Good to know about how to turn on experimental features as well.
You're very welcome!
Its a handy feature
Another amazing video Reza 👏 I enjoy learning from you and you are a big time saver for new developers ❤️🙏
Happy to hear that! Thanks so much for the appreciation.
Thanks Reza, this is amazing stuff you just showed here.
Glad you liked it. Thank You.
Hi Reza, your vidoe again saved my life! Thank you 🙂
You're welcome 😊
Wonderful ! You are saving many of us jobs. My support is on its way. Keep it up
Glad to hear that! I will keep trying my best.
I will definitely be doing this in my apps, as my goal is to try to make a one stop shop for a lot of things that my organization does to help simplify things. Thanks Reza!
Thank you for sharing your feedback, Chris!
Great video man, I used this for my Microsoft Form instead of a SharePoint list. It worked great, thank you so much.
Most welcome
Hi!
Who did you manage to integrate these two (or maybe three) platforms?
I tried but it keeps showing me the following error:
"The 'from' property value in the 'select' action inputs is of type 'String'. The value must be an array."
Thank you Reza. This is amazing!!!
Glad you like it!
Simple yet amazing 👍 thanks for sharing the knowledge
Glad you liked it
Love this Reza, great work! ❤
Thank You
Great session as I get used. Thank you so much Reza.
You're most welcome!
Saved my day today - this one!
👍
Such a valuable video, thank you for sharing your knowledge!
You are most welcome
Awesome content!! Learnt so much from this. Keep up the good work :)
Glad to hear it! Thank You for watching.
You are really great Reza.. 🙏🏻🙏🏻🙏🏻
What a fantastic workaround you demonstrated to add a hyperlink in the HTML table. Hats off..!!
🙂
Most welcome
wow Reza, amazing video, a lot of great tips. Thank you !
Thanks Gustavo
Excellent and it has so much in it. Thanks. Table of contents is also really useful
You are most welcome
This is Amazing ! Thanks a lot Reza for such a great Video
Most welcome
Thank you Reza, again an amazing video with so much useful information for future projects
Most welcome
if I could, then I would give this video another like. Thank you for making these great videos!!
Wow! Thank you.
Fantastic, wonderfull. A forma como vc explica, passo a passo, primeiro mostrando um básico, depois vai evoluindo, é muito didática. Muito Obrigado.
You are most welcome
Very detailed explanation. Thanks for the quality of content
My pleasure!
This was really awesome.. I regret that missed to watch on the it was uploaded.
Thank You.
You can always catch up on the videos :)
Another good video! it really helps me. Thanks Reza!
Glad to hear it!
Really helped the video .Great knowledge.. Thank you So much Reza ...
You are most welcome
Thanks Reza for the great sharing 👍 I learn new knowledge today 😀
Glad to hear that
Thanks for posting this video, it is really a useful and practical! 👍👍👍
Glad it was helpful!
Thanks for all your helpful videos!
Thanks so much
It works!!! Thank you so much.
Your most welcome!
Very professional and useful video, too awesome
Much appreciated!
OMG! I cannot thank you enough! OMG! 👏👏👏👏🙏🙏
You're most welcome!!
It's Awesome Reza... Like before it's excellent...💚
Thank You
Another amazing video!!
Thanks Reza
Thanks for watching Ali
Thanks Reza. Amazing and very useful video.
My pleasure!
Fantastic! Thank you!
You're very welcome!
excellent topic, not long ago I created a similar solution, mailing for unique recipients from multipersons fields, the truth with links was solved by replacing symbols, yours is more aesthetic
Thanks for sharing
Nice! Thanks Reza. Very insighful.
Most welcome
As usual helpful video, thanks a lot Sir!
Most welcome!
Great article Reza .. As always .. thank you
Thanks Marcelo
Again a awesome video...you are great Reza..like it👍
Thank you so much 😀
This is so useful, thanks a lot !
You are most welcome
Thank you! I've been wondering how to do this in the future!
Glad to know this video was helpful. Thank you for watching.
great video, one of the best HTML table formatting video
Thank You
Cool share! Thank you Reza.
Thanks for listening
Really Helpful !! Thanks for sharing
Glad it was helpful!