Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Philip_TopNotch
New Member

How to format a column with commas, in a html table created from a Power BI data, in power Automate.

I created a power automate flow in Power BI, that select Power BI data, creates a HTML table, with a CSS style applied, i require assistance on how to format the number column in the html table created to have comma seprators or as currency.

Philip_TopNotch_0-1685278414372.png

 I want to format the Potential loss >50M with comma seperators

Philip_TopNotch_1-1685278617746.png

 

The HTML code used for the table style.

 

 

 

<style>
table {
  border: 1px solid #1C6EA4;
  background-color: #EEEEEE;
  width: 100%;
  text-align: left;
  border-collapse: collapse;
}
table td, table th {
  border: 1px solid #AAAAAA;
  padding: 3px 2px;
}
table tbody td {
  font-size: 13px;
}
table thead {
  background: #1C6EA4;
  border-bottom: 2px solid #444444;
}
table thead th {
  font-size: 15px;
  font-weight: bold;
  color: #FFFFFF;
  border-left: 2px solid #D0E4F5;
}
table thead th:first-child {
  border-left: none;
}
</style>


@{body('Create_HTML_table')}

 

 

 

The output mail is shown below. This is the column i want to be formatted with comma seperators or as currency.

Philip_TopNotch_3-1685279024575.png

 

 

Assistance would be highly appreciated.

0 REPLIES 0

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.