Round off to two decimal places using Power Automate 03-31-2023 11:01 AM

[yashag2255]

This Flow takes a float value as an input and appropriately rounds off to two decimal places. 

[betterpractices]

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

[betterpractices]

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

[hemrhk]

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.

[jiwhite]

Use Format Number to round your number into a string, then convert the string back to a number.