You’re offline. This is a read only version of the page.
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.
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
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:
Share
Report
All responses (
Answers (
formatNumber(float(triggerBody()['number']), '$0.00')Replace triggerBody()['number'] with the dynamic value from PowerBI.
#1
WarrenBelz
146,651
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,999
Most Valuable Professional
