web
Youโ€™re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : ZmzDD9gUC+SqjsDRDDzzHX
Power Automate - Building Flows
Answered

Format number for html table and sendind email

Like (0) ShareShare
ReportReport
Posted on 15 Jun 2023 13:08:41 by 50

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.

  • menphis Profile Picture
    50 on 22 Jun 2023 at 08:08:49
    Re: Format number for html table and sendind email

    HI @David_MA ,

     

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

  • menphis Profile Picture
    50 on 18 Jun 2023 at 14:14:59
    Re: Format number for html table and sendind email

    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

  • Verified answer
    menphis Profile Picture
    50 on 15 Jun 2023 at 14:14:29
    Re: Format number for html table and sendind email

    Great it works, thanks ๐Ÿ™‚

  • Verified answer
    David_MA Profile Picture
    11,841 Super User 2025 Season 2 on 15 Jun 2023 at 13:46:45
    Re: Format number for html table and sendind email

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful forโ€ฆ

Paul Stork โ€“ Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Communityโ€ฆ

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2