top of page

Save Data in Power Apps with Patch, Collect, and ForAll functions

Updated: May 21, 2021

Do you need to build forms and collect data from your users? Learn the best ways to save data back to the data source when building and working with controls in your apps by using the Patch, Collect, and ForAll functions.

In this video you will learn about:

  • The Patch function

  • The Collect function

  • The DropColumns function

  • The ForAll function

Key timestamps:

  • 0:00 Intro

  • 1:45 Demo of the solution

    • Shane demonstrates the functionality of his ‘Spooky Halloween Candy Tracker’ app. The data that is recorded for each house is sent straight to SharePoint. The app allows users to record data for both individual houses and groups of houses.

  • 7:22 Walkthrough of the cat scratch image and sound effect

    • The cat scratch image and corresponding sound effect are triggered when the user presses the ‘Enter if you dare!!!’ button. The UpdateContext, Clear and Navigate functions are utilized along with an audio control.

  • 9:01 Brief overview of the Text input, Drop down, Slider and Rating controls

    • The second Drop down control utilizes the If function and a Cascading Drop Down in order to display different options depending on what was chosen in the first Drop down control.

  • 10:09 Walkthrough of the Patch function

    • The ‘Record House’ button utilizes the Patch and Defaults functions to send the data to SharePoint.

  • 14:41 Walkthrough of the Collect function

    • The ‘Record House’ button on the Collection Style screen utilizes the Collect function to send multiple sets of data to SharePoint. The DropColumns function is utilized to drop the Bonus column because it has bad data.

  • 21:20 Walkthrough of the ForAll function

    • The ‘Save - Hard Way’ button on the View Collection screen utilizes the ForAll, Patch, and Defaults functions.

Additional learning:



bottom of page