Save collection to SharePoint list PowerApps

Learn how to customize a gallery and use the Patch function directly within a gallery in Power Apps. Shanes demo shows how to build a gallery that displays employee names, titles, and favorite colors along with cancel, edit, and save buttons.

In this video you will learn about:

• The Patch function

• The UpdateContext function

• The Reset function

Link to the video on YouTube: Power Apps Patch Function

Link to the video for Curated Library subscribers: Power Apps Patch function

Key timestamps:

• 0:00 Intro

• 1:02 Demo of the solution

• Shane demonstrates the functionality of his employees SharePoint list in a customized gallery. The favorite color and title fields are able to be edited and saved.

• 3:03 Create the solution in Power Apps and insert a gallery

• A vertical gallery is inserted into the app and the Employees SharePoint list is selected as the data source. The title field is customized to include first and last name. A label is added that displays favorite color and a drop down control is inserted. An additional label is added that displays title and a text input is inserted.

• 7:56 Add a save button and use the Patch function

• A button is added that allows users to save their changes in the gallery. The Patch function is utilized to update a single record.

• 11:08 Add an edit/cancel button and use the UpdateContext function

• A button is added that users must click in order to be able to edit the gallery. The UpdateContext function is added to the edit button to create a toggle effect. The If function is added to the edit button to allow users to cancel their changes in the gallery.

• 16:52 Add the UpdateContext function to the save button

• Upon clicking the save button, the screen reloads and everything resets.

• 17:52 Add the Reset function to the edit/cancel button

• Upon clicking the cancel button, changes that the user has made that have not been saved are discarded.

• 19:43 Demo of how to patch a new record

• Shane demonstrates the functionality of a button that utilizes the Patch and Default functions to patch a new record.

• 23:15 Demo of how to write a single record

• Shane demonstrates the functionality of an additional button that utilizes the Collect function to write a single record.

Additional learning:

• Video: Power Apps Save Data - Patch, Collect and ForAll

• Video: Power Apps SharePoint Complex Columns - Patch person, choice and lookup fields

Do you want to become a Power Apps Rockstar? Check out our different full length training classes at https://training.PowerApps911.com or you can download a working version of the app we built today by subscribing to the Curated Library.