Power Apps Variables, Collections & Named Formulas


Power Apps offers a powerful trio for storing and managing data within your applications: variables, collections, and named formulas. Each tool serves a distinct purpose, and mastering them unlocks greater flexibility and control over your app's functionality. Let's dive into each one and explore their unique strengths:


  • Types: Local (specific to a screen) and Global (accessible across all screens).
  • Mutability: Values can be changed dynamically throughout the app.
  • Use cases: Storing temporary data, user input, calculations, and conditional logic.


UpdateContext({myVar:Text("Hello, " & User().Email)}); // Local Variable
Set(myVariable, Text("Hello, " & User().Email));//Global Variable


  • Function like mini-tables, storing records with multiple fields.
  • Mutability: Values within records can be modified.
  • Use cases: Managing lists of data, filtering and sorting, and passing data between screens.


ClearCollect(shoppingCart, {Name: "Milk", Quantity: 2}, {Name: "Bread", Quantity: 1})
Gallery1.Items = shoppingCart

// Update quantity in a record
UpdateIf(shoppingCart, Name = "Bread", Quantity = Quantity + 1)

Named Formulas

  • Immutable: Once defined, their value cannot be changed.
  • Reusable: Define complex calculations or data lookups once and reference them throughout the app.
  • Use cases: Reducing formula redundancy, improving readability, and encapsulating logic.


// Define a named formula for calculating sales tax in Formulas of PowerApps
CalculateTax = Value * 0.07

//To Update CalculateTax we can update Value variable only

Choosing the Right Tool

The best tool depends on your specific needs. Use variables for temporary data, collections for managing lists, and named formulas for reusable calculations and data lookups.