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

If you're wondering if you can replicate Excel's resource capacity planning in SharePoint and PowerApps, this video is for you! Learn how to streamline your PMO processes and improve efficiency because you are tired of relying on Excel in your business processes? or you simply need something on a larger scale?
In this video which is the first in this series, we explore the possibility of replicating Excel's resource capacity planning in SharePoint and PowerApps and improve on the original template that I created on this channel (link below). We'll dive into the features and capabilities of both platforms to see if they can match Excel's functionality. Later in the series we will then combine SharePoint, PowerApps with Power BI 🚀🚀🚀Whether you're a business owner, project manager, or team leader, this video is for anyone looking to optimize their resource planning and allocation processes. Tune in to find out if SharePoint and PowerApps can be a viable alternative to Excel for resource capacity planning template created on this channel.

#powerapps #excel #sharepoint #resourcemanagement #powerbi #pmo #fyp

Delivered by  @Changetipsandtools 

Power App Playlist:    • Resource Management in PowerApps  

Resource Capacity Planning series in Excel:    • Resource Capacity Planning  

This video contains:
00:00 - Intro
00:40 - The objective of this video
02:06 - Demo of Power App screen we will create together in this video
03:37 - Create our Categories SharePoint List
06:30 - Navigating to PowerApps for the first time
07:03 - Create our first Power App with a blank canvas in PowerApps
07:23 - The PowerApps editing layout overview
07:57 - Connect to our SharePoint data source
08:48 - Save and give our Power App project a name
09:07 - Change settings to include modern features re PowerApps controls
09:21 - Create a base screen template for all our user edit and view screens
15:30 - Create our Categories Screen from the base template
20:07 - Build our data entry using containers and the Gallery Control
33:40 - How to switch from data entry mode and to view mode
39:44 - How to edit existing data with PowerApps and save back to SharePoint
51:02 - How to Create new records in PowerApps and save back to SharePoint
01:07:53 - How to add Undo and Delete functionality in PowerApps
01:18:03 - Error Handling in PowerApps