en | de
Worldwide Content
Aug 23, 2022 12:00 AM

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

  • Know-HowContent Type
  • Aug 22, 2022First published
  • 2 minReading Time
  • EnglishArticle Language