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

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

Link to the video on YouTube: Power Apps Save Data - Patch, Collect, and ForAll Link to the video for Curated Library subscribers: Power Apps Save Data - Patch, Collect, and ForAll

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:

• Video: Power Apps AddColumns ShowColumns

• Video: Power Apps Patch Function

• Video: Working with a Power Apps Collection

• 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.