Updated: May 21
In part 1 of Shane’s video series on repeating tables, you will learn how to build an expense report using SharePoint lists as the data source. This demo lays the groundwork for using cascading menus to display results and adding custom functionality in later videos.
In this video you will learn about:
Power Apps Forms
The NewForm function
The Collect and ClearCollect functions
The ForAll function
Link to the video on YouTube: Power Apps Repeating Tables like InfoPath Part 1 - Enter the data
2:19 Demo of the solution
Shane demonstrates the functionality of his expense report app. The user is able to enter and save expenses by navigating the app with the tab and space bar keys, rather than having to click on each line item. Total expense is automatically calculated.
8:23 Create the solution in Power Apps and insert a form
A new app is created in Power Apps and a form is added to display the expense report from SharePoint.
11:32 Put the form in new form mode using the NewForm function and create a new collection using the ClearCollect function
The NewForm function is added to the ‘create new expense’ button so that the form is able to be edited. The ClearCollect function is added to the button after the NewForm function in order to create a new collection for every new expense.
13:39 Insert a gallery and use the Patch and Collect functions
A gallery is added to display the expense collection. The gallery can be edited and saved through the use of text inputs and icons. The save icon utilizes the Patch, Value, and Collect functions to update the expense collection.
19:33 Add a save button to submit the form to SharePoint using the Patch function
The SubmitForm function is added to the ‘save’ button. The ForAll function is added to the OnSuccess for the form.
24:01 Save to SharePoint and demo of the final solution
The app is previewed and expenses are saved to SharePoint.
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.