Create a flow that Sends an Email With a HTML Table when an item is added to a SharePoint List

How to Create a flow that Sends an Email With a HTML Table when an item is added to a SharePoint List
Using the following actions in Flow:
Get items
Select
Create a HTML table

[@gavp1336]

Hi, do you have a video just to show how to automate an Email with an Excel table in the body? I can't really find one anywhere. Apologies, Power Automate newb here. Cheers

[@duyhoangg793]

from Viet Nam, thank so much!

[@4eduvid812]

is this the same if you want it to be for only when 1 item is created instead of all items

[@justrhuna2263]

What to do if you have repeatedly same header name with different information that shows in email and converted to PDF?

[@drdeepurahulful]

It was really good, but I see all the item are reflecting in the email. I wanted to showcase only the one that is created newly. Pls suggest if that is possible

[@midnightcoder4577]

Hi, I added a video demonstrating how to retrieve only the new item that was created. kzbin.info/www/bejne/i4DZYnSBnamhjbM

[@drdeepurahulful]

@@midnightcoder4577 Perfect it worked.. Thanks a lot

[@drdeepurahulful]

@@midnightcoder4577 one more help, I need to add an attachment to the same and multiple approval. I have added get attachment, initialize variable, get attachment content. But I don't see the attachment being picked in the flow.

[@drdeepurahulful]

Any update?

[@MamdouhNada]

HI thanks for that but I want to retrieve only the new Item not the whole list

[@midnightcoder4577]

Hi, I added a new video demonstrating how to retrieve only the new item that was created. kzbin.info/www/bejne/i4DZYnSBnamhjbM

[@JG-cr9qv]

OH MY GOD IVE BEEN LOOKING FOR THIS ALL DAY THANK YOU

[@midnightcoder4577]

@@JG-cr9qv Glad it helped you!

[@mfzasr5665]

Hi, is there a way to tabulate an excel table into email body.. appreciate if you could help me with this..

[@midnightcoder4577]

You can include an excel table in an email using power automate. Do you want to send only the tabulated data of the excel table? Yes, I can try to help.

[@mfzasr5665]

@@midnightcoder4577 thanks for offering to help. I posted and got response from Microsoft's user platform. I had issues with getting the data formats also included, ie. % came in as decimals (0.15 instead of 15%). I found a work around using the text function in excel which converted the values in the table into text in the excel itself :). Thanks again for offering the helping hands. Will get in touch if required in the future.

[@Rameshkumar-cr6ic]

Hi its good one. i need to retrieve only one item .. am using office 365

[@midnightcoder4577]

Hi, I added a new video demonstrating how to retrieve only the new item that was created. kzbin.info/www/bejne/i4DZYnSBnamhjbM