Video 3. Can I REPLICATE Excel's Resource Capacity Planning in SharePoint and PowerApps?

This is the third video in this series where we replicate the Resource Capacity Planning template created in Excel with SharePoint, Power Apps and Power BI combined. In this video we learn about lookup columns in SharePoint, drop down controls in Power Apps and filters, again with Patching and Collections🚀 #powerapps #excel #sharepoint #resourcemanagement #powerbi #pmo #fyp Delivered by @Changetipsandtools Power App Playlist: https://www.youtube.com/playlist?list=PLHo4KrxeEewkGgfdHK4Clf1HrbRAoBPRU Excel Playlist: https://www.youtube.com/playlist?list=PLHo4KrxeEewmLTytN7-nz8vXNOS3mJzwM This video contains: 00:00 - Intro 00:36 - Create our SharePoint list with lookups 06:49 - Create our Cross Reference screen in Power Apps 17:32 - Dropdown Controls in Power Apps 39:23 - Use a drop down control to filter our gallery and also how to handle blanks 46:12 - How to add a blank selection to your drop down control choices 49:24 - Using collections for your Drop Down Choices and the importance of the field property