How to use Set in PowerApp

The Set function in Power Apps is used to assign a value to a variable. It allows you to store and manipulate data within your app. In this explanation, we will provide a step-by-step guide on how to use the Set function effectively in Power Apps. We will explore its syntax, discuss the necessary steps, and provide example code to illustrate its usage.

Step 1: Create a Variable First, you need to create a variable to store the value. Variables are temporary storage locations within your app that can hold different types of data, such as text, numbers, or collections.

Step 2: Add a Control to Trigger the Set Function Next, add a button or any other control to your Power App’s screen that will trigger the Set function. This control will be used to assign a value to the variable.

Step 3: Define the OnSelect Property of the Control Select the control you added in the previous step, and in the formula bar, enter the following code:

mathematicaCopy codeOnSelect = Set(VariableName, Value)

In this code, “VariableName” represents the name of the variable you want to create or update. Replace it with a descriptive name that reflects the purpose of the variable. “Value” specifies the value you want to assign to the variable. This can be a constant value, a reference to a control’s property, or the result of a formula.

Step 4: Use the Variable in Your App Once you have set the variable value, you can use it throughout your app. You can reference the variable in formulas, assign it to control properties, or perform calculations with it.

Here’s an example scenario to illustrate the usage of the Set function:

Suppose you have a Power App that calculates the total cost of items selected by the user. You want to create a variable named “TotalCost” to store the calculated value.

To create and use the “TotalCost” variable, follow these steps:

Step 1: Create a Variable In the OnStart property of your app, enter the following code:

Set(TotalCost, 0)

This code creates a variable named “TotalCost” and initializes it with a value of 0.

Step 2: Add a Button Control Add a button control to your Power App’s screen that will trigger the Set function.

Step 3: Define the OnSelect Property of the Button Control Select the button control, and in the formula bar, enter the following code:

OnSelect = Set(TotalCost, CalculateTotal())

In this code, “CalculateTotal()” represents a custom function or formula that calculates the total cost based on the user’s selections. Replace it with your specific calculation logic.

Step 4: Use the Variable in Your App You can use the “TotalCost” variable in various parts of your app. For example, you can display it in a label control to show the calculated total cost:

Text = "Total Cost: " & TotalCost

Or you can use it in other calculations or conditions throughout your app.

The Set function is a powerful tool in Power Apps to create and update variables, allowing you to store and manipulate data within your app. By incorporating this function into your Power Apps, you can perform dynamic calculations, control app behavior, and provide valuable insights to your users.