Answered

long floating numbers in send an email action

(0) Share

Report

Posted on by Jeanxyz

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)

All responses (2)

Answers (1)

Verified answer

v-yueyun-msft on at

Like (0)

Report
Copy link

Link copied!

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.

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

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

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

Was this reply helpful? Yes No
Jeanxyz 72 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No