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
sslwsh008.securedata.net/dotn...
Contact me
- LinkedIn / alirezaaliabadi
- Twitter / aaliabadi1
- Instagram / alireza.aliabadi_ig
- Facebook / alireza.aliabadi.fb

[@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.

[@maryamhassan2372]

How to send a formatted link using Create table action

[@griffintalon2292]

I know Im asking randomly but does anybody know of a way to get back into an instagram account..? I somehow forgot my account password. I would appreciate any assistance you can give me.

[@keithabel6962]

@Griffin Talon instablaster ;)

[@griffintalon2292]

@Keith Abel thanks so much for your reply. I found the site through google and Im in the hacking process atm. Looks like it's gonna take quite some time so I will reply here later with my results.

[@griffintalon2292]

@Keith Abel it did the trick and I actually got access to my account again. Im so happy:D Thanks so much you really help me out!

[@francescamccall5162]

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

[@iamdeepshekhar]

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

[@owlenmchooty3263]

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.

[@sanon2480]

Great tutorial. Very easy to follow.

[@lumierenk5652]

Hello Alireza, thanks for the video.

[@LuisRamirez-xr3ne]

Excelent!

[@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!!

[@StefanKastner]

Awesome Tutorial. Flow finally makes sense :D

[@JY-ni7id]

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

[@caro6art]

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

[@rula1237]

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

[@MrShara1983]

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

[@JorgeOyanadel]

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

[@ahilathanarasu2413]

Such a wonderful video. Thank you!!!

[@AlirezaAliabadi]

I am glad it helped :)

[@sparky213thousand]

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

[@HenilPatel-ff6ox]

what a Explanation.

[@SalilAthalye]

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

[@renjestaa]

Thank you, it is helpful for me

[@PValili]

Thank you for making simple

[@radhikamarda9407]

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!

[@homioffice9517]

ó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

[@lucaswolffdematos1009]

Muito obrigado! Ajudou muito minha vida 😁

[@MrPawello33]

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)?

[@sundrapillay6668]

Thank you much appreciated

[@raymundjunio580]

Thank you so much lods

[@nishakevin5086]

Thanks for the detailed Demo ,it came handy when i was looking for a similar solution . Looking to group the value based on the author name , can you please show me how to use group by

[@artemisoptical5564]

Excellent video, easy to follow. Just been trying to figure out wow would you go about only returning the last item created in a SharePoint list and put that into a HTML table with an email. Currently I can only get it show all list items in the html table. I started the flow with a SharePoint "When a new item is created" and then constructed the flow as per your video. I am sure its straight forward, any chance could you point me in the right direction please?

[@parimi1]

Hi Ali, Thanks for the wonderful video. I just finished your 2 hrs course yesterday. Iwas trying to create a test flow by reading data from excel and sending by email in table format. But, it was not working. I will try the HTML option now. Hopefully it works

[@gviacava]

Thank you!

[@paulpmstrina1542]

Hello! Thanks for you gratfull video. Is it possible to do the reverse process? I mean, transform a HTML table that is inside of a body email, and bring it to a excel table or a sharepoint list. Thanks!

[@BlueCollarEngineer111]

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

[@huyleduy8446]

from VietNam thank you so much. so if i just want to send the item latest create what should i do?

[@putriayunurbayti1393]

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

[@marounsader318]

Hi Alireza, how can we modify the output, as you can see the headers are miss-aligned with the rows below it?

[@vikramsingh-ws2nn]

Hi Alireza, Thank you for this very useful video, However, could you please tell me how to send email with embed images, I have tried send an email (V2) connector also and I have tried so many things but these are not working.

[@ramonillarramendi3191]

Thank you very much. But how can I create a table just for one record? instead of using Get ItemS using Get Item. The flow is triggered for a particular record in the list. I haven't been able to get the body / value from that record and display it as a table. Thanks!

[@anjz2011]

Thanks for the great video.. However I would like to know if it is possible to print this table to a newly generated word document in sharepoint library

[@longbow116]

Impressive! Can this also be applied to data from an Excel file?

[@mjmann2402]

Wonderful video as always. How can we select the value for multi select field items?

[@pavanmarujolla5773]

Thank you

[@somisadegi361]

Thanks for the great video! How can we calculate sum of a column in this table?

[@sukhmeetsingh8421]

Hi, i created a manually trigger a flow then get items, but in get items i can find the body column where the jason is written. What should i do?

[@miguelestrada5397]

Alireza, is there a way to go through an excel sheet and weave out rows from a conditional statements and set it into an HTML table? For some reason, I am getting three times the input.

[@jorgetovar1584]

I really liked the video, but I have a question, I cannot add a column in the html table that contains the absoluteuri of an element that I have obtained from the "Get Attachment" component, how could I do it?

[@melonafrancis731]

Thank you for sharing the video. I tried it and it's working. But i don't see the json format for the output in the Get Items section.It's showing click to downloads not the json format. Could you please help me out?

[@ankitshadow9227]

what if we get a object instead of array in json? select doesnt work on object so whats the alternative?

[@facundogorla8772]

I know this is an old video but while trying it a get an error on columns that are choice but can have multiple selections. What should I do in that case since item().ColumnName.Value gives me an error

[@yash14vashistha]

This was extremely helpful sir! I learned it so easily! Keep it up. I am facing a problem though - My json code does not start from value. It starts from StatusCode then headers then body and only then do i see value. I believe the from property of th select step will need to change right?

[@AlirezaAliabadi]

It doesn't really matter how the data is structured. You can always parse the JSON to your desired schema using "Parse JSON" or "Select" actions.

[@daxteoh27]

Hi Alireza. is there anyway to transpose the table?

[@gitia635]

Hi I was following this but can you please tell me if I just want one line into a table what should be done ? I dont want the whole list. When a new entry is created i want it to be displayed in a table (just the new entry). Please help

[@SaguinMedia]

After adding the Create HTML table step, my only option from the Select Output says "Current Item"? I don't see where I can choose "Output" instead?

[@ramramesh9156]

Hi Sir, Very Nice video.... and i have one requirement that number of rows in excel sheet with mail ids and want to send each row based on each mail id in HTML format .. Is that possible how to do it?

[@sashawarchoon1989]

Looks good Ali. Waiting to see more complicated scenario. Don't want to offense anyone but that this one is too basic (IMHO) 😊 Thanks!

[@AlirezaAliabadi]

That's what I thought. If you understand expressions, you find your way in Power Automate, no matter what you do.

[@puja20008]

@alireza : Hi Sir , why did not we applied apply to each to traverse each item in the list . This is super amazing but not i need some insight to better understand the concept . We were creating a variable to club all list data in one email , we did not do that here . Kindly explain

[@mohdmafaz]

Hi is there a way to map a excel table into email using flow. I have a file which is getting updated via form submissions. a table within the file is getting updated based on the input. the intention is to copy and paste the table into the email body and sent to the recipients

[@ha18415]

Many thanks for this video - it covers 90% of what I need. here is question for the remaining 10%. one of the data from share point list is enhanced rich text. when I added it to html table as you described in the video - tags are not interpreted, tags appear along with the actual text. can you tell me how to fix the issue? thanks in advance.

[@PalisadesPlaya]

Alireza, I love this video and made a flow that sends me a table of all the meetings I need to schedule. However, I cant figure out how to get a list of displaynames (person 1 name, person 2 name) into the html table. I am able to make the name string using select and join but can't get it into the table! I was thinking of creating a calculated column where it contains the string and then I could do item(). there but do you have any ideas or tips!?

[@csPinKie]

you found a solution to this?

[@waiting4wizdum565]

Awesome. How would you create an HTML table for the Responses Array when the Approval condition is waiting for all to respond and you have multiple approvers.

[@anu4231]

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!

[@kristielaier6092]

I'm looking for the same - but instead of a table with the headers along the top, I'd prefer them vertically.

[@janhogerwerf3427]

Great. Can this table also be used in approval? Don't think so as it uses HTML markdown?

[@AlirezaAliabadi]

kzbin.info/www/bejne/pZm2qnWqqpKEj7s

[@kanthsmith1]

hi this is srikanth from india ur good, in the same i need to know the same method with two to three SharePoint list items as a one to many relationship ID, thank you with your good reference

[@MrDionmar]

Excelent! , Is possible to filter any field before send email ? like filter only Floppy Disk product ? How can I do that ? Tks

[@AlirezaAliabadi]

Sure. Either user "Filter Array" and filter out items you don't need or the better way it to use OData and filter the items at "Get Items" level. This video shows you how to do it with OData kzbin.info/www/bejne/fWe5pH9rr7uMqsU

[@boiteaspams4603]

Thanks. How do you add the clickable, links ?

[@hendronurmanprasetio6434]

thank you Mr. Alizera.. may I ask,, what if what I want is not all categories but only electronics and books? please give me advice. thanks very much. God bless you

[@AlirezaAliabadi]

Watch this video kzbin.info/www/bejne/fWe5pH9rr7uMqsU

[@hendronurmanprasetio6434]

@@AlirezaAliabadi thank you sir

[@graemejohnson1973]

Really neat solution. I would love to know if there's a way to strip HTML formatting from items that I select e.g. I have values such as this "To define and document best practices for the creation of user stories" What I need to select out would be "To define and document best practices for the creation of user stories"

[@krishnabairi1581]

Thank you sir. Have a question, can we get the table out of excel instead of SharePoint item? I have a use case that I need to send an email to department owners with the list of items that they own from excel report.

[@AlirezaAliabadi]

Just forget about Power Automate. Mail merge in Microsoft word can do a much better job.

[@mstootable]

@@AlirezaAliabadi Please create a video on how to do this.

[@heatherfeather2621]

Have you solved aggregating information by a column that is the person's email address and then emailing that user the table?

[@noblemm2094]

We want to send mail to a Single email id (it is a distribution group email id) by combining all names of employees who has birthday today. Could you help to achieve this.

[@itzycombi]

Hi Sir, this is really nice tutorial, but i hope it is not too much if i ask some help. How to make the several columns in Sharepoint turn to rows. Its more on approval, and want to summarize and send to email as HTML. Example. Sharepoint list columns such as HR department, Finance Department & IT department turn into HTML like this format: Department Status HR approved Finance approved IT approved. I tried it, but got the result of all 'in one line' or one row when the HTML result received in email, where in the expected result has multiple rows. Thanks so much Sir.

[@kristielaier6092]

Looking for the same!

[@puja20008]

Also , in this example , if i would want to apply filter on Person email and share the respective rows belonging to a person , and not the complete data , how do i do that ? e.g 3 rows belongs to John , send data to John and 2 rows belongs to Pooja , send those data to Pooja , how do we apply that filter and share it >

[@danacygan-nehs6219]

I am in need of sending a table with a multiline column. Is that possible? I am having issues with it either sending a single line instead of multi. SharePoint list column is set as plain text and powerapp datacard is set as rich text.

[@AlirezaAliabadi]

Yes it is possible. Simply replace the new line in the string with and you are good to go :)

[@roachk9gaming315]

Awesome tutorial it really helped me, thank you. Is there any way to add borders to our table ?

[@AlirezaAliabadi]

Yes, wait till Monday and my next video is about styling the table :)

[@roachk9gaming315]

Thank you so much 🙌🙌

[@AlirezaAliabadi]

I assume, you were waiting for this one :) kzbin.info/www/bejne/gWWZfqagptOUppY

[@kylerickner6734]

Alireza, do you know why I'm not getting "Value" as a dynamic option? I have a flow trigger, and I have "Get Item," but when I look through my available "Get Item" dynamic options, "Value" is not an option. If you could help with this, I would be very grateful.

[@kylerickner6734]

I was using "Get Item" not "Get Items" could you please tell me how to do the same thing with "Get Item?"

[@treybrewington3286]

If you were creating the table for multiple stores in a share point, is there a way to make a table for a store and the products that store needs only instead of all the products from all stores?

[@AlirezaAliabadi]

Yes, use OData in "Get Items" filter and get only the items you need. kzbin.info/www/bejne/fWe5pH9rr7uMqsU

[@jollyonlan]

Nice! How about attachment? Or the link to them? Have tried for hours now :( Thanks

[@MrAirtaz]

Enjoyed the video. But these never seem to address handling multi-line list columns.

[@737cl9]

I am getting this error. Can you please help ? The execution of template action 'Select' failed: The evaluation of 'query' action 'where' expression '{ "Title": "@item()['Title']", "JRA #": "@item()['Status']['Value']", "Test": "@item()['group1']['Value']" }' failed: 'The template language expression 'item()['group1']['Value']' cannot be evaluated because property 'Value' cannot be selected. Array elements can only be selected using an integer index. Please see aka.ms/logicexpressions for usage details.'.

[@karangori7897]

how to do it from excel..? please help

[@radhikamarda9407]

Ali sir, is there a way to send HTML table in "Approval" email notification?

[@AlirezaAliabadi]

This is all you can do in Approval email. kzbin.info/www/bejne/pZm2qnWqqpKEj7s

[@dreambymana4981]

My columns has space in naming and it's not accepting space. Please suggest how to fix example:item().Employe Name. I am getting error,I am capturing output using Excel online, not SharePoint

[@pabloferman22]

Can you show how to send only one of those rows of data?

[@hassannawaz6540]

Hi, How we can fetch data from sharepoint rest api and crate table in ms flow

[@AlirezaAliabadi]

Have you watched this video? kzbin.info/www/bejne/omOteJWfg9Z6ncU

[@EdwardReese]

How would you do it if you only wanted to list Men's wear from the list?

[@AlirezaAliabadi]

This is an old video, but should answer your question kzbin.info/www/bejne/fWe5pH9rr7uMqsU

[@EdwardReese]

@@AlirezaAliabadi Thank you, this was very helpful. I do have another challenge. I am pulling Date/Time from the SharePoint list and would like to convert it to a different format for the email message. I tried in the mapped field of the Select to create an expression: formatdatetime(triggerBody()['StartDateTime'],'MM-dd-yyyy HH:mm') It keeps telling me that I can not use StartDateTime.

[@deepakkandari1]

Hello Sir, how can I insert borders in the table body. Please can you tell some steps.

[@AlirezaAliabadi]

You mean this one ;) kzbin.info/www/bejne/gWWZfqagptOUppY

[@deepakkandari1]

Alireza Aliabadi Thanks 🙂😇

[@cristoballoscher4297]

Hi Alireza, is there a way to format a number with an expression instead of the Format Number action? It is forcing for an apply to each on an SQL Query. Thank!

[@AlirezaAliabadi]

Give me specific example.

[@cristoballoscher4297]

@@AlirezaAliabadi I'm exceuting a SQL query but the HTML table does not recognize thousands/currency format. So can I = excute query -- Create HTML table and on each field select query items and convert them to currency through a flow expression? Thanks!

[@AlirezaAliabadi]

@@cristoballoscher4297 That's the way to go. Inside the "Select" action is where you use formatting expressions and convert the numbers to the format that you want.

[@janhogerwerf3427]

BTW Coupon has expired

[@AlirezaAliabadi]

I just updated all the coupons. Sorry for the inconvenience.