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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Cutomising Table from ...
Power Automate
Answered

Cutomising Table from excel in Power Automate

(0) ShareShare
ReportReport
Posted on by 7

Hi

 

Below is a flow I have created to automate an email report.

I however face an issue aligning the HTML table extracted from my excel report

 

XinfulTraveller_0-1668498994162.png

 

Under Create HTML Table and Compose, below is the settnngs

XinfulTraveller_2-1668499141888.png

 

Compose, Input variable expression:  replace(body('Create_HTML_table'),'<th>''<th align="center">')

XinfulTraveller_3-1668499160608.png

 

Style: 


 Updating Media

<style>
table {
font-family: Calibri, sans-serif;
font-size: 14.5px;
border: 1px solid #1C6EA4;
background-color: #EEEEEE;
width: 20%;
border-collapse: collapse;
}
table td, table th {
border: 1px solid #AAAAAA;
padding: 3px 2px;
}
table tbody td {
font-size: 14.5px;
}
table thead {
background: #1C6EA4;
border-bottom: 2px solid #444444;
}
table thead th {
font-size: 14.5px;
font-weight: bold;
color: #FFFFFF;
border-left: 2px solid #D0E4F5;
}
table thead th:first-child {
border-left: none;
}
</style>
@{outputs('Compose')}

 

Below is what I want to achieve in my email whereby Column 1 is left aligned and Column 2 is center aligned. This table should be generated from the variable "Style"

 

Table Header 1Table Header 2
cell 1cell 2.1
cell 2cell 2.2
cell 3cell 2.3
cell 4cell 2.4

 

I tried many ways but the alignment of the table seems to allow only 1 type of alignment. Is there anyway to achieve the above format?

Categories:
I have the same question (0)
  • XinfulTraveller Profile Picture
    7 on at

    I tried many ways but the alignment of the table seems to allow only 1 type of alignment. Is there anyway to achieve the above format?

  • Verified answer
    v-liwei-msft Profile Picture
    Microsoft Employee on at

    Hi @XinfulTraveller 

     

    You can use hand-written HTML table coding to achieve different alignments for each column.

    1.

    vliweimsft_0-1668577017546.jpeg

    2.

    vliweimsft_1-1668577037505.png

    3.

    vliweimsft_2-1668577050140.png

    4.

    vliweimsft_3-1668577062585.png

    5.

    vliweimsft_4-1668577074921.png

    6.

    vliweimsft_5-1668577086965.png

     

    Best Regards,

    Levi

     

     

     

     

     

     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 250 Super User 2026 Season 1

#2
Expiscornovus Profile Picture

Expiscornovus 222 Most Valuable Professional

#3
Haque Profile Picture

Haque 174

Last 30 days Overall leaderboard