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!
Solved! Go to 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
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>
Hi @Airman,
Please make sure that you have set the "Is HTML" field in the Send an email action to "Yes".
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 email
Original excel table
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
Hi Alice,
Thank you very much!
It is working now! Your help is highly appreciated.
Regards,
Airman
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>
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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
5 | |
3 | |
3 | |
2 | |
2 |
User | Count |
---|---|
15 | |
12 | |
8 | |
7 | |
6 |