Enhancing App Performance with Power Apps Named Formulas

Connor Deasey
March 5, 2024

In the dynamic world of app development, efficiency and performance are paramount. Microsoft's Power Apps offers a game-changing feature called named formulas that significantly contributes to enhancing app performance and speeding up the development process. This blog post delves into the benefits of using named formulas in Power Apps and explains how they differ from traditional `Set()` variables, especially in the context of the App.OnStart property.

What Are Named Formulas?

Named formulas in Power Apps are a part of the app’s properties that allow developers to define reusable expressions. These expressions can be associated with a name and used throughout the app, similar to variables. However, unlike variables, named formulas are evaluated only when the data they depend on changes. This leads to more efficient app performance because the app does not need to continuously re-evaluate these expressions unless necessary.

Benefits of Using Named Formulas

Enhanced App Performance

The primary advantage of named formulas is the improvement in app performance. Since named formulas are only recalculated when their dependent data changes, this reduces unnecessary computations. This is particularly beneficial for apps that process a lot of data or have complex logic, as it ensures that the app remains responsive and fast.

Speedier Development Process

Named formulas can significantly speed up the development process. By defining commonly used expressions once and reusing them throughout the app, developers can save time and reduce the likelihood of errors. This also makes the app easier to maintain and update, as changes to a named formula are automatically propagated wherever the formula is used.

Improved Maintainability and Readability

Maintaining an app becomes easier with named formulas. Since these formulas are defined in one place and can be named descriptively, it's simpler to understand what each formula does at a glance. This makes the app more readable and maintainable, not just for the original developer but also for others who might work on the app in the future.

Named Formulas vs. Set() Variables

While both named formulas and Set() variables allow you to store data, there are key differences in how they operate, especially regarding the App.OnStart property.

Usage in App.OnStart

Set() Variables: Traditional variables created with the Set() function can be initialized or modified in the App.OnStart property. This is useful for setting up global variables that the app will use. However, every time the app starts, these variables are recalculated, which can slow down app launch times, especially if the calculations are complex or depend on external data sources.

Named Formulas: Unlike Set() variables, named formulas are not explicitly recalculated during the app's startup (unless their dependencies change). This means that if a named formula depends on static data or configurations that do not change frequently, the app can launch faster since it avoids unnecessary recalculations.

Scope and Lifecycle

Set() Variables: Have a global scope when set in App.OnStart but need to be explicitly updated throughout the app whenever their values need to change. This requires additional coding and can lead to performance issues if not managed properly.

Named Formulas: Once defined, they automatically update across the app based on their dependencies. This reduces the need for manual updates and ensures that the app always uses the most current data without extra code.

How To Use Named Formulas In Your App Development

Learning new syntax can often be confusing, but we promise it's incredibly simple, take a look at our demo from this weeks Weekly Digest live session where we dive deeper into Named Formulas below.

If you want to keep up to date and follow all of the latest demos and live tutorials, plus have the opportunity to speak with one of our seasoned Power Platform coaches, join the Collab365 Academy and join our next session (Every Monday!)


Named formulas in Power Apps offer a powerful way to enhance app performance, speed up development, and ensure apps are easier to maintain. By understanding the differences between named formulas and Set() variables, developers can make informed decisions about when to use each feature to optimize their apps. As Power Apps continues to evolve, leveraging features like named formulas will be crucial for building efficient, high-performing applications that meet the demands of users and businesses alike.

Join 11,000+ in the Collab365 Academy

Master Microsoft 365, Power Apps, Power Automate, Power BI, SharePoint with Exclusive Access to 450+ Hours of Expert Training and a Wealth of Resources!