How to use PATCH Function in Power Apps | Insert and Update data
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.
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
More about this topic
7 Ways To Use The PATCH Function In Power Apps (Cheat Sheet)
Power Apps PATCH function is the hardest function to understand. Why? The Patch function is the only function you can use 7 different ways. Yeah, you heard me right. Seven. That’s why I built a no-nonsense cheat sheet that you can use to quickly figure out how the patch function works.
https://www.matthewdevaney.com/7-ways-to-use-the-patch-function-in-power-apps-cheat-sheet/
Patch function in Power Apps
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.
https://docs.microsoft.com/en-us/power-platform/power-fx/reference/function-patch
Power Apps Patch function with SharePoint Columns
In this video on Power Apps Patch function with SharePoint Columns, we will create and update items for all SharePoint column types along with tips & best practices for using the Patch function or Patch command.
https://www.youtube.com/watch?v=g9ChYuTdNd4&t=0s