Answered

Transpose a HTML Table

(0) Share

Report

Posted on by Bokaboi

Hello all,

I have some flows for site inspections that work well. They are triggered by a user submitting a Microsoft Form. They update a SP list and alert a manager depending on the findings. The emails could be formatted a little better, I would like to transpose the HTML table to make it easier to read. I have no idea where to start with this. Can you offer any suggestions?

Here's what the flow looks like currently:

2022-10-20 14_17_59-Edit your flow _ Power Automate and 10 more pages - Work - Microsoft Edge.png

This is the body of the email:

2022-10-20 14_19_14-2 - Complaince - ben@chemisys.com.au - Outlook.png

This is how I would like to format the table:

2022-10-20 14_21_15-Book1 - Excel.png

Thanks in advance.

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report

@Bokaboi ,

Is this helpful?
Transpose table columns using Power Automate (With example) – immersivecoder

Was this reply helpful? Yes No
Bokaboi 47 on at

Like (0)

Report

Hello Sudeep,
Thanks for reaching out. I've had a brief read; although I may be able to adapt it, on the surface it would seem the tutorial you've shared is to group items under a heading which were originally stored in the first column of a table. I'm hoping to rotate my table 90degrees.

Here is my whole flow:

Was this reply helpful? Yes No
v-chengfen-msft on at

Like (4)

Report
Hi @Bokaboi ,
Please try to put an HTML Table in an email as a string
Here is a test for your reference:
<table width="20%" border="1" cellspacing="0" cellpadding="4" align="Left" bordercolor="#cccccc">
<tr>
<td bgcolor="#4169E1"><font color="#FFFFFF">Area</font></td>
<td bgcolor="#4169E1" ><font color="#FFFFFF">Findings</font></td>
</tr>
<tr>
<td>Bolts and Tabs</td>
<td>@{outputs('Get_response_details')?['body/Bolts and Tabs']}</td>
</tr>
<tr>
<td>Sealant</td>
<td>@{outputs('Get_response_details')?['body/Sealant']}</td>
</tr>
<tr>
<td>Perimeter</td>
<td>@{outputs('Get_response_details')?['body/Perimeter']}</td>
</tr>
</table>
Here is result:

Best Regards
Cheng Feng

Was this reply helpful? Yes No
Bokaboi 47 on at

Like (0)

Report

Hi Cheng Feng,
Thank you for this suggestion. It's 99% of the way there. The table formats nicely, exactly how I would like it to look, however, the next line of text seems to be stuck to the side of the table.

Was this reply helpful? Yes No
Verified answer

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (1)

Report

Excellent suggestion @v-chengfen-msft !

@Bokaboi , you could just add some <br/> after your </table>
or format the HTML using Divs

Was this reply helpful? Yes No
Bokaboi 47 on at

Like (0)

Report

We got there in the end,
I had to use quite a few <br> tags to push the text down past the table. I am happy with how it is formatted now.

Was this reply helpful? Yes No
Juppu 51 on at

Like (0)

Report

Great solution! helped me alot !
for anyone using a apply to each, with Concurrency Control, you can use a compose instread of a variable
or rememer to "Empty" the variable in the end.
my emails ended up having like 10 tables in them 😅

Was this reply helpful? Yes No
Chriddle 8,441 Super User 2025 Season 2 on at

Like (0)

Report

Back to the original question:
Here is a suggestion on how to “rotate” an HTML table

https://powerusers.microsoft.com/t5/Building-Flows/Compose-HTML-Table-with-02-columns-only-Column-1-Header-list/m-p/2634060#M295356

Was this reply helpful? Yes No