web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Copilot Studio / long floating numbers ...
Copilot Studio
Answered

long floating numbers in send an email action

(0) ShareShare
ReportReport
Posted on by Jeanxyz 72

Hi, I used the flow to send out timesheet reminder emails, in the email I used data from a Power BI table, although numbers are well formatted in Power BI, they become long floating numbers in the email:

below is an example of the email. I would like to round up both numbers to two decimals. 

Dear xxxx,
This is a gentle reminder that your timesheet is not fully completed.
recorded hours:
57.00000000000001
completion rate:
0.3571428571428572

 

 

 powerbi rounding.PNG

 

Categories:
General topics
I have the same question (0)
  • Verified answer
    v-yueyun-msft Profile Picture
    v-yueyun-msft Microsoft Employee on at

    Hi , @Jeanxyz 

    This should be because you're just formatting the data in Power BI, so the data coming into flow is still the original value.

    For your need , you can use the expression in Power Automate to format the number.

    First , you can use your mouse hover to the field in your flow and you can see its expression in flow.

    vyueyunmsft_0-1710897290434.png

    For example , here is my expression for the Country field.

    items('Apply_to_each')?['Country']

    vyueyunmsft_1-1710897363569.png

     

    So we can use this expression to format the number in flow.

    formatNumber(items('Apply_to_each')?['Country'],'0.00')
     
    formatNumber(Your field expression ,'0.00')
     

    If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance! 

     

    Best Regards,

    Yueyun Zhang

     

     

  • Jeanxyz Profile Picture
    Jeanxyz 72 on at

    Thanks a lot for help. Also the mouse hover-over trick is very helpful. 

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the February Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Copilot Studio

#1
Valantis Profile Picture

Valantis 445

#2
Romain The Low-Code Bearded Bear Profile Picture

Romain The Low-Code... 123 Super User 2026 Season 1

#3
chiaraalina Profile Picture

chiaraalina 59 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Announcing the "Microsoft Copilot Studio ❤️ MCP" lab
Block PII/PCI in Copilot Studio agent user prompt
Welcome to the Copilot Studio forum!

Product updates

Microsoft Power Platform Community release plans