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

Рет қаралды 208,378

Күн бұрын

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:
• Power Apps Grid
Power Apps Gallery Filter
• PowerApps Multiple Fil...
Lear more about Modern Controls in PowerApps
• Get started with Moder...
#PowerApps #SharePoint #EditableGrid
Here's a link to download the Responsive Editable Grid:
github.com/rdorrani/PowerApps...
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: / rezadorrani
🐦 Reza Dorrani Twitter: / rezadorrani

Пікірлер: 1 100

@christianonphotography Жыл бұрын

If this channel is not worthy to follow in regards of power apps... I don t know which one else. Good job and thanks a lot. Your tutorials are so inspiring!

@RezaDorrani Жыл бұрын

Thank You so much! This will be the pinned comment on the video 😇

@amanchourasia1870 Жыл бұрын

@@RezaDorrani hello reza, i wanted to know what should we use if ur title colum is person or group type , then in formula.selected value or what we can use

@RezaDorrani Жыл бұрын

@@amanchourasia1870 Check my other videos on grid. I think I did cover person column.

@amanchourasia1870 Жыл бұрын

Why u used var reset and first making false then true? Also why u used filter on items can u please help me with this?

@RezaDorrani Жыл бұрын

@@amanchourasia1870 I did that so variable value changes and gallery filter gets reset.

@JasonDawe Ай бұрын

This was the best demo of an editable grid. Each time I have a new request or opportunity to create a tool for work, I like to treat it as an oportunity to learn a new technique. You never let me down.

@RezaDorrani Ай бұрын

Glad it was helpful! Thanks so much for watching

@gcooper642 9 ай бұрын

I don't know how I would have even begun to understand power apps without these videos. They are excellent.

@RezaDorrani 9 ай бұрын

You’re most welcome.

@vivekm75murali Жыл бұрын

Wow! Timing couldn’t be better. We are currently working on a project that needs an editable grid. Thanks a bunch, Reza. 😊

@RezaDorrani Жыл бұрын

Glad to hear that. Thanks so much for watching and liking the video.

@elonli7909 Жыл бұрын

From the tools you made to the current official experimental functions, I have always been a fan of this series, thank you for your introduction. This function has always been what I wanted most, and it has broken through the most tedious link from List to Powerapp.

@RezaDorrani Жыл бұрын

Glad to hear that! Thanks so much for watching and liking the content.

@ericzheng4838 Жыл бұрын

Thank you Reza as always, for not only bringing in newest knowledge, but also a most practical showcasing example! You are with no doubt the ultmost MVP for Microsoft in Power platforms.

@RezaDorrani Жыл бұрын

Thank You so much Eric

@thebreaksmusicshow6632 9 ай бұрын

Good day sir - I cannot thank you enough for all the help you have provided. Your tutorials get right to the point, provide amazing examples and have allowed me to go from never touching Power Apps to one month later, creating a comprehensive Governance process for over 200 application development teams to migrate to a new framework. Still more work to do (create editable tracking dashboards "ie. this video" - automated approvals...), but I am sure you will be there to help in one of your videos. Thank you again.

@RezaDorrani 9 ай бұрын

You are most welcome and I am so happy to hear the feedback! Thanks so much for watching and learning from the videos

@kneetotheface Жыл бұрын

Reza, ur the best! currently creating an entirely updated UI experience for a client that just migrated from sp2016 to spo. The chance to show such beautiful functionality with PowerApps/Automate in tandem with the SPO has me SUPER excited!!! Thanks for all you do, Reza!!

@RezaDorrani Жыл бұрын

Most most welcome! So happy to hear this.

@tylerbonts Жыл бұрын

I can't get over how great this is. This is exactly what I have been looking for!

@RezaDorrani Жыл бұрын

Thanks so much!

@lalasahebgaikwad1154 9 ай бұрын

This video is the most Valuable for New Power App Learner. Thanks for making this video.🎉🎉

@RezaDorrani 9 ай бұрын

Thanks so much and welcome

@jameshenryhinton Жыл бұрын

Reza, the power platform maestro with ummatched demo and teaching skills!! Always so relevant and useful. Thank you.

@RezaDorrani Жыл бұрын

Thank You for your kind words

@SoniaW316 5 ай бұрын

Very timely. I needed an editable repeating table! but this table is a secondary data source. I need to tie my two lists together now and I will be done. Thank you so much for this headstart.

@RezaDorrani 5 ай бұрын

Glad it was helpful! For related data sources (as an example SharePoint lists) -> check kzfaq.info/get/bejne/Z7ejmZWDtd_UaKc.html

@MichaelSchillo 17 күн бұрын

Reza, this tutorial alone has been useful on so many apps that I have created. As somebody that is new to "coding" I can't thank you enough for your tutorials, they have taught me so much that I can actually start to create my own apps employing techniques that I have not used before, without needing a video on how to do the whole thing first.

@RezaDorrani 17 күн бұрын

You're very welcome!

@DuncanCunningham Жыл бұрын

One of the best teachers of PowerApps. Thank Mr R!

@RezaDorrani Жыл бұрын

Thanks so much for your kind words

@husseinakberali6516 Жыл бұрын

This is the best PowerApps channel out there, Raza, you are a genius! Thanks again for imparting us with your wisdom, you are the best!

@RezaDorrani Жыл бұрын

Thank You Hussein 🙏

@DawnTesnow 10 ай бұрын

Reza to the rescue of the "Citizen Developers" and the pros once again! Thanks for all you do Reza, you make learning this so much fun!

@RezaDorrani 10 ай бұрын

You are most welcome

@jasonhammerle3582 Жыл бұрын

This is great content! Really really well done! I like all the details you added to the video like underlining areas on screen that you’re talking about for context. Really good video! Thanks! Looking forward to the next one!

@RezaDorrani Жыл бұрын

Awesome! Thanks for watching and liking the video

@rodolpho97 14 күн бұрын

Simply awesome!

@RezaDorrani 14 күн бұрын

Thanks

@hindireaction8585 Жыл бұрын

Brother I started learning power apps from your channel and as well power automate now I am placed in mnc so big thank you. You are the best in power platform thank you again

@RezaDorrani Жыл бұрын

Awesome! Congratulations on your placement. So happy to hear the videos are being appreciated and is making a difference to people. Wish you all the best.

@UncleBubba Жыл бұрын

Excellent video, Reza. Clearly and concisely explained, and there were so many great ideas in here that set little light bulbs going off in my head. Thanks

@RezaDorrani Жыл бұрын

Awesome! So glad to hear that. I somewhere deep down knew this video would be good 😊

@scottflack3013 9 ай бұрын

Reza, thanks so much for this tutorial! It was SUPER helpful as I just begin working with Power Apps. So well put together with great detail and instruction. Appreciate it!!

@RezaDorrani 9 ай бұрын

You're most welcome! Thanks for the appreciation.

@MegaKumar0 Жыл бұрын

Appreciation for your Great work Reza!!.

@RezaDorrani Жыл бұрын

Thanks Dilip

@genivaldobonfimmachado3969 Жыл бұрын

Just marvelous explain. Dorani is the best!!!! Thank you for your colaborstion.

@RezaDorrani Жыл бұрын

Dorrani says Thank You!

@Escillo Жыл бұрын

Thank you for this solution, I had limitations for gallery in children linked to parent to create and edit them cleanly. Now it will be much easier ;)

@RezaDorrani Жыл бұрын

Glad to hear that! Thanks for watching

@soaresmilton 9 ай бұрын

Amazing video, Dorrani! Thank you very much!

@RezaDorrani 9 ай бұрын

Glad you liked it!

@johanromero5429 2 ай бұрын

Reza always appears with great solutions ! KZfaq should have a reaction button with applause!

@RezaDorrani 2 ай бұрын

Thank You so much 👏

@sajanaedwin Жыл бұрын

You are one of the best teachers! I have learnt so much from your videos in a very short time. Thank you so much!!!

@RezaDorrani Жыл бұрын

Thank You Sajana

@gideon17you Жыл бұрын

Oh Reza! You are the best. Thank you for an excellent presentation, as usual.

@RezaDorrani Жыл бұрын

You are most welcome!

@aafaqmohammed 11 ай бұрын

Excellent video and great pace. So easy to follow and it doesn't take too long. Really great work! Excellent learning resource to enhance skills! Thank you for taking the time to create this video.

@RezaDorrani 11 ай бұрын

Glad you enjoyed it!

@dougydoe Жыл бұрын

Another Excellent video, Reza. Always stretching the boundaries as to what is possible and thanks for getting me inspired anytime I watch your videos. One thing I particularly liked was the pace. It was a bit slower than usual which was PERFECT. That way, it made understanding much easier. I know I'll definitely come back to this again soon. Thank you!!!

@RezaDorrani Жыл бұрын

Awesome 😎 So happy to hear that. This time I consciously dropped the pace a little. May be this is the right pace for future videos.

@dougydoe Жыл бұрын

@@RezaDorrani YESSSSSSSS!! Keeping this pace will be excellent 👌 👍 👏 😎

@RezaDorrani Жыл бұрын

@@dougydoe I will try my best

@binyacom 4 ай бұрын

Excellent instruction for someone new to Power App development. Thank you!

@RezaDorrani 4 ай бұрын

You're very welcome!

@zakw3637 Жыл бұрын

Lots of great content here, Reza you make the absolute best content around PA. Just fair warning there are many limitations with these controls since they're experimental atm. Dropdowns are limited to 25 items for example.

@RezaDorrani Жыл бұрын

Thanks so much. Absolutely, all modern controls are in preview. The same experience will work with classic controls.

@user-jw9sj8ku5d 5 ай бұрын

Reza, another incredible video. I have watched 3 of your editable grid videos, and this by far is the best one. Very easy and clean approach. I liked that the only thing that is getting patched to the collection are the updates.

@RezaDorrani 5 ай бұрын

This for sure is the best technique of the 3.

@sundararamanarikrishnan3672 Жыл бұрын

Amazing video, God Bless you

@RezaDorrani Жыл бұрын

Thank You 🙏

@CarlosTheMarlos Жыл бұрын

@Reza, amazing video as always. Thank you.

@RezaDorrani Жыл бұрын

Thanks Carl

@brianvickers8590 8 ай бұрын

Thank you so much! There was so much knowledge packed in to the last 10 minutes of this video that I felt like I was plugged in to the Matrix.

@RezaDorrani 8 ай бұрын

You are so welcome! Ya I did pack a lot in this one.

@Omran-yy6fh 11 ай бұрын

i don't usually comment in a youtube videos, but you are just great teacher , thanks a million for all the videos and for your efforts ,from Syria

@RezaDorrani 11 ай бұрын

Thank You so much!

@jasmingutierrez9280 8 ай бұрын

Another masterpiece! Thank you.

@RezaDorrani 8 ай бұрын

Most welcome

@UB-qc8yk Жыл бұрын

Excellent video, a Modern Control of the Combo box is desperately needed.

@RezaDorrani Жыл бұрын

I hope that control comes soon

@aescamilla Жыл бұрын

Great video Reza, thanks for showing the new preliminary modern controls; looks like there's still some work ahead for some of the, the drop down doesn't allow for searching and it's limited to 25 items, so it works as a preview but not for production apps yet. Anyway, the CRUD tutorial is priceless 😀 thanks again.

@RezaDorrani Жыл бұрын

Modern controls have a long way to go.

@JoshiJourneyLife Жыл бұрын

Thanks Reza!! Your tutorials make my job so much easier!! Keep up the good work!!

@RezaDorrani Жыл бұрын

Most welcome

@TheJenniferJacobsShow Жыл бұрын

Reza you are simply brilliant. Thank you so much for your excellent videos 😊

@RezaDorrani Жыл бұрын

Thanks Jennifer 😊

@abhishekgawde3812 11 ай бұрын

Top quality content as always! Thanks Reza.

@RezaDorrani 11 ай бұрын

Much appreciated!

@hermysstory8333 2 ай бұрын

Brilliant - Just what I was looking for!

@RezaDorrani 2 ай бұрын

Most welcome

@gilbertpradier Жыл бұрын

Amazing....great job, as usual you are making our life easier. Thank you so much.

@RezaDorrani Жыл бұрын

Most welcome! Thanks so much for watching

@zerokhan858 4 ай бұрын

thanks reza!!!!!b you are the best ever for power apps!!!

@xmateosx 10 ай бұрын

I love this. Thanks for speaking and creating the solution quickly. You English speaking is great. Keep going!

@RezaDorrani 10 ай бұрын

Thank you!

@davidrico8755 Жыл бұрын

Thanks Reza! Awesome video! Very easy to follow and understand as always.

@RezaDorrani Жыл бұрын

Thanks David

@VickneshWaran Жыл бұрын

Good one👍

@RezaDorrani Жыл бұрын

Thanks

@ElCz18 8 ай бұрын

Thanks for another great video, Reza! Exactly what I needed 🙂

@RezaDorrani 8 ай бұрын

Glad to hear it!

@techdrift73 Жыл бұрын

Awesome, will definitely use this

@RezaDorrani Жыл бұрын

Great! Thanks for watching

@vijaykrishnan4151 4 ай бұрын

Wow ...as a beginner this is intense. Lots of learning. Thank you very much :)

@RezaDorrani 4 ай бұрын

You're very welcome!

@kalpeshpatil2713 Жыл бұрын

Amazing!. Thanks Reza as always :)

@RezaDorrani Жыл бұрын

Most welcome

@shareqkhan7319 Ай бұрын

Masha Allah bahut achi video he bhai Allah apko Hamesha khush rakhe 🎉

@RezaDorrani Ай бұрын

Thanks

@tereliyeashu Жыл бұрын

Awesome.. so crisp and always new learning!

@RezaDorrani Жыл бұрын

Happy to hear that!

@MEPsideofBIM 8 ай бұрын

Amazing explanation and walk-through, as always! 💯

@RezaDorrani 8 ай бұрын

Thanks so much

@shaikhfirdos2723 Жыл бұрын

Thanks Reza for this video.

@RezaDorrani Жыл бұрын

Most welcome

@siddharthsingh7341 Жыл бұрын

I start watching your videos by liking it first as I find topics interesting and I know content must be informative since its from Reza!!

@RezaDorrani Жыл бұрын

Thanks Siddharth.

@AakashDhawanKash Жыл бұрын

Great job again Reza, I learn so much and you help me learn new ways to perform tasks. Thanks for the great video

@RezaDorrani Жыл бұрын

Most welcome

@devinreilly505 11 ай бұрын

@RezaDorrani, another great video. I like your videos because you build a functioning solution from scratch from which I can learn and replicate for my own use cases. I did have an issue that turned out to be something wrong with the modern dropdown when filtering. The rows would be correctly filtered but the dropdowns would be randomly blank. I switched them out for the classic dropdowns and it works great. Just not as nice of a look.

@RezaDorrani 11 ай бұрын

Thanks so much! Modern controls are in preview. Best to not use them in production scenarios until GA.

@georgechitechi Жыл бұрын

Thanks Reza. Well done

@RezaDorrani Жыл бұрын

Thanks George

@marcosvillalon3098 10 ай бұрын

Thank you very much Reza!

@RezaDorrani 10 ай бұрын

Most welcome!

@pauldigerolamo1084 2 ай бұрын

It cannot be understated how helpful this video is. Well done sir

@RezaDorrani 2 ай бұрын

Glad it was helpful!

@masuto74 4 ай бұрын

Thank you Raza, This is what I was really looking for. I have made a great app only by copying your steps. 😀ありがとうございます！

@RezaDorrani 4 ай бұрын

Glad to hear that!

@TinyHomeBuilders 9 ай бұрын

Great information. Thanks!

@RezaDorrani 9 ай бұрын

Glad it was helpful!

@2007pradipta Жыл бұрын

Clean and efficient approach of editable gird 😀

@RezaDorrani Жыл бұрын

Thank You

@smadasamy81 Жыл бұрын

Hey Reza, Nice Video !!! I am one of your great fans of your Power App videos. Thanks a lot

@RezaDorrani Жыл бұрын

Thank You so much for watching and following the videos. Thanks for supporting the channel.

@cardanha1 Жыл бұрын

Muito bom, ótimo Reza parabéns!

@RezaDorrani Жыл бұрын

Thank you

@juandavila4035 Жыл бұрын

Womderful video

@RezaDorrani Жыл бұрын

Thank You

@mmms85 8 ай бұрын

Very nice presentation. Thank you so much,!

@RezaDorrani 8 ай бұрын

You are most welcome!

@muhamadsarsour8172 Жыл бұрын

Thanks Reza .. great job👍

@RezaDorrani Жыл бұрын

Thank You

@oluwatobipaul6171 Жыл бұрын

Awesome one. Thank you Reza

@RezaDorrani Жыл бұрын

Most welcome

@MEPsideofBIM 8 ай бұрын

Gotta buy a coffee for the MVP here. Thank you!

@RezaDorrani 8 ай бұрын

Thank You

@anantchirmade600 Жыл бұрын

Great work!!

@RezaDorrani Жыл бұрын

Thank You

@MsRodrovisk Жыл бұрын

Great video. I hope to be able to change the colors of modern controllers in the future

@RezaDorrani Жыл бұрын

Color change is coming in future

@sebmir28 Жыл бұрын

Thanks for this update 😊

@RezaDorrani Жыл бұрын

Most welcome

@vishh8237 Жыл бұрын

Your videos helped me to get my job done❤

@RezaDorrani Жыл бұрын

Glad to hear that! Thanks so much for watching

@mce8183 Жыл бұрын

Hello Reza you are the best!!!!

@RezaDorrani Жыл бұрын

Thanks so much 😊

@SHAli1474 Жыл бұрын

Very good explanation. Thanks Reza

@RezaDorrani Жыл бұрын

Most welcome

@sharadadevi9862 Жыл бұрын

Wow !!! You are a saviour Reza😊

@RezaDorrani Жыл бұрын

Thanks Sharada

@BenWalker-oz7iz 4 ай бұрын

Thanks so much - perfect explanation of how to achieve this!

@RezaDorrani 4 ай бұрын

Most welcome

@krisperkreme6021 Жыл бұрын

Such great content. Thanks a bunch!

@RezaDorrani Жыл бұрын

Most welcome

@markmclean154 Жыл бұрын

Thanks Reza, great new techiniques

@RezaDorrani Жыл бұрын

Most welcome! Thanks for watching Mark

@rachitsinha5285 Жыл бұрын

Wow, that's amazing Reza, super informative, and surely will help in couple of projects I am working on..

@RezaDorrani Жыл бұрын

Awesome! Glad to hear that.

@angel4199yt 4 ай бұрын

Excelent!!

@RezaDorrani 4 ай бұрын

Thanks

@musamayomi Жыл бұрын

This is awesome from Reza!

@RezaDorrani Жыл бұрын

Thanks Musa

7 ай бұрын

You are the Best

@RezaDorrani 7 ай бұрын

Thank You!

@DeepakKumar-qh7zq Жыл бұрын

Excellent demonstration Reza.. you are the best ❤

@RezaDorrani Жыл бұрын

Thanks Deepak

@paolovr1970 Жыл бұрын

Thanks Reza 🙏🙏🙏

@RezaDorrani Жыл бұрын

Welcome 🙏

@JohnyBuendia Жыл бұрын

muchas Gracias señor Reza

@RezaDorrani Жыл бұрын

Welcome

@MrRpryde 11 ай бұрын

Great content Reza. Just subscribed and is already my number one reference.

@RezaDorrani 11 ай бұрын

Awesome! Thanks for the sub.

@vigneshm7011 Жыл бұрын

Nice 👏

@RezaDorrani Жыл бұрын

👍

@garimatewari2212 9 ай бұрын

Your videos are amazing 🎉👏

@RezaDorrani 9 ай бұрын

Glad you like them!

@Fonzyrr Жыл бұрын

Bro thank you so much

@RezaDorrani Жыл бұрын

Most welcome

@tps1990 8 ай бұрын

Perfect!

@RezaDorrani 8 ай бұрын

Thanks

@lonsdejlit Жыл бұрын

Thank you Reza for the comprehensive solution. Just one question. Does the dropdown from modern controls allow for multiple selection?

@RezaDorrani Жыл бұрын

Thanks Dawid. Modern dropdowns currently do not support multiple selection.

@JWEERASINGHE 7 ай бұрын

Mr. Reza, thanks so much for this tutorial! It was super helpful as I just begin working with Power Apps. So well put together with detail and instruction. Appreciate it!! - (please let me know how I connect control includes numbers?) when update changes in the form.

@RezaDorrani 7 ай бұрын

You're very welcome! I did not understand your question on controlling numbers.

@ndk1978 7 ай бұрын

Thanks very much

@RezaDorrani 7 ай бұрын

You are most welcome

@pablocc8905 Жыл бұрын

Well explained. You saved my day 😊

@RezaDorrani Жыл бұрын

Thanks for watching Pablo

@josephbrianladesma3423 8 ай бұрын

Super helpful tutorial! i am currently using this as a base for my project, on a side note can i ask how can i do the last type of filtering you did on the video where in adding new rows are is okay when filtering a specific column? Thank you and thanks a lot!

@RezaDorrani 8 ай бұрын

When specific filter is select, when user adds row, simply add the filter value to the default formula logic of adding new item.