Combining Multiple Data Sources
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.


A common way to combine data sources is showing how two data sources relate. Taking a look at the data sources of our app, you can see that I've added a departments list. This departments list contains the same departments as the items or employees inside of our employees list. To show an example of how we can combine these data sources, let's create a dropdown of departments, and then filter the employee list based on the selected department.

First, I'll add a dropdown and for its data source select our departments list. The value property will show which field the drop down will be showing, since there could be multiple fields. I'll select Department. Next, we'll look at our gallery of employees. In the items property, I'll change the filter to Department equals, and here is where we can reference our dropdown control. I can see that my dropdown control's name is Dropdown1. I'll type in Dropdown1 and then to reference the selected item I'll say "Selected". Since the selected item could have more fields associated with it, I'll need to specify that I want the Department field of the selected item. And now you can see that the gallery is being filtered based off of our selected item in the departments list. I could also combine these data sources by having a gallery of all the departments and then for each department show all of the employees that are inside of that department. This, however, would go beyond this introductory course on Power Apps. 

In the next lecture, we'll cover sharing and publishing your canvas apps.

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.