Identifying Use Cases for Formulas
Start course

Microsoft Power Apps is a low-code/no-code solution that allows professional developers and non-IT professionals to create powerful applications much faster than with regularly developed applications. In this course, we will look at the core capabilities of Power Apps and how they help businesses automate and enhance repetitive, mundane, and time-consuming tasks.

We will cover canvas apps, model-driven apps, and portals, as well as their use cases and the differences between them. We'll also walk you through how to build each one. Finally, we'll take a look at the Power Apps Component Framework and how this allows developers to add even more functionality to standard Power Apps.

Learning Objectives

  • Get a foundational understanding of canvas apps, model-driven apps, and portals, including their use cases and features
  • Use data sources, controls, and formulas to build, share, and publish your own canvas apps
  • Plan, build, share, and publish model-driven apps
  • Create and customize your own portal and monitor user behavior on your portal
  • Learn about the Power Apps Framework and how it can enhance the user experience of your apps

Intended Audience

This course is intended for both IT professionals and non-technical professionals looking to automate and enhance business processes for mobile and desktop users.


There are no prerequisites for this course but any computer coding knowledge and even basic Excel knowledge would be beneficial when learning about Power Apps.


Formulas inside of Power Apps are very similar to Excel, for example, in Power Apps, the sum function allows me to sum a table of data. Here are some examples of other common use cases for formulas. It is very rare, that an app will need to just show all of the items inside of a list. More often than not, the data will need to be filtered. As you might guess, the function called filter, would do just that. If I select to this gallery, and the items or data source property, I can apply this function to filter the data in many different ways.

In my example, Employee Lists, there is a field called department. Let's filter this list so that it's only showing the employees in the sales department. To do that, I'll say filter, then you can see the function is wanting a data source or table to filter. I'll leave this as EmployeeList, I'll put a comma, and then here's where I will put my filter or logical test. Essentially, this next part of the function is what the filter will be, and what the function will use to evaluate each item in the list so that it knows whether or not to include it. I'll put department and an equal sign, and then in quotation marks, I'll put sales. Lastly, I'll put a close parentheses to close the function. Now I'm only seeing the employees, where the department field is set to sales.

Another common function is the user function. Power Apps has the capability, through this function, to gather some information, about the logged in user. Let's say we want to show a welcome message including the name of the currently logged in user. To do this, we'll add in a label. Inside of this label, we'll say, welcome, leaving a space at the end there, then we'll add an and, and now we'll say user, open parentheses, close parentheses. Notice how this function requires no input. However, this function is bringing back multiple things. If I had a period, you can see in this dropdown, that the function is getting the users name, email and image. We of course just want the name, so we'll select full name, and there we go.

The last function I'll show is the set function. This function sets what is called a global variable. The different variables in Power Apps will be covered in more detail and other courses. But for now, know that variables are used, to temporarily store data and to help applications be more efficient. If I were to use the user function, multiple times inside of this app, for example, it would cause the app to slow down because that function has to run every time that it is used to go and get the user's information. So, instead of slowing down our app, let's get the user's information one time, and store it inside of a variable. That way, each time we need the user's information, we don't have to slow down the app anymore, and can simply reference the variable. To do this, we'll go to our tree view and select app, this is where we can run formulas when app is first started. We'll say set, and we'll call our variable, varUser, and then put our user function.

Now, going back to our label, we can simply change user.full name, to varUser.full name. To actually set this variable, we'll click the ellipses, and hit run on start. Now you can see that the variable has been set, and we can see welcome Ben Fethers. We can of course, identify many other use cases for formulas or functions. Microsoft provides a list of all of the available formulas that can be used inside of Power Apps, as well as examples and how to use them. Go to to view the list.

In the next lecture, We'll cover combining multiple data sources.

About the Author

Ben is a Power Apps and Power Automate Specialist for Sovereign SP and has been using Power Apps, Power Automate, and SharePoint since 2017. Since then, he has built 100+ solutions using these amazing Microsoft tools. He loves helping others realize what technology can do and how it helps automate and enhance business processes. Most of all, though, he loves how these tools help make people’s jobs easier. The phrase, “This will make things so much easier!” is why he's in the IT business.

Ben Fetters lives in South Ogden, Utah, with his amazing wife and brand-new baby girl. A Weber State University Business Administration graduate, he loves to create businesses and help current businesses improve.