Round

How to Use the Power Fx Round  Function in Power Apps

What is the Power Fx Round Function?

The Power Fx Round function is a mathematical function that is used to round numbers to a specified number of decimal places. This function can be used in Power Apps to round numbers that are displayed in text boxes, labels, or any other control that displays numbers. The Power Fx Round function takes two arguments:

1. The first argument is the number that you want to round.

2. The second argument is the number of decimal places that you want to round to.

How to Use the Power Fx Round Function in Power Apps

Here’s a step-by-step guide on how to use the Power Fx Round function in Power Apps:

1. Open the Power Apps Studio and create a new app or open an existing app.

2. Add a text input control to your app by selecting the “Text input” control from the “Insert” tab.

3. Add a label control to your app by selecting the “Label” control from the “Insert” tab.

4. In the “Text” property of the label control, enter the following formula: `Round(TextInput1.Text, 2)`

5. Run the app and test the functionality of the Round function by entering a number with several decimal places into the text input control.

By following these steps, you should be able to use the Power Fx Round function in your Power Apps to round numbers to the specified number of decimal places.

Examples of Using the Power Fx Round Function in Power Apps

Here are some examples of how you can use the Power Fx Round function in your Power Apps:

Example 1: Rounding a Number to the Nearest Whole Number

Suppose you have a number in your Power App that has several decimal places, and you want to round it to the nearest whole number. Here’s how you can do that using the Power Fx Round function:


Round(123.456, 0)


This formula will round the number 123.456 to the nearest whole number, which is 123.

Example 2: Rounding a Number to the Nearest Tenth

Suppose you have a number in your Power App that has several decimal places, and you want to round it to the nearest tenth. Here's how you can do that using the Power Fx Round function:


Round(123.456, 1)


This formula will round the number 123.456 to the nearest tenth, which is 123.5.

Example 3: Rounding a Number to the Nearest Hundredth

Suppose you have a number in your Power App that has several decimal places, and you want to round it to the nearest hundredth. Here's how you can do that using the Power Fx Round function:


Round(123.456, 2)


This formula will round the number 123.456 to the nearest hundredth, which is 123.46.

Example 4: Rounding a Number to the Nearest Thousandth

Suppose you have a number in your Power App that has several decimal places, and you want to round it to the nearest thousandth. Here's how you can do that using the Power Fx Round function:


Round(123.456, 3)


This formula will round the number 123.456 to the nearest thousandth, which is 123.456.

The Power Fx Round function is a powerful tool that can help you round numbers in your Power Apps. By following the steps outlined in this article, you should be able to use the Power Fx Round function in your Power Apps to round numbers to the specified number of decimal places. We hope this article has been helpful, and we wish you the best of luck in your Power Apps development!

Power Apps Training Courses by G Com Solutions (0800 998 9248)