Format number for html table and sendind email

(0) Share

Report

Posted on by menphis

HI,

New to the power Automate community.

I'm trying to create a flow that creates an HTML table with a CSS design and emails it from a button click in Power Bi.

But I can't change the format of the number inside the table and in the body of the email.

I've tried format number, format expressions but not sure if I'm using them right.

Thanks for the help.

Categories:

Building flows

All responses (4)

Answers (2)

Sort by

Verified answer

David_MA 15,508 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
You need to use an expression to do this in the Select action. Doing it in the Apply to each is not really doing anything. You can use the following expression:

formatNumber(float(triggerBody()['number']), '$0.00')

Replace triggerBody()['number'] with the dynamic value from PowerBI.
Verified answer

menphis 58 on at

Like
a
(0)

Report
Copy link

Link copied!

Great it works, thanks 🙂
menphis 58 on at

Like
a
(0)

Report
Copy link

Link copied!

HI @David_MA ,

It worked from the Power BI Desktop, but from power BI Services, it shows "unsuccesfull".
Here the error message:
The execution of template action 'Select_2' failed: The evaluation of 'query' action 'where' expression '{
"Partner": "@item()?['BI Partner']",
"Current": "@formatNumber(float(item()['Sum of Current_']), 'N')",
"31-60 Days": "@formatNumber(float(item()['Sum of 31 to 60 Days']), 'N0')",
"61-90 Days": "@formatNumber(float(item()['Sum of 61 to 90 Days']), 'N0')",
"91-120 Days": "@formatNumber(float(item()['Sum of 91 to 120 Days']), 'N0')",
"121-150 Days": "@formatNumber(float(item()['Sum of 121 to 150 Days']), 'N0')",
"151-180 Days": "@formatNumber(float(item()['Sum of 151 to 180 Days']), 'N0')",
"Over 180 Days": "@formatNumber(float(item()['Sum of Over 180 Days']), 'N0')"
}' failed: 'The template language expression 'formatNumber(float(item()['Sum of Current_']), 'N')' cannot be evaluated because property 'Sum of Current_' doesn't exist, available properties are '_Balance Amount, BI Partner, BI Partner Email, Nb invoices not settled'. Please see https://aka.ms/logicexpressions for usage details.'.

Can you help me ?
Thanks
menphis 58 on at

Like
a
(0)

Report
Copy link

Link copied!

HI @David_MA ,

Did you have time to see ? Have you an idea that i am supposed to do ?
Thanks