Incert Tabel from excel file into an email with "List rows in a table"-How to format HTML and get Summary row

[KantumRobot]

Hi beginner here

When excel file is aggregated and modified, I want to send an email that contains a table in the file as a preview of it which displays subtotal and total of data.

The table looks like this;"Table 25"

So I created a flow like this

 

Then I get an email with plane text(only theads are bold).

How can I make the HTML table look like the original?What is the most easiest way to do it?
I assumed I should have used "Compose" so I managed to prepare styling text for HTML but I don't know how to check the output of "create HTML".
Also having trouble with adding summary row.

Thanks,
Kan

[fchopo · Accepted solution]

Hello @KantumRobot 

In the "send email" action you can specify some stylesheets formats using CSS, adding some content at its beginning, like:

<style type='text/css'>
table {
border: 1px solid
}
</style>

 Have a look at this post to get some samples: https://ryanmaclean365.com/2020/01/29/power-automate-html-table-styling/

Hope it helps!

Ferran

[KantumRobot]

Hi Ferran @fchopo 

I just started learning HTML but I think I can at least try "INjecting CSS Styling" and "appending footer".
Thank you very much this is very helpful.

Kan