Named Formula in Power Apps
Power Apps
Sep 24, 2022 12:00 AM

Named Formula in Power Apps

by HubSite 365 about Dhruvin Shah [MVP]

Microsoft MVP (Business Application & Data Platform) | Microsoft Certified Trainer (MCT) | Microsoft SharePoint & Power Platform Practice Lead | Power BI Specialist | Blogger | YouTuber | Trainer

Citizen DeveloperPower AppsM365 ReleasePower Selection

During this video, we will talk about Named Formula in Power Apps. Named Formula in Power Fx is inspired from Excel's “Name Manager.”

In Excel, you can name any cell and refer to that name throughout the workbook. It adds a level of indirection that allows you to move that cell reference by name rather than by location. And inspiring the introduction into Power Fx, it also allows you to bind a name to a formula that isn’t in a cell. In today's video we will talk about What do we mean by named formula in Power Apps? When to use named formula? What's the basic difference between Named formula and Variables in Power Apps? You'll get all the answers from this video!

Power Fx: Introducing Named Formulas

I am thrilled to introduce you to an old concept. A powerful concept that has been in Excel for a very long time, that we are now bringing to Power Fx. With it, you can simplify your app’s initialization, reduce app load time, reuse logic, and improve the maintainability of your apps.

Key Takeaways:

  1. What is Named Formula in PowerApps?
  2. Power Fx - Named Formula
  3. How named formula is different from Set Variable?
  4. Advantages using Named Formula in Power Apps
  5. Examples of Named Formula in Power Apps


00:00 Start

00:37 What do we mean by Named Formula?

02:55 Name Manager in Excel

03:30 App Start - Set Variable

04:20 Named Formula Vs Set Variable in Power Apps

05:03 Activate Preview Feature for Named Formulas

05:45 Define Named Formula in Power Apps

06:47 Named Formula with Data Source Connectivity

07:25 Use Named Formula

07:36 When will Named Formula Executed?

08:40 Named Variable with Dynamic Dependancy

10:24 Formatting Property using Named Variable

11:11 Advantages of using Named Formula in Power Fx

12:25 Subscribe!