Notifications
Announcements
This Flow takes a float value as an input and appropriately rounds off to two decimal places.
Use Format Number to round your number into a string, then convert the string back to a number.
This blog post solves Round off problems
https://365stack.in/index.php/2022/01/01/how-to-round-up-down-decimal-in-power-automate/
Follow 365 Stack for more updates.
In an attempt to fix the two issues mentioned, I stumbled upon a third issue - the approach taken to rounding is basically not correct, as it always rounds every number in reverse one by one.
This issue can be seen if you try to round 0.4949 to two decimal places - the correct result is 0.49, however the flow will return 0.50.
The reason why the flow returns 0.50 is that it always rounds the last decimal place:
- Step 1: 0.4949 is rounded to 0.495
- Step 2: 0.495 is rounded to 0.50
I was looking for a Power Automate equivalent to Excel's Round() function, when I stumbled upon this - at first it looked great, but after some testing, I have found two issues:
1. it cannot handle numbers that have fewer decimal places than you're trying to round off to (i.e. the number of decimal place you check against in the "Do until" action)
2. it doesn't correctly handle numbers where the first decimal place is a 0
Example 1:
enter 1.1 (where the Do until action is trying to round to 2 decimal places)
results in the flow failing
Example 2:
enter 1.0126543678992
the result returned by the flow is 1.126544
the correct result should have been 1.012654
