From the course: Power Apps: Building Data-Driven Apps with Excel

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

Linking multiple data sources

Linking multiple data sources

From the course: Power Apps: Building Data-Driven Apps with Excel

Start my 1-month free trial Buy for my team

Linking multiple data sources

“

- [Instructor] One of the options that you have with Power Apps is to use multiple data sources within a single app. This gives you the ability to use the other data sources to define your dropdown or other selection choices, enabling you to manage that information separately. This works like a lookup table in Excel or SharePoint. In the table we've been working with, let's say that we wanted to define the employee region separately from the main data. So, I've created another simple table with this information on it. Now, back in Power Apps, I want to select the edit form, and then click the data source link in the left panel. Now, this is a little odd. If we click Add Data, we get a list of Dataverse tables but not the table we're looking for. What we need to do is search for the place our data is saved, in this case OneDrive for Business. Then select the correct account. Then we can select the workbook and…

Contents