How to create an HTML table using Power Automate (Flow) in mail

In this video we use Power Automate to create an HTML table from SharePoint list items using flow "Create HTML Table" action and add it to an email body.

Discount coupons for my courses on Udemy

Contact me

[AlirezaAliabadi]

In this example I am using Select action to simplify the complex content extracted from SharePoint list. If that looks too complex to you, consider apply to each and make your own array of objects.

[iamdeepshekhar]

Really appreciate your content. Keep up the great work, sir.

[francescamccall]

UGH THANK YOU. I've been struggling with this for a weeks! It's all running perfectly now! you are a life saver

[owlenmchooty]

Alireza you're a legend! Thanks a lot, this was very helpful in outputting only the values from a sharepoint data field with multiple tickboxes.

[MrShara]

wow :) most clear tutorial ever . Thank you thank you

[StefanKastner]

Awesome Tutorial. Flow finally makes sense :D

[SalilAthalye]

This was very helpful and I appreciate your explanation regarding Select. Will look to your course on Udemy. Thanks

[sparkythousand]

So helpful, thanks! It’s so simple but I struggled with it for so long before lol. I also added in a filter array step before select

[JY-niid]

Thank you very much Alireza! Truly appreciate your sharing.. :)

[caroart]

Thak you! this simplifies my life!!! Excellent tutorial

[radhikaM]

A day before I was thinking of a way to send an html table constructed in the workflow to email. I am one step closer. Thank you!

[akshaynm]

Many Thanks Ali, for sharing this knowledge wih us. The concepts you shown here are very well covered in your course of 'Flow Expressions'. This video is just a real life scenario to be more precise. Thanks a lot again!!

[homioffice]

ótimo assisti em inglês mesmo, estava precisando pegar uma planilha de excel então usei o select para o json e deu tudo certo

[rula]

Perfect!! Thank you very much, this is working perfectly with me

[putriayunurbayti]

It's possible to call 2 different list items in one flow then email those 2 different list item into 1 html email.. example : I had "Master" list item and "details" list item. The Master list item it contains the name of approval and ID and The Details list item it contains list of some item and price.. Do you have any idea? Thankyou

[JorgeOyanadel]

Que buen tutorial, gracias por compartir tu conocimiento
Saludos desde Chile

[MrPawello]

That was an amazing example of how to use various functionalities in PA - simple, straightforward and to the point - a pure beauty.
I just went straight into your course on Udemy which i purchased 2 weeks ago but so far have been going through another course of different author which is far less useful than your video. Big Thanks

Question: what would be an action to use Get Items from SQL server database similar to Get Item from sharepoint (to get the json schema)?

[lucaswolffdematos]

Muito obrigado! Ajudou muito minha vida 😁

[anu]

Hi, you have explained a great process to automate an email with list items from share point. Could you please do an video on sharing newly added list items instead of all items. It would be great if you can do the same. Thank you!

[BlueCollarEngineer]

Hello Alireza, Please do a video if I want to send only the ones that are of "Electronics" category from your list. Thank you!