Add Data Connections to Other Sources in an Existing Power App

Learn how to connect your existing Power App to a SharePoint list and an Excel workbook. By the end of this video your app will utilize Drop down controls with multiple data sources.

In this video you will learn about:

• Adding Drop down controls with different data sources

Link to the video on YouTube: PowerApps Multiple Data Sources

Link to the video for Curated Library subscribers: Power Apps Multiple Data Sources

Key timestamps:

• 0:00 Intro

• 1:06 Demo of the solution and remove the Drop down controls and data sources

  • Shane demonstrates the functionality of his employees app. The app includes two Drop down controls. He then removes both Drop down controls and the corresponding data sources

• 4:05 Add the data sources back to the app

  • An Excel workbook and a Sharepont list are added as data sources.

• 6:36 Add a Drop down control to the Department card and set the default value

  • In the Edit screen, the Department card is unlocked and the field is deleted. A Drop down control is then added to the Department card. The data source for the Department card is an Excel workbook. Shane troubleshoots two error messages. An If function is inserted in the default of the Department Drop down control.

• 12:56 Add a Drop down control to the Favorite Color card and set the default value

  • In the Edit screen, the Favorite Color card is unlocked and the field is deleted. A Drop down control is then added to the Favorite Color card. The data source for the Favorite Color card is a SharePoint list. An If function is inserted in the default of the Favorite Color Drop down control. Shane troubleshoots two error messages.

• 18:52 Demo of the final solution

  • Shane demonstrates the functionality of his employees app with the two Drop down controls that were just created.

Additional learning:

• Video: Learn to connect: PowerApps Excel Spreadsheet hosted in OneDrive

• Do you want to become a Power Apps Rockstar? Check out our different full length training classes at https://training.PowerApps911.com or you can download a working version of the app we built today by subscribing to the Curated Library.