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

View solution in original post

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>

View solution in original post

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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (3,047)