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:
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.