cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Airman
Frequent Visitor

Could not create HTML table from excel to email

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! 

 

Flow.jpgreturn msg.jpg

2 ACCEPTED SOLUTIONS

Accepted Solutions

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:

Capture.PNG

The flow would run successfully as below:

Capture.PNG

 

The email with html table as below:

Capture.PNG

 

Best regards,

Alice

View solution in original post

crf200
Advocate IV
Advocate IV

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>

View solution in original post

7 REPLIES 7
v-yuazh-msft
Community Support
Community Support

Hi @Airman,

 

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

Capture.PNG

 

Best regards,

Alice

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 emailReturned emailOriginal excel tableOriginal excel tableFlow1.pngFlow2.png 

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:

Capture.PNG

The flow would run successfully as below:

Capture.PNG

 

The email with html table as below:

Capture.PNG

 

Best regards,

Alice

Airman
Frequent Visitor

Hi Alice,

 

Thank you very much!

It is working now! Your help is highly appreciated.

 

Regards,

Airman

crf200
Advocate IV
Advocate IV

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
Frequent Visitor

Hi Crf200,

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

Have a nice day.

 

Regards,

Airman

HI crf200,

Please advise how to add CSS above. Thanks

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,097)