web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : yhLqd+fLxkZxA3t8wG1fC0
Power Automate - Building Flows
Answered

Transpose a HTML Table

Like (0) ShareShare
ReportReport
Posted on 20 Oct 2022 04:28:38 by 47

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.

 

  • Chriddle Profile Picture
    7,932 Super User 2025 Season 2 on 13 Mar 2024 at 12:57:38
    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 Profile Picture
    51 on 13 Mar 2024 at 12:51:50
    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 Profile Picture
    47 on 23 Oct 2022 at 23:56:03
    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.

     

    2022-10-24 09_54_12-Inbox - ben@chemisys.com.au - Outlook.png2022-10-24 09_54_24-Edit your flow _ Power Automate and 2 more pages - Work - Microsoft​ Edge.png

  • Verified answer
    SudeepGhatakNZ Profile Picture
    14,381 Most Valuable Professional on 20 Oct 2022 at 23:54:12
    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 Profile Picture
    47 on 20 Oct 2022 at 23:35:07
    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.

     

    2022-10-21 09_33_34-Edit your flow _ Power Automate and 5 more pages - Work - Microsoft​ Edge.png

     

    2022-10-21 09_09_01-Inbox - ben@chemisys.com.au - Outlook.png 

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

    vchengfenmsft_0-1666246887814.png

    vchengfenmsft_1-1666246887817.png

    <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:

    vchengfenmsft_2-1666246887818.png

     

    Best Regards

    Cheng Feng

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

    2022-10-20 15_51_37-Edit your flow _ Power Automate and 2 more pages - Work - Microsoft​ Edge.png2022-10-20 15_52_01-Edit your flow _ Power Automate and 2 more pages - Work - Microsoft​ Edge.png2022-10-20 15_52_23-Edit your flow _ Power Automate and 2 more pages - Work - Microsoft​ Edge.png

     

  • SudeepGhatakNZ Profile Picture
    14,381 Most Valuable Professional on 20 Oct 2022 at 05:10:22

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Loading complete