Could not create HTML table from excel to email

[Airman]

Hi There,

I am a flow beginner and I am facing an error here.

I would like to convert the excel table to HTML format and paste to an email when triggered by a file is modified.

The flow is working fine but I could not see the table. Any idea to solve this problem?

Thanks in advance! 

[v-yuazh-msft]

Hi @Airman,

Please make sure that you have set the "Is HTML" field in the Send an email action to "Yes".

Best regards,

Alice

[Airman]

Hi Alice,

Thank you for your feedbank.

I've tried to turn ON the Is HTML, but it still return me without HTML table.

Anything wrong with my formula?

Regards,

Airman

Returned emailOriginal excel table 

[v-yuazh-msft · Accepted solution]

Hi @Airman,

You couldn't use the "Get tables" action to get the data in the excel table.

Please use the "List rows present in a table"action in your flow to get the rows in the table and then create html table.

The screenshot of the flow should as below:

The flow would run successfully as below:

The email with html table as below:

Best regards,

Alice

[Airman]

Hi Alice,

Thank you very much!

It is working now! Your help is highly appreciated.

Regards,

Airman

[crf200 · Accepted solution]

Hi @Airman

Alice is right with the HTML in the email but you need to include some CSS to format the table accordingly. Here is a bit of what I used to format mine.

<style>

table {
    border-collapse: collapse; width: 100%;
}
table, th, td {
    border: 1px solid black;
}
</style>

[Airman]

Hi Crf200,

The HTML is pretty good now. Thanks for your advice!

Have a nice day.

Regards,

Airman

[nizar]

HI crf200,

Please advise how to add CSS above. Thanks