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
Reza Dorrani, MVP
I watched your video and built every thing I needed but I'm at the very end and can't get my filters to apply to my gallery view. Please help I need to wrap this project up today.
@Anonymous can you please paste a capture of your gallery's Items property formula?
Thank you so much for showing how to build this Editable Grid in Power Apps.
I have followed the video and have a query when I add a new item, I start filling in the fields (Can't seem to get the tab key to work), when I get to the Date & Time of arrival a new line appears, as per the screen shot, it copies my data but adds a new line.
Would you able to point me in the direction to prevent this from happening?
Thank you in advance
I have developed same editable grid but tab keys are not supported in it. I mean when user press tab inside gallery, the header of gallery remains static
Did you find a fix for the tab issues?