Formatting the values in an HTML Table

(0) Share

Report

Posted on by MM-17101826-0

I'm working on a flow that sends an email with an HTML table in the body of the email. The flow works with the exception of the number formatting of the table contents. It's set up by running the "Run a query against a dataset" action, where I pull the contents of a table from a dataset in Power BI. I then create the HTML table using First Table Rows value of that output, and use css formatting to format it into an excel style grid.

This is the output

Value1 %	Value2	Value3	Value4	Value5	Value6	Value7 %
0.130416962	1087	1679578214	67805	176.7148114	192089	0.768476209

And this is the desired output

Value1 %	Value2	Value3	Value4	Value5	Value6	Value7 %
13%	$1,087	$1,679,578,214	$67,805	$177	$192,089	77%

I've tried using the formatnumber function and other actions to try to format the numbers properly but all fail, usually due to an error that it can't find the field I'm calling.

How am I able to format? Here is my flow currently:

Categories:

Building flows

I have the same question (1)

All responses (3)

Answers (0)

Suggested answer

PaulSGodden 47 on at

Like (0)

Report
Copy link

Link copied!

Hi, Might not solve everything but suggest watching Advanced HTML Tables in Power Automate - Formatting cells, rows and vertical tables (youtube.com) which helped me solve a similar problem I was having. There is a section on formatting numbers including decimal places

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

For percentage columns

concat(formatNumber(mul(items('Apply_to_each')?['Value1'], 100), '0'), '%')

For currency columns

concat('$', formatNumber(items('Apply_to_each')?['Value2'], '###,###'))

For rounding values

formatNumber(items('Apply_to_each')?['Value5'], '0')

Was this reply helpful? Yes No
MM-17101826-0 2 on at

Like (0)

Report
Copy link

Link copied!

@SudeepGhatakNZ where in the flow should I be entering this code?

Was this reply helpful? Yes No