Power Platform Community Forum Thread Details

Hello ID-20091504-0,

Thank you for your question. The term "calculation tools" in Power Apps doesn't refer to a specific set of controls, but rather to the powerful combination of Power Fx formulas, user input controls, and display controls that allow you to perform any kind of calculation, from simple arithmetic to complex statistical analysis.

Here’s a breakdown of the core components and patterns you can use to build calculation capabilities into your Power Apps.

Core Components for Calculation

Formulas (Power Fx): This is the foundation of all calculations in Power Apps. The formula language is very similar to Microsoft Excel. You can use standard mathematical operators (+, -, *, /) and a wide range of built-in functions [, ].
- Basic Math: Sum, Average, Min, Max, Power, Sqrt
- Statistical: StdevP, VarP
- Rounding: Round, RoundUp, RoundDown
Input Controls: These are how users provide the numbers for your calculations.
- Text Input: The classic control for user input. Remember to use the Value() function to convert its text output into a number for calculations (e.g., Value(TextInput1.Text)).
- Number Input (Modern Control): A newer, more specialized control designed specifically for numeric entry, which simplifies data validation.
- Slider: Allows users to select a value from a predefined range.
Display Controls:
- Label: The primary control used to display the result of a formula. You simply set its Text property to the calculation you want to perform.

Example: Building a Simple Addition Calculator

This example demonstrates the basic principle of calculation in Power Apps.

Add two Text Input controls to your screen and name them txtFirstNumber and txtSecondNumber.
Add a Label control to display the result.
Set the Text property of the Label control to the following formula:
Value(txtFirstNumber.Text) + Value(txtSecondNumber.Text)

The label will now instantly display the sum of the numbers entered into the two text boxes.

Advanced Calculation Techniques
Once you master the basics, you can implement more sophisticated calculation patterns.

Named Formulas: For calculations you need to reuse across multiple screens, you can define them once in the App.Formulas property. This improves performance and makes your app easier to maintain. For example, you could define a global tax rate [, ].
- In App.Formulas, you could write: SalesTaxRate = 0.07;
- Then, in any Label control, you can calculate the tax on an item with: Value(txtItemPrice.Text) * SalesTaxRate
User-Defined Functions (UDFs): An extension of Named Formulas, you can create your own functions that accept parameters. This is perfect for complex, repeatable business logic.
- Example: Create a function to calculate profit margin.
- // In App.Formulas
- CalculateProfitMargin(costPrice: Number, sellingPrice: Number): Number = (sellingPrice - costPrice) / sellingPrice;
- Usage: In a label's Text property, you could call it like this: CalculateProfitMargin(Value(txtCost.Text), Value(txtSelling.Text))
External Calculations with Excel and Power Automate: For highly complex financial or engineering calculations that are already built into an Excel spreadsheet, you can use Power Automate to:
- Take input values from your Power App.
- Pass them to an Office Script that runs in your Excel file.
- The script performs the calculation in Excel and returns the result to Power Automate.
- Power Automate then sends the result back to your Power App.
- This pattern is useful for leveraging existing Excel logic without having to rebuild it in Power Fx.

By combining these controls and formula patterns, you can build anything from a simple calculator to a complex financial modeling tool directly within Power Apps.

Best Regards,

Jerald Felix

Community site session details

Calculation tools

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Tom Macfarlan – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Leaderboard > Power Pages

Featured topics

Product updates