In this video, you will learn all about the Patch Function in Power Apps. Patch allows us to insert or update one or more records in a data source, or merge records outside of a data source. Use the Patch function to modify records in complex situations, such as when you do updates that require no user interaction or use forms that span multiple screens.
You will learn how to use the Patch function to Add and Modify items in a SharePoint List, perform error handling with Patch (Formula level error management), set columns to empty value, set complex type columns (Choice, Person) in SharePoint, modify multiple records (bulk operations) in SharePoint by using Collections and Patch, Patch Form Control updates and more.
Patch syntax:
Patch( DataSource, BaseRecord, ChangeRecord1 [, ChangeRecord2, … ])
Helpful Links 🔗:
Power Apps SharePoint Column Syntax (Lookup, Choice, Person)
https://rezadorrani.com/index.php/2020/05/04/power-apps-patch-function-with-sharepoint/
PowerApps Patch Function
https://www.youtube.com/watch?v=g9ChYuTdNd4
Patch function in Power Apps (documentation)
https://docs.microsoft.com/en-us/power-platform/power-fx/reference/function-patch
Multiple Screen Form Control & Patch in Power Apps
https://www.youtube.com/watch?v=9gI9OscTLD0
#PowerApps #Patch #SharePoint #PowerPlatform
Table of Contents:
00:00 - Introduction to Patch function in Power Apps
00:33 - Patch with SharePoint List
01:26 - Create item in SharePoint using PowerApps Patch command
04:50 - Patch complex type columns in Power Apps
07:02 - Update SharePoint item column values with Patch
12:25 - Set Blank Value & Error Handling using Patch function
15:02 - Using Patch in Gallery (Power Apps Example)
19:14 - Patch Person, Date & Text columns in SharePoint
23:37 - Bulk operations using Patch
27:56 - Multi Screen Forms using Patch
29:21 - Subscribe to Reza Dorrani channel
🤝 Let’s connect on social:
🔗 Reza Dorrani LinkedIn: https://www.linkedin.com/in/rezadorrani/
🐦 Reza Dorrani Twitter: https://twitter.com/rezadorrani