Answered

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

(0) Share

Report

Posted on by 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

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

fchopo 8,003 Moderator on at

Like (1)

Report
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

Was this reply helpful? Yes No
KantumRobot 23 on at

Like (0)

Report

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

Was this reply helpful? Yes No