Power Apps Editable Table/Gallery like Excel (Tutorial)

#PowerApps #EditableTable #EditableGrid #InlineEditing #EditableGallery

In this video on Power Apps Editable Excel like Gallery or Table (Tutorial), we will go through a step-by-step tutorial of creating an Excel like Editable table/grid. This is like the Quick Edit Mode in SharePoint lists/libraries or the Grid view in Dataverse for Teams or InfoPath repeating tables.

We will use Power Apps Galleries to create the editable grid and live update our data source.

Video covers the following:
✅ Style gallery to look like an editable grid
✅ Add a new row or record to the grid
✅ Record grid updates in a collection and patch all the changes with a single query (performance boost)
✅ Delete a row or record in the grid
✅ Put grid in view mode or edit mode
✅ Undo grid updates
✅ Auto-save grid updates using timer control

Here's a link to download the sample solution:
https://github.com/rdorrani/PowerApps...
Solution includes Dataverse Tables, Choices column and the Power App.
**Please note: You need to import the zip file as a solution.**

Table of Contents:
00:00 - Intro
00:42- What is an editable grid/table
01:32 - Data source information
02:55 - Building and styling the Editable Table
04:22 - Add New Row to the Table
08:50 - Delete Row from the Table
09:36 - Update Rows & bulk Patch data from the Table
23:48 - Auto Save Grid/Table data
25:30 - Change Mode of Grid View
27:34 - Undo changes in Grid/Table