09-22-2021 08:34 AM
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.
FULL SETUP STEPS:- PowerApps/EditableGrid at master · rdorrani/PowerApps (github.com)
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
PowerApps Gallery Multiple filters
Power Apps Delegation
Power Apps Data Validations
#PowerApps #SharePoint #EditableGrid