12-08-2020 08:40 AM - last edited 12-08-2020 09:38 AM
In this video, 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/blob/master/EditableGrid_1_0_0_2.zip
Solution includes Dataverse Tables, Choices column and the Power App.
***Please note: You need to import the zip file as a solution.***
#PowerApps #EditableTables #EditbaleGrid #InlineEditing
--------------------------------------------------------------------------------
Thanks,
Reza Dorrani, MVP
YouTube
Twitter