Good day,
I have a flow taking information from a SQL view and based on a condition creates an notification email with a html table in the body. Howerver I have number fields in the table that I would like to be displayed with a comma as thousand seperator.
I removed a few lines from the table to make it shorted/more readable, but below the code from the body in power automate
<style type="text/css">
.auto-style1 {
width: max-content;
}
.auto-style2 {
width: max-content;
border: 2px solid black;
}
}
.auto-style3 {
width: max-content;
text-decoration: underline;
font-weight: bold;
font-size: 25px;
}
}
.auto-style4 {
width: max-content;
text-decoration: underline;
font-size: 15px;
}
</style>
<table class="auto-style1">
<tr>
<td class="auto-style4"><strong>Customer: @{items('Apply_to_each_2')?['Name']}</strong></td>
</table>
</style>
<table class="auto-style1">
<tr>
<tr>
<td class="auto-style2">RepName</td>
<td class="auto-style2">@{items('Apply_to_each_2')?['RepName']}</td>
</tr>
<tr>
<td class="auto-style2">Reports to</td>
<td class="auto-style2">@{items('Apply_to_each_2')?['REPORTS_TO_NAME']}</td>
</tr>
<tr>
<td class="auto-style2">Available Balance</td>
<td class="auto-style2">R@{items('Apply_to_each_2')?['AvailableBalance']}</td>
</tr>
</table>
Table in email look as follows:
I did a test with the following and it seems to convert, but not sure how to join it with table:
<html>
<body onload="separateNumber()">
<script type="text/javascript">
function separateNumber()
{
givenNumber = 123456789;
nfObject = new Intl.NumberFormat('en-US');
output = nfObject.format(givenNumber);
document.querySelector('.output').textContent = output;
}
</script>
<p><span class="output"></span>
</p>
</body>
</html>
I've tried formating at source but the running into data format /numeric/string issues.
Any one perhaps with an example on how to achieve the thousand seperator?
Kind Regards
