Answered

long floating numbers in send an email action

Like (0) Share

Report

Posted on 19 Mar 2024 20:55:02 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

All responses (2)

Answers (1)

Jeanxyz 72 on 25 Mar 2024 at 08:32:27

Like (0)

Report

Re: long floating numbers in send an email action

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

v-yueyun-msft on 20 Mar 2024 at 01:18:31

Like (0)

Report

Re: long floating numbers in send an email action

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