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
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
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.
Video: Power Apps Patch Function
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.