Transpose a HTML Table

Like (0) Share

Report

Posted on 20 Oct 2022 04:28:38 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.

All responses (8)

Answers (1)

Chriddle 7,932 Super User 2025 Season 2 on 13 Mar 2024 at 12:57:38

Like (0)

Report

Re: Transpose a HTML Table

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
Juppu 51 on 13 Mar 2024 at 12:51:50

Like (0)

Report

Re: Transpose a HTML Table

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 😅
Bokaboi 47 on 23 Oct 2022 at 23:56:03

Like (0)

Report

Re: Transpose a HTML Table

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.
Verified answer

SudeepGhatakNZ 14,381 Most Valuable Professional on 20 Oct 2022 at 23:54:12

Like (1)

Report

Re: Transpose a HTML Table

Excellent suggestion @v-chengfen-msft !

@Bokaboi , you could just add some <br/> after your </table>
or format the HTML using Divs
Bokaboi 47 on 20 Oct 2022 at 23:35:07

Like (0)

Report

Re: Transpose a HTML Table

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.
v-chengfen-msft on 20 Oct 2022 at 06:24:05

Like (4)

Report
Re: Transpose a HTML Table

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
Bokaboi 47 on 20 Oct 2022 at 05:58:56

Like (0)

Report

Re: Transpose a HTML Table

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:
SudeepGhatakNZ 14,381 Most Valuable Professional on 20 Oct 2022 at 05:10:22

Like (0)

Report

Re: Transpose a HTML Table

@Bokaboi ,

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