in

How to Use the Power Fx inĀ  Function in Power Apps

One of the key features of Power Apps is the Power Fx function. Power Fx is a formula language that is used to create calculations and logic within the app. It is similar to Excel formulas and is designed to be easy to use and understand.

In this article, we will discuss how to use the Power Fx function in Power Apps to create powerful and efficient applications.

Getting Started with Power Fx

Before we dive into the details of using Power Fx, it’s important to understand the basics of the formula language. Power Fx is a functional language, which means that it is based on functions and arguments.

Functions are predefined calculations or operations that can be used to manipulate data or perform specific tasks. Arguments are the values that are passed to the function to perform the calculation or task.

To use Power Fx, you need to create a formula that consists of functions and arguments. You can create formulas in Power Apps by using the formula bar, which is located at the top of the screen.

Using Power Fx in Power Apps

Now that we understand the basics of Power Fx, let’s dive into how to use it in Power Apps. Here are some common tasks that you can perform using Power Fx:

1. Creating Calculations

One of the most common uses of Power Fx is to create calculations within the app. For example, you may want to calculate the sum of two fields or average a set of numbers.

To create a calculation using Power Fx, you can use one of the many built-in functions, such as SUM, AVERAGE, or COUNT. Here’s an example of how to calculate the sum of two fields:


Sum(Field1, Field2)


2. Setting Visibility

Another common use of Power Fx is to set the visibility of controls within the app. For example, you may want to hide a button until a certain condition is met.

To set the visibility of a control using Power Fx, you can use the IF function. Here’s an example of how to hide a button if a field is empty:


If(IsBlank(Field1), false, true)


3. Creating Filters

You can also use Power Fx to create filters within the app. For example, you may want to filter a gallery based on a certain condition.

To create a filter using Power Fx, you can use the FILTER function. Here’s an example of how to filter a gallery based on a specific value:


Filter(Gallery1, Field1 = "Value1")


4. Creating Variables

Power Fx allows you to create and use variables within your app. Variables are temporary values that can be used to store data or perform calculations.

To create a variable using Power Fx, you can use the VAR function. Here’s an example of how to create a variable:


Var MyVariable = Field1 + Field2


5. Creating Collections

Collections are another important feature of Power Apps that allow you to store and manipulate data within your app. You can use Power Fx to create collections and perform operations on them.

To create a collection using Power Fx, you can use the COLLECT function. Here’s an example of how to create a collection:


Collect(MyCollection, {Title: "Item1", Value: 100})


In conclusion, Power Fx is a powerful and flexible formula language that can help you create custom applications using Power Apps. By understanding the basics of Power Fx and how to use it within the app, you can create powerful and efficient solutions for your business needs.

We hope this article has provided you with valuable insights into using Power Fx in Power Apps. If you have any questions or need further assistance, please don’t hesitate to contact us.

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