top of page
Search

Use the Power Apps Patch Function with a SharePoint List

Updated: Jul 21, 2024

Learn how to customize a gallery and use the Patch function directly within a gallery in Power Apps. Shane’s 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:

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.

bottom of page