In this Power Apps Tutorial, we will learn about Patch() and how to use it in the Power Apps gallery with various scenarios. We are also going to cover the following topics in this tutorial:
- What is Patch() in Power Apps?
- Power Apps Patch() syntax
- Power Apps patch gallery to SharePoint
- Power Apps patch gallery updates an existing item
- Power Apps patch function to get item id
- Power Apps gallery patch all items
- Power Apps reset gallery after patch
- Power Apps gallery Reset inputs fields after patch
- Power Apps gallery patch selected item
- Power Apps patch gallery dropdown
- Power Apps patch gallery date
- Power Apps patch collections to gallery
- Power Apps patch gallery Number
- Power Apps patch gallery person Field
- powerapps patch gallery check box or patch thisitem
What is Patch() in Power Apps?
Before we begin working with Patch() in the Power Apps gallery, we must first understand what Patch() is and how it is used.
- Power Apps Patch function is used to create or modify a single record or a list of records within the data source.
- This enables you to alter the values of fields without affecting other properties. The patch has the ability to save data from multiple screens at the same time.
- When dealing with complex types Power Apps Patch is extremely beneficial.
- Also, if you want to update or create multiple records using the Power Apps Patch function, you must use the ForAll function in Power Apps.
- To use the Power Apps Patch function, you must first create a base record with default values using the Defaults function.
Also Read: Power Apps Gallery Filter [With Real Examples]
Power Apps Patch() syntax
Now we will see what the syntax is and how to use the Power Apps patch functions in different scenarios such as:
- To create a new record within the data source using the Power Apps patch function, the syntax will be:
Patch(<Datasource>, BaseRecord, NewRecord)
Where,
- DataSource: the name of the data source that contains the record you want to create or modify.
- BaseRecord: The specified record that will be created.
- NewRecord: Specify the new records with values that will be created in the data source.
2. To modify an existing record within the data source using the Power Apps with Patch function, the syntax will be:
Patch(<DataSource>, BaseRecord, ChangeRecord1 [, ChangeRecord2, … ])
Where ChangeRecord(s) are the one or more records that hold properties to modify in the BaseRecord and are processed in the order of the argument list.
3. To modify or add multiple records within the data source, the following Power Apps patch function will be:
Patch(<DataSource>, BaseRecordsTable, ChangeRecordTable1 [, ChangeRecordTable2, … ] )
Where ChangeRecordTable(s) are the one or more record tables containing properties to modify for each record in the BaseRecordTable. Modify records are processed in the order they appear in the argument list, with later property values overriding earlier ones.
4. To change the values of a record variable within the data source, the following syntax of the Power Apps patch function will be:
Patch(<Record1>, <Record2>)
5. To get the record that is modified or created within the data source, the patch syntax will be:
Set(VariableName, Patch(<Datasource>, BaseRecord, ChangeRecord))
Check: Power Apps Data Table [Complete Guide]
Power Apps patch gallery to SharePoint
Here, we will see how to use the patch function from the Power Apps gallery on SharePoint. Before that, we need to prepare a SharePoint list and build a PowerApps gallery using that list.
Also, we will insert a button into the app so that when the user clicks on the button, it will create a new item in the SharePoint list.
So we have prepared a SharePoint list named ‘Vehicles‘ having some columns such as:
Columns | Types |
Title | Default |
Regd Number | A single line of text |
Wheels | Number |
Color | A single line of text |
Country | A single line of text |
State | A single line of text |
Owner | A single line of text |
Date | Date and Time |
To build a gallery on the Power Apps, the following steps are:
- Sign in to the Power Apps with your Office 365 ID or Microsoft user ID.
- Then it will open the Home page of the Power Apps.
- Go to Create (On the left panel) > Blank app > Blank canvas app > Create.
- Give a name to the app and choose a format i.e., tablet or mobile.
- Click on Create.
We can see it will create an app with a blank screen where we will use the gallery to show the data source.
To connect the app with the data source, the following steps are:
- Go to Data (on the left side nav panel).
- Click on “+Add data.”
- Select your data source, i.e., search for SharePoint in the search bar.
- Choose your connection.
- Choose your SharePoint site.
- Check the SharePoint list, i.e., Vehicles, and click on Connect.
We can see the data source is connected to the Power Apps. To check this, go to the Data section and find the data source.
Let’s use this data source in a gallery. To do this, the following steps are:
- Go to the Insert tab > Gallery.
- Select Blank vertical gallery.
- Choose the data source.
- Click on Layout (on the right side properties panel) > choose a layout as per your choice to show the data like below:
The Power Apps will now have a button control. When the button is pressed, a new item is created on the specified data source.
To add the button control, go to the Insert tab > Button. Rename the button as Create Item.
On the button’s OnSelect property insert the below expression to create a new item inside the SharePoint list.
OnSelect = Patch(Vehicles,Defaults(Vehicles),{Title:"Royal enfield",'Regd Number':"RE2002",Wheels:4,Color:"Matt Black", Country:"UK",State:"Scotland",Owner:"Marrie",Date:Date(2022,8,23)})
Where,
- Vehicles – The name of the data source
- Title, Regd Number, Wheels, Color, Country, State, Owner, Date – The name of the SharePoint list columns.
That’s it! Let’s save, publish, and play the app in preview mode. We can see a new item has been created once the button is clicked on the app.
Also, we can see that a new item has been created in the SharePoint list too.
This is how to create a new SharePoint list item from Power Apps using a patch.
Also, Read: Power Apps Radio Button
Power Apps patch gallery updates an existing item
Here, we will see how to update a gallery item using the patch function. We are going to use the above Power Apps gallery to implement this requirement.
Suppose, we want to update the item that we have created recently. To do this, insert the below expression within the button’s OnSelect property.
OnSelect = Patch(Vehicles,LookUp(Vehicles, ID = 16),{'Regd Number':"RE2020",Wheels:2})
Where,
- Vehicles – The name of the data source.
- ID – The name of the prebuilt column of the SharePoint list.
- Regd Number, Wheels – The SharePoint column names that we want to modify.
Save, publish, and play the app now. When we clicked on the button, we saw that the item had been modified.
This is how to update a gallery item using the Power Apps Patch function.
Check out: PowerApps stuck on getting your data
Power Apps gallery patch get the item ID
In this section, we’ll look at how to get the item ID from the Power Apps gallery using the Patch function. When the user inserts any data into the gallery, it will create a new item in the SharePoint list and the user can retrieve the ID of that new item.
We have prepared another SharePoint list named “Voters list” which has columns such as Title, Address, and Age.
Using the above SharePoint list, we have to build a Power Apps gallery where we have inserted 3 text inputs to insert the Title, Age, and Address respectively. Again, add a label control to show the ID of the created item and a button control to create an item within the gallery.
To create the new item dynamically within the gallery, we need to insert the below expression within the button’s OnSelect control. So that it will create a new item within the Power Apps gallery.
OnSelect = Set(VarID, Patch('Voters list',Defaults('Voters list'),{Title:'Title TxtInput'.Text,Age:Value('Age TxtInput'.Text),Address:'Address TxtInput'.Text}))
Where,
- VarID-The name of the variable
- Voters list-The name of the data source
- Title, Age, and Address-The name of the Sharepoint column
- Title TxtInput, Age TxtInput, Address TxtInput-The name of the text inputs.
Next, select the label that is used to retrieve the item’s ID and insert the below expression into the label’s text property.
Text = VarID.ID
Where VarID is the name of the variable and ID is the name of the SharePoint default column name.
That’s it! Now, save, publish, and play the app. Let’s insert some random data on the respective text inputs.
When we click the button, we can see that a new item has been added to the Power Apps gallery, and the corresponding ID is displayed on the label.
This is how to get the gallery item’s ID using the patch function within the Power Apps gallery.
Read: Power Apps in SharePoint
Power Apps gallery patch all items
Here, we will see how to update bulk data within a gallery as well as in a data source using a patch. That means when the user clicks on the button, it will update all the items inside the data source or gallery.
Suppose, we have prepared a SharePoint list named ‘Voters List‘ having 3 single lines of text columns such as title, age, address, and a yes/no column named ‘IsEligbleForVoting‘.
We have prepared a gallery using the above SharePoint list below:
To update the address and ineligible fields for all, the following steps are:
- Let’s insert a button control to the app. So that users can update all the fields at a time with a button click.
- Next, insert a check box control to update the data as ‘Yes/No‘ in both the Power Apps gallery and the SharePoint list.
- Select the button control and insert the below expression in the OnSelect property.
OnSelect = ForAll('Voters Gallery'.AllItems,Patch('Voters list',{ID:ID,Address:'Address TxtInput'.Text,IsEligibleForVoting:If('IsEligible Chkbox'.Value= true , true , false )}))
Where,
- Voters Gallery: The name of the gallery
- Voters list: The name of the SharePoint list
- ID, Address, IsEligibleForVoting: The columns name of the SharePoint list
- Address TxtInput: The name of the text input
- IsEligible Chkbox: The name of the check box control.
Now we will save, publish, and play the app in preview mode. Let’s insert an address on the address input and checked the check box control. Then click on the button and we can see the modification is done for all items.
This is how to work with Power Apps gallery patch all items.
Also, check: Power Apps SharePoint Button
Power Apps reset gallery after patch
Here we will see how to reset a gallery once the patch function is done. So that the gallery will be reset once the item is modified or created in the gallery using the patch.
Suppose, we want to modify an existing item in the gallery. Once, it is done, it will reset the gallery.
We’ll implement this using the previous Power Apps gallery, which makes use of SharePoint’s Voters list. We will change the voter name from Alice to Alexa and the address from New York City to Mexico in that gallery, and the gallery will be reset with a button click.
So we will insert the below expression on the button’s OnSelect property.
OnSelect = Patch('Voters list',LookUp('Voters list', ID = 27),{Title:"Alexa",Address:"Mexico"});Reset('Voters Gallery');
Where,
- Voters list: The name of the SharePoint list
- ID: To modify the particular item we have used the ID from the SharePoint default column.
- Voters Gallery: The name of the gallery.
It’s done! Save, publish, and play the app for now. We can see when we click on the button, it will modify the specified item as well as reset the gallery like below:
This is how to reset a Power Apps gallery after the patch.
Read: Power Apps Navigate Function + 16 Examples
Power Apps gallery reset field after patch
In this section, we will see how to reset the fields after the patch on the Power Apps gallery. That means, we need to reset the input field(s) once after the patch function is done.
Let’s use the above gallery to meet this requirement. In that gallery, we’ve included three text inputs for the voter’s title, age, and address, as well as one checkbox control, to indicate whether the voter is eligible or not. Also, we have added a button control to the app.
Now, we’ll add the following expression to the button’s OnSelect property. As a result, with each click, a new item will be added to the gallery. When the item is created, the input fields are immediately reset.
OnSelect = Patch('Voters list',Defaults('Voters list'),{Title:'Title TxtInput'.Text,Age: Value('Age TxtInput'.Text),Address:'Address TxtInput'.Text,IsEligibleForVoting: If('IsEligible Chkbox'.Value = true, true, false)}); Reset('Title TxtInput'); Reset('Age TxtInput');Reset('Address TxtInput'); Reset('IsEligible Chkbox');
Save, publish, and play the app in preview mode or press F5. Let’s insert data within the fields to test the app.
Once we click on the button, we can see that a new item has been created in the gallery as well as the fields will reset within the Power Apps. This is how to reset the input field on the Power Apps gallery patch.
Check: Power Apps WeekNum and ISOWeekNum Function with Examples
Power Apps gallery patch selected item
Here, we will see how to patch the selected item within the Power Apps gallery. That means, that when the user selects any item on the gallery, the selected item will be modified.
We’ll use the above gallery, which made use of the SharePoint ‘Voters list.‘ When a user selects an item from the gallery, the ‘IsEligible‘ column value changes to False.
To accomplish this, we have included a Right icon within the gallery, which will be visible in each row of the gallery.
Select the icon and insert the below expression inside the icon’s OnSelect property.
OnSelect = Patch('Voters list', 'Voters Gallery'.Selected,{IsEligibleForVoting:false})
Save, publish, and run the app now. As we can see, clicking on any item’s icon causes the item’s value to change. If we select the second item’s icon (i.e., Johnson), the IsEligible value will be set to False like below:
This is how to update a selected item from the PowerApps gallery using Patch.
Power Apps patch gallery dropdown
In this section, we will see how to patch a Power Apps gallery using a dropdown value. We have prepared a Power Apps gallery using a SharePoint list named ‘Orders list‘ that contains 3 columns such as Title (Default), OrderDate (Date and Time), and Department(Choices).
On that app, we have inserted a text Input to insert the product name, a dropdown control to select the department, and a button to update the gallery.
On the dropdown, we have inserted the below expression to retrieve the choices from the SharePoint choice column. Select the dropdown and insert the below expression on the ‘Items‘ property.
Items = Choices('Orders List'.Department)
Select the button and insert the below patch expression in the OnSelect property to save the data on the gallery.
OnSelect = Patch('Orders List', Defaults('Orders List'),{Title:ProductTextInput.Text, Department:Department_Dropdown.Selected, OrderDate:Date(2022,8,25)})
Where,
- Orders List: The name of the SharePoint data source
- Title, Department, OrderDate: The name of the SharePoint column
- Department_Dropdown: The name of the dropdown control
Now, save and publish the app. Play it on preview mode. Let’s insert a product name within the text input and select an option from the dropdown. We can see, that when we click on the button, the item will be saved immediately on the gallery like below:
This is how to patch a gallery and dropdown Values on Power Apps.
Also check: PowerApps form benefits for SharePoint
Power Apps gallery patch date
InIn this section, we’ll look at how to add a date column to the Power Apps gallery. On the above gallery, we used a date column called “OrderDate,” and we manually patched the date field. However, if the user selects a date from the date picker, it will patch the selected date to the Power Apps gallery.
For this, we will insert a date picker into the app, so that users can select any date as per their choice. Click on the Insert > Inputs > Date Picker.
Similarly, select the button control and insert the below expression on the OnSelect property.
OnSelect = Patch('Orders List', Defaults('Orders List'),{Title:ProductTextInput.Text, Department:Department_Dropdown.Selected, OrderDate:OrderDatePicker.SelectedDate})
Where OrderDate is the name of the SharePoint date column, and OrderDatePicker is the name of the date picker.
Save, publish, and run the app. Insert the appropriate data into the input fields and choose a date from the date picker. Once the button is clicked, the data in the date field will be saved in the gallery.
This is how to patch a SharePoint date column in the Power Apps gallery.
Read: PowerApps tips and tricks
Power Apps patch collection to the gallery
Here, in this section, we’ll look at how to use a patch collection with the Power Apps gallery. That means we can add multiple items to the SharePoint list via patch collection and retrieve them to a Power Apps gallery.
First, we will create a collection on the Power Apps screen, and then patch that collection to the SharePoint list. To do this, the following steps are:
- First, we will prepare a SharePoint list so that the multiple data will store there from the collection. We have prepared a SharePoint list named ‘AcademicResults‘ having columns such as Title, LastName, Score, and Contact.
- On the Power Apps, we will use a collect function within an expression to create a collection that holds multiple records. On the Power Apps screen, insert the following expression on the OnVisible property.
OnVisible = ClearCollect(ColResults,{Title:"John",LastName:"Willium",Score:85,Contact:1234567890},{Title:"Ronnie",LastName:"Green",Score:76,Contact:0123456789},{Title:"Albert",LastName:"Johnson",Score:96,Contact:332127890})
Where,
- ColResults – The name of the collection
- Title, LastName, Score, Contact – The name of the collection columns. Here, we have created the collection’s column as similar to
- We can find the collection under the View on the Power Apps. Go to View > Collections.
Note- If you cannot find the collection, once it has been created, save and publish the app, then close and reopen it. You can get the collection this time.
- Next, move to the Power Apps screen. On that screen, add a button and insert the below patch function on the button’s OnSelect property. When the user clicks on the button, it will patch all of the collected data to the SharePoint list.
OnSelect = ForAll(ColResults,Patch(AcademicResults,Defaults(AcademicResults),{Title:Title, LastName: LastName, Score:Score,Contact:Contact}))
Here,
- ColResults – The name of the Collection
- AcademicResults – The name of the SharePoint list
- Title: Title – The first Title is the name of a SharePoint column, and the second is the name of a collection column. We did the same thing with the other columns.
- Let’s add a gallery to the screen, and set the SharePoint list i.e. AcademicResults on the items property of the gallery. So that when the user clicks on the button, the items will be created in the SharePoint list and it will display in the gallery.
- Now, save, publish, and play the app. Then Click on the button, and we can see all the items that have been created in the SharePoint list.
We can also see that the gallery now contains all of this information.
This is how to do patch collection in the Power Apps gallery.
Read Power Apps combo box filter
Power Apps gallery patch Number
Here, we will see how to patch a number to a Power Apps gallery. We are going to use the previous SharePoint list ‘AcademicResults.’ On that list, we want to update Ronnie Green’s score from 76 to 86. Here the score is a number type column.
Let’s create a gallery using the above list. To do this, we need to insert a button on the screen and insert the below expression on the ‘OnSelect’ property.
OnSelect = Patch(AcademicResults, LookUp(AcademicResults, ID = 18),{Score:86})
Where,
- AcademicResults: The name of the data source.
- ID =18: The ID of the specified Item.
- Score: The column that has to be changed.
Now save, publish, and play the app in preview mode. We can see it will update the score of the specified person.
Also, we can see this update on the SharePoint list. This is how to patch a number via the Power Apps gallery.
Check: PowerApps nested gallery control example
Power Apps gallery patch Person Field
In this section, we will see how to patch a person field on the Power Apps gallery. Suppose, we have a SharePoint task list including a person field named ‘Assigned to.
Now we’d like to change the Assigned To on the second item from Roselin to Sonam. To do this, teh following steps are:
- Build a Power Apps gallery using the above SharePoint list.
- Add a button control to the app. So that when the user clicks on the button, it will update the person’s field value. Select the button control and insert the following expression within the button’s OnSelect property.
OnSelect = Patch(
'Task list',
LookUp(
'Task list',
ID = 41
),
{
'Assigned To': {
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims: "i:0#.f|membership|[email protected]",
Department: "",
DisplayName: "Sonam subhadarsini",
Email: "[email protected]",
JobTitle: "",
Picture: ""
}
}
)
Where,
- Task list: The name of the SharePoint list.
- ID: The default column of the SharePoint list to identify the specified item.
- Assigned To: The name of SharePoint’s person field.
Now, save, publish, and play the app. We can see the person field’s value will be changed once the button is clicked like below:
This is how to patch a SharePoint person field from the Power Apps gallery.
Read: SharePoint PowerApps Example – Get bank branch details based on State
Power Apps patch gallery check box or powerapps patch gallery thisitem
This section will demonstrate how to patch a check box or use this item to patch a gallery in Power Apps. Instead of creating a new item, when the user checks the checkbox, it is updated in the SharePoint list.
Suppose we have a SharePoint list named “Employees” that has a Yes/No column, i.e., Active.
We have created a Power Apps gallery, using the above SharePoint list where we have added a check box control to update the Active field in the list from the Power Apps gallery.
Insert the following expression into the OnCheck property to update the data source when the user checks the checkbox.
OnCheck = Patch( Employees, ThisItem, {Active:true})
Let’s save, publish, and play the app. Suppose, we have checked 2 items on the gallery’s checkbox.
We can see, it will update in the SharePoint list as well.
This is how to patch the Power Apps gallery with a selected check box.
Also, you may like some more Power Apps tutorials:
- How to use Power Apps Gallery Dropdown
- Power Apps Dropdown Control with SharePoint
- Power Apps Drop down Control [With Various Examples]
- Power Apps Gallery Group By [With Real Examples]
- PowerApps Example – Create a Bank Account Statement
- Create Login Page in PowerApps using SharePoint List
- Power Apps Listbox items from SharePoint list
- How to use Power Apps Check Box Control
- How to get selected value from gallery in Power Apps?
Conclusion
This Power Apps Tutorial covered the use of the patch function within the Power Apps gallery. In addition, we have covered the following topics:
- What is the patch function in Power Apps?
- Discuss the different types of patch function syntax in Power Apps.
- How to work with SharePoint list using Power Apps gallery patch?
- How to update an existing item using the patch function within the Power Apps gallery?
- How to get the item’s ID using the patch function in the Power Apps gallery?
- How to patch all items in the Power Apps gallery?
- How to reset the Power Apps gallery after patching?
- How to reset the input field in the Power Apps gallery?
- How to patch the selected item in the powerapps gallery?
- How to patch a powerapps gallery with dropdown selections?
- How to patch a powerapps gallery with date inputs?
- How to patch collections to a powerapps gallery?
- How to patch the Number in a powerapps gallery?
- How to patch PowerApps Gallery with a person field?
- How to patch the powerapps gallery check box?
After working for more than 15 years in Microsoft technologies like SharePoint, Office 365, and Power Platform (Power Apps, Power Automate, and Power BI), I thought will share my SharePoint expertise knowledge with the world. Our audiences are from the United States, Canada, the United Kingdom, Australia, New Zealand, etc. For my expertise knowledge and SharePoint tutorials, Microsoft has been awarded a Microsoft SharePoint MVP (9 times). I have also worked in companies like HP, TCS, KPIT, etc.
All your tutorials are so detailed and easy to follow. Excellent work.