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 Editable Grid experience with SharePoint List as a data source. 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, perform CRUD operations, copy item, filter grid or gallery, horizontal scroll + vertical scroll, responsive grid design, freeze pane effect, grid validations & more keeping performance in mind.
All updates in grid will be Patched to the data source with a single Patch function.

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
✅ Grid validations
✅ Put grid in view mode or edit mode
✅ Filter Grid / Gallery data
✅ Horizontal Scroll
✅ Freeze Pane
✅ Undo grid updates

Power Apps: Horizontal scroll in a vertical gallery with “freeze panes” effect
https://michalsacewicz.com/power-apps...

PowerApps Gallery Multiple filters
   • PowerApps Multiple Filters on Gallery  

Power Apps Delegation
   • Power Apps Delegation - Working with ...  

Power Apps Data Validations
   • Power Apps form data validation tutorial  


#PowerApps #SharePoint #EditableGrid

Here's a link to download the Responsive Editable Grid:
https://github.com/rdorrani/PowerApps...

Table of Contents:
00:00 - Intro
00:33 - Create SharePoint List
01:30 - Create a Power App & enable Responsive Design
02:31 - Build Editable Grid / Gallery Headers
05:23 - Build Editable Table / Grid using Gallery control
16:18 - Patch Collection / Grid Updates to SharePoint List
20:00 - Add New Item / Record to Grid
26:10 - Add data validations to Grid
29:35 - Undo Grid changes
30:37 - Horizontal Scroll & Freeze Pane Effect
33:21 - Delete Item / Record in Grid
36:13 - Copy Item/Record in Grid
38:04 - Filter Gallery / Grid data
42:39 - Subscribe to Reza Dorrani Channel