Скачать или смотреть Video 2. Can I REPLICATE Excel's Resource Capacity Planning in SharePoint and PowerApps?

This is the second 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 focus on how to handle unique records and filters with Patching and Collections🚀
#powerapps #excel #sharepoint #resourcemanagement #powerbi #pmo #fyp

Delivered by ‪@Changetipsandtools‬

Make sure you watch the first video in this series:   • Video 1. Can I REPLICATE Excel's Resource ...  

Power App Playlist:    • Resource Management in PowerApps  

Resource Capacity Planning Excel template playlist:   • Resource Capacity Planning  

This Video contains:
00:00 - Intro
00:47 - How to handle duplicates (Unique Records)
05:36 - Create our Programme and Project lists in SharePoint
07:58 - Link our SharePoint Lists to our Power App
09:02 - Duplicate and re use the Category screen for our Programme screen
13:29 - Change the order in the Tree View to impact Tab order
14:30 - Remove unwanted columns / headers
15:10 - Tweak your formulas and collections i.e. replace categories with your programme references
24:43 - Test and debug your new screen in your Power App
29:36 - Add a filter to our Programme Gallery
34:17 - Repeat the duplication process for our Project screen however, duplicate the Programme screen not the Category screen