Power Apps Editable Grid using Gallery & Modern Controls (2023)

In this step-by-step tutorial video, we will learn how to build an Editable Grid like experience in Power Apps using Gallery & new Modern Controls. This is an excel like Grid experience similar to Quick Edit Mode in SharePoint Lists or Grid view in Dataverse or InfoPath Repeating Tables.

We will use Power Apps Galleries to create the editable grid, perform CRUD operations, Undo changes, Save Grid Updates to data source with a single Patch function thereby improving performance, filter grid or gallery with full delegation support, Sort grid data and a lot more.
We will leverage SharePoint as a data source but the same experience can be applied to Excel, Dataverse, SQL etc.

Modern controls in Canvas Power Apps are a new set of controls that are based on Microsoft's own Fluent design system. Modern controls are quicker and simpler for makers to configure. Modern controls are designed with a focus on accessibility, usability, and performance (fast) that makes them visually appealing, highly functional, and intuitive to use.

Power Apps Editable Grid / Table playlist:
https://www.youtube.com/playlist?list=PLTyFh-qDKAiHeIy4xwTFpz_03poNzPuQU

Power Apps Gallery Filter
https://www.youtube.com/watch?v=5dSk5iOgT68

Lear more about Modern Controls in PowerApps
https://youtu.be/eNhCQ7Y2x7o

#PowerApps #SharePoint #EditableGrid

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

Table of Contents:
00:00 - Introduction to Editable Grid in Power Apps
00:45 - How to create Editable Grid using Gallery and Modern Controls in PowerApps
01:45 - Grid based on new Power Apps modern controls
02:15 - Start building Power Apps Editable Table / Grid
04:19 - Load default values of modern controls in Gallery / Grid from SharePoint list
07:36 - Save Power Apps Editable Grid updates to SharePoint using Patch function
15:55 - Grid column headers
16:41 - Undo Grid Changes
17:52 - Add new row to Power Apps Grid / Gallery
19:15 - Sort Power Apps Gallery as Editable Grid
20:35 - Delete row from Power Apps Gallery as Grid
21:29 - Filter Power Apps Gallery as Editable Grid
23:14 - Power Apps Editable Grid Example
23:41 - Subscribe to Reza Dorrani Channel

🤝 Let’s connect on social:
🔗 Reza Dorrani LinkedIn: https://www.linkedin.com/in/rezadorrani/
🐦 Reza Dorrani Twitter: https://twitter.com/rezadorrani

Видео Power Apps Editable Grid using Gallery & Modern Controls (2023) канала Reza Dorrani