Group By in Power Apps Gallery with Large SharePoint Lists

[@Fruition10]

Reza, you’re my hero! I’m pretty new to Power Apps. This video solved numerous, complex pieces of the puzzle for me that I’ve been seriously struggling with. With the knowledge I’ve gained from you this morning, I’m feeling confident today is the day I will finally publish my first “real” app. You’re a rock star, Reza! Thank you! Thank you! Thank you! 🙏

[@RezaDorrani]

You are most welcome Janet. So glad to hear that the video is useful. Best of luck with your App.

[@debarunbanerjee616]

I am a big fan of yours.. You learnt me a lot in last few months. Since I come across your first video, i am a regular visitor and you never disappointed me. So much in depth analysis and explanation. I am sure anyone who will watch your video will become a fan of you. You learnt me a lot in responsive PowerApps design where it was the most frequent consideration for any client. 🤗🥳💐. Take a huge thanks from my side and also from all of them who appreciated my work i applied seeing your videos. 🙏🏻

[@RezaDorrani]

Thank You so much for your kind words. Appreciate all the love and support 🙏

[@TheAsterii]

This is really awesome, thanks for sharing! Liked how you first showed the limitation of Group by regarding delegation and then presented the optimized approach. That´s a real learning curve right there ^^

[@RezaDorrani]

You're very welcome!

[@jray1429]

Reza, I keep watching this and keep getting more out of it. Thank you!

[@RezaDorrani]

Wow! Makes me so happy to hear that the video is being appreciated.

[@Bekesam]

Well done Reza!! Many thanks for this. It confirmed for me to stick with using Filter() for most scenarios and limit GroupBy(), for specific cases requiring it.

[@RezaDorrani]

Thanks. Your point is spot on.

[@nikolemeyer2506]

Brilliant, just what I needed. Thank you, Reza!

[@RezaDorrani]

You're most welcome!

[@sosinamezemir2612]

You’re a rock star, Reza! Thank you

[@RezaDorrani]

Thanks Sosina.

[@karolinaunderwood1039]

This is soooo awesome! Thank you so much.. I was scratching my head for months about how to deal with large data set.... I really appreciate this video

[@RezaDorrani]

You're very welcome!

[@Me-of9vf]

Reza, my man, you're the father of all powerapps makers.

[@RezaDorrani]

Wow! Thanks 😊

[@zulkamalober181]

thanks reza. really helps a lot in managing a lot of data filtering in galleries. i'll implement this in my current powerapps project 😆

[@RezaDorrani]

Awesome!

[@oricchannel2811]

Another great video. I learned a lot. Won my LIKE. Thanks for sharing.

[@RezaDorrani]

Awesome, thank you!

[@oluwatobiyusuf]

Thank you Reza. I have a better understanding of how to solve delegation issue now

[@RezaDorrani]

Awesome! Thanks for watching.

[@pranavkahol5925]

Thank You Reza for this video!!! This video gave me the answers to most of my queries.

[@RezaDorrani]

Glad to hear that! Thanks for watching Pranav

[@uiterlex]

Thanks Reza, structured set up and explained simple and accessable for common PA developers. I hope MS will extend the delegation operators in the near future, as the SQL machine is running SharePoint. I miss the 'in' delegation a lot. (came from SQL because of license cost + SharePoint is doing well now). Gr. Lex

[@RezaDorrani]

Glad it was helpful! I hope the delegation options become more flexible.

[@CarlosSolisNow]

You scored again! This help me build the last piece for my gamification app for my PowerApps students at the University. Keep up the great work.

[@RezaDorrani]

Awesome! Thanks for watching and liking the video.

[@Kimmy-xz3is]

You’re my Power Apps hero!

[@RezaDorrani]

Thank You 😊

[@vanshen957]

You are a genius man. Love your videos!

[@RezaDorrani]

Glad you like them!

[@spen2431]

Cant find the Superman emoticon... Amazing work Reza. Thanks 💥💥

[@RezaDorrani]

Thank You 🦸

[@hugocychan]

Thank you Reza. It's a great video to tackle my cases.

[@RezaDorrani]

Glad it was helpful!

[@SHAli1474]

Another great video Reza, Thanks

[@RezaDorrani]

Thanks Ali

[@luca75tubo]

Great explanation!! Thank you!

[@RezaDorrani]

You're most welcome!

[@FarhanKhan-lr4tv]

You listen your viewer's mind thanks ❤️👍

[@RezaDorrani]

Viewers run this channel so I better listen to them :)

[@paulburns2814]

Only one thing to say 'Brilliant'

[@RezaDorrani]

Thanks Paul

[@Deadpool12353]

amazing reza, wonderful idea.

[@RezaDorrani]

Thank you very much

[@bhavanaachari9445]

Hi Reza, that is amazing! Gallery inside gallery blew my mind

[@bhavanaachari9445]

I have a doubt… I have power app which is integrated in powerbi. I have used groupby function and it works perfectly in the power apps. But in power Bi, I can’t see the app it shows blank and has an error that says “the first argument to the groupby function cannot be blank”. How can I overcome this error

[@RezaDorrani]

Thanks

[@RezaDorrani]

I have not come across the mentioned issue and hence not sure what the reason for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

[@shashikanthduddukuri6228]

Thanks Reza for the great video.

[@RezaDorrani]

Glad you enjoyed it

[@pawanmishra6549]

Thanks Reza👏, very useful & important concepts covered👍

[@RezaDorrani]

Glad it was helpful!

[@pawanmishra6549]

@@RezaDorrani Hi Reza, I was searching for your video where you used 'Timer control' and showed very useful tip, can you kindly help me with the link of that video?

[@RezaDorrani]

@@pawanmishra6549 Timer control for?

[@clay4gli]

Outstanding video - best part was when you showed how to delegate some of the heavy lifting to Sharepoint.

[@RezaDorrani]

Glad to hear that! Thanks for watching Clay

[@chanchaijongpreechaharn2052]

Your skills are excellent and easy to understand and apply. Thank you (Y)

[@RezaDorrani]

Thank you for your kind words!

[@saifkazi8504]

Great video 🔥

[@RezaDorrani]

Thanks 🔥

[@BensonRwara]

Great idea.... great video

[@RezaDorrani]

Thank you! Cheers!

[@jeffk8900]

Thanks!

[@RezaDorrani]

Welcome

[@rosianecarvalho7328]

Thankssssss!!

[@RezaDorrani]

Welcome

[@sanwoolutolu4123]

Awesome Thanks Reza

[@RezaDorrani]

👍

[@enitesh]

Wow. Wonderful. Today morning I was thinking if there’s a way to achieve this kind of functionality and this got dropped to my inbox (I have a power automate flow which sends me link of all new videos on your channel every Tuesday ).

[@RezaDorrani]

Glad it was helpful and thanks for setting up the flow :)

[@ArsalanKhan-gq5np]

Thanks a lot Reza for such a nice tutorials. It is request to you, if you dont mind, would create the Tutorial for Swipe Gesture like deleting and drag and drop ? Much appreciated.

[@RezaDorrani]

I will add your video request to my backlog but will need a lot more folks requesting this topic to give it a higher priority. Meanwhile, I will recommend checking the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@syedazhar4839]

Best Video...

[@RezaDorrani]

Thanks Syed

[@365cloudhouse7]

Thanks

[@RezaDorrani]

Thank You

[@reganli696]

Hi Reza, I've been learning so much following your video tutorials. I wonder if you can start by sharing the data files you used in these videos? So we can follow along more easily? It's kind of difficult to keep creating lists without knowing the table schema and a set of make-up data.

[@RezaDorrani]

The data files cannot be directly shared as it is a sharepoint list. There are site scripts and site designs in SharePoint which allow exporting of list schema but would require users to have powershell knowledge to import. In most of my videos I try to leverage standard list templates so users can reproduce.

[@goodguywins]

Thanks for another excellent and timely video. I have a question about the filtering you did with large datasets - would indexing the SharePoint list fields you wanted to filter on be beneficial? I'm looking at a list of maybe 50k records and 4-5 fields that might be filtered on. Thanks again.

[@RezaDorrani]

I would highly recommend indexing. Check kzbin.info/www/bejne/d5zciGuZjKmJpcU

[@paolovr1970]

thanks

[@RezaDorrani]

Welcome

[@mohitoshbiswas4797]

Thanks Reza!! Wonderful video on the grouping concept with delegation. Your videos are much more in detailed for the benefit of clarity. I would like to ask a query on this. Can we pass this filtered list of records to another power apps gallery on another screen which is setup in Grid view edit? This will give the app a summary page first as Home page then move to next screen for modifications.

[@RezaDorrani]

Probably possible but not something I have tried.

[@sueamin2788]

Thank you Reza! Very well presented and very useful. Thank you for all that you do for us. A Q.: Can I group by "Created By"? If so, how?

[@RezaDorrani]

Wont work if data set is large. You could use distinct function to get it.

[@sueamin2788]

@@RezaDorrani It worked with Filter.! Thank you!

[@Mattula112]

Hi Reza This video and many of your others are perfect. I have watched them over and over again. One thing in this one, how did you create that card like experience?

[@RezaDorrani]

Thanks Matthew. Card like designs - kzbin.info/www/bejne/mJ-maahpnMmKqdU

[@triderw7309]

this is amazing! helped me out a lot. thank you Reza! you're an inspiration. I have a question , with this method all the titles on the button shows regardless of weather there are items to display in the galley.is there a way to completely hide the region button if there is nothing to display inside it?

[@RezaDorrani]

I have not tried this but my guess is You can check count of items in gallery. If 0 then hide.

[@samitbhattacharya2201]

Reza ! I am using MS-SQL as a database. Just to clear my understanding, is delegation issue applicable in my case. Thanks to the master ☺️ again.

[@RezaDorrani]

Yes. Check SQL delegation - docs.microsoft.com/en-us/connectors/sql/#power-apps-delegable-functions-and-operations-for-sql-server

[@AmyCustomer]

I found this video yesterday and was able to use many of the concepts to do the same with a nested gallery. I learned so much. Thank you!!! You are an awesome teacher. I have one thing I can't figure out, I want my app to open with all of the nested galleries collapsed. I wouldn't mind the first button to have the shading like it's selected, but I want all nested collapsed upon entry so the user just sees the 4 buttons and has to click one to see the nested gallery. Can you help? Cheers, Sir and thanks in advance.

[@RezaDorrani]

Thanks Amy. Its been a while since I did this video. I would have to try it out to know the possibilities. I would recommend posting your query on forums at powerusers.microsoft.com

[@jbo1253]

Another Great Video, Thank you very much! around @14:16 you did a choice formula and used "region" a (lookup column). Is it possible to do this with a people column? also, can the column used to group be dynamic? For example like instead of filter drop down could you have a group by dropdown? Thanks again

[@RezaDorrani]

Choice does not work with people column. People column allows any user from organization to be entered. You will need to give the unique values of person column info. The function to use there is Distinct, but it will not be delegable. No way around it.

[@manoplaeli4027]

Thank Reza. This is exactly what I am looking for. I am strugle a little bit on hiding the heading with 0 Item. Any suggestion?

[@RezaDorrani]

I will have to look at your App in action to provide guidance. I will recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com/

[@asmi3007]

Reza, hi, thanks for all the videos and they help me in creating the Application ..This is the first time I am making application and most of your videos helped me to accomplish my task. I cannot share the snapshot of the pages i am creating as to seek guidance on them, instead i am sharing details where I want to seek your help. (pls note inthis we have a Admin & user) 1) Scenario you have a main list wherein you have list of computers with details and in second list you maintain who all employees have requested and returned those computers within deadline or have crossed deadlines, the reminder should pop in to the admin. Also, in this there is one column 'Status ' which is common in both list, if any changes made in 2nd list by admin it should be updated in the second list & make changes in main list also ( I have used the look up function in second list, which takes data from 1st list). 2) I have a gallary and when i want to make changes in form.. how it can pick up all field which is being selected automatically without using dropdown in case of choice column (say i have Computer Sl. No. which is a choice column), name of Computer etc. 3) If I have a table and i want to select a particular row and want to make changes in forms can we do that , if so how and how it will get updated to the main table. 4) Any new computers added by admin how can we show them as 'new' till the user see them ( in this case I have multiple employees who would be accessing the app... so everytime any person log in they should see a new addition and this should stay for a week./month 5) how to create a dashboard scenario on main page which shows how many people requested for computers, returned computers, and which computer was in more demand (if it is in case of books). Thanks..

[@asmi3007]

Please note all my data is from Sharepoint list

[@asmi3007]

I have accessed your video kzbin.info/www/bejne/jn7SoX9mp52eac0 and my requirement is similar to this video, since I have basic access to Powerapps I cannot access table and my data is on sharepoint

[@RezaDorrani]

Thanks for liking my videos. A lot of questions here - sounds more like consulting help :) is needed for your project). I will have to look at your App & scenario in action to learn more about it and provide guidance. For each of your questions I probably have 2-3 follow up questions so I can get more clarity. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@asmi3007]

@@RezaDorrani Na na.. not consulting but asking you to create app based on this scenario.. will help me too ;). will check and post at the powerapps forum

[@RezaDorrani]

@@asmi3007 It will not be possible since this is very scenario specific. This sounds more like a project. I make videos when I receive many requests on a particular topic. This is the first one on this topic since it is scenario specific.

[@saln.4112]

Hello Reza. I have a question about your delegation workaround: what if instead of a choice column I want to group my dat by a text column? Function Choices won't work :-( Thanks for any pointers you can give me. Your solutions are fantastic! I have been learning mostly through KZbin videos and yours show clean, elegant solutions that overcome limitations that most ppl crash against (i.e. infamous delegation). Sal

[@RezaDorrani]

Thank You for the feedback about the channel. So glad to hear the content is being appreciated. Problem with a text column is that you cannot guarantee a defined list of choices. Its a free text. Ideally you would want a defined list of choices to group on. A choice column is perfect candidate for it.

[@sanjaysy]

Hi, I learned a lot watching your videos. And built a timesheet app. Now I'm looking for a nested gallery. where trying to use 2 lists linked by lookup value. Do you have a video for this as well?

[@RezaDorrani]

Great! I do not have a video reference on this scenario. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

[@khanlee82]

Thank you for the video! I have a basic question I think, but I haven’t been able to figure it out :/ If I have items in my choice column that do not have current records, how can I only display the choices from my choice column that have records associated with it? For example, if my choice column is Filled with states, but I only have a few states with records associated, how can I only pull in those records that are associated with a state?

[@RezaDorrani]

Looks like you need gallery filtering. I have done several videos on those. Check Power Apps playlist on my channel.

[@madelinemoisio7418]

Hi Reza, thank you for this helpful video! Is there a way to insert a button that will reset the selections of the gallery? Using your example - I'm wondering if you can have a button that will collapse the North, South, East, and West nested galleries. I've been running into errors around the reset function needs to be within the form or gallery.

[@RezaDorrani]

Not sure about this. I would recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

[@user-yk3cd1nq1j]

thanks for this video. I am trying to create an inpection app with nested galeries and using 'group by' and a choice button for each gallery row. I want to add a submit to sharepoint button to submtit all answers at the same time, but it seems I am having trouble with the nested gallery data. I am trying to use for all and patch. Any suggesiton?

[@RezaDorrani]

Most welcome! I have not come across the mentioned issue and hence not sure what the reason for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

[@AnilKumar-ut2bi]

Hi Reza Thanks for sharing nice video... Can you make a video How to check/ create a PIM access through PowerApps.

[@RezaDorrani]

I will add this request to my backlog but will need a lot more folks requesting this topic to give it a higher priority. Meanwhile, I will recommend checking the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@brendan1516]

Reza, here is an interesting piece of info on medium data sets with many columns. I have been doing this grouping using Distinct for the parent gallery and Filter(category=thisitem.result) for the nested gallery. I load the galleries off a local collection that I create when the app starts up. I was optimistic that this GroupBy would improve performance, however I just did some testing on 2 data sets and my load times increased significantly. The screens with 2-3 second load times increase to 5-6 seconds. I can see GroupBy being very helpful when I want to have a list of options to change my grouping. However, in my case where the grouping is predetermined, it looks like the distinct/filter combo for the galleries has much better performance. Curious what your thoughts are or if you have used the distinct/filter nested gallery combo before. Thanks!

[@RezaDorrani]

Distinct and Group By slow down performance as they are not delegable functions. Have a predetermined grouping list helps. Of course, there would be scenarios where you would want to get distinct, in those cases it would be better letting flow grab those distinct values and then it could be loaded into a collection.

[@brendan1516]

@@RezaDorrani Thanks for the reply and putting together these tutorials! It's great to have many different tools to work with the data depending on the need. This GroupBy tutorial was the first time I had seen this. I generally do optimization testing once all my functionality is in place and I will definitely be putting this function to work!

[@RezaDorrani]

@@brendan1516 Glad to hear that! Thanks for watching and liking the video.

[@andreen6845]

Awesome vid, thank you. I have a scenario where I have a SharePoint list with multiple records of the same Region, using your example. So when I use your solution I get multiple records in the parent gallery with the same Region. I would like one record in my parent gallery with each distinct Region. Can't figure out a way to make this happen with delegable functions. Any ideas?

[@RezaDorrani]

There is no way with delegable functions. You would need your regions to either be in a defined flat list or a choice column.

[@KirahDaw]

Thank you as always Reza!! Quick question.... The first solution had a delegation issue, but why can't I see that ⚠️ delegation warning triangle symbol on your app.. I'm wondering how you've been able to ignore and hide it? I would like to be able to hide the triangle when I know it won't cause me an issue...

[@RezaDorrani]

Delegation warnings will show when editing the App. A running App will not show any warnings.

[@tonyon9497]

Kind of wondering if you had created other galleries under different screen names as of -"Group By Choice, Year, Standard prep", etc, which has Gallery1_3, Gallery3_3, etc or were they connected together. My guess is that they're disconnected with each other unless I missed such videos on those, since you reference some of them in the countRows func

[@RezaDorrani]

Can you point to the timing in the video when this is shown?

[@tonyon9497]

Thanks Reza, I was also wondering if there's any option to get any of the used codes for the group-by as there weren't displayed properly on my device while watching your video.

[@RezaDorrani]

The video is all I have. I have not run into any issues with this one I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@carlw]

Really slick stuff Reza thanks!! I'm going to use this technique. I wasn't sure whether to use this or Distinct, but I trust your judgement. One thing; using this technique, are we still able to add and edit the records?

[@RezaDorrani]

Video is related to gallery control which is for viewing data. You could very well connect the gallery to a form control to allow user to add or edit the data.

[@carlw]

@@RezaDorrani Roger. I'm noticing as you go down the parent list, the resulting children in data are increasingly vertically spaced rather than simple list mode as in the first record. I guess one of those strange microsoft anomalies that eventually prohibits one from going this route or requiring some hefty work around or hack?

[@RezaDorrani]

@@carlw Since its nested galleries, work needs to be done for alignment. Did not deep dive on it much as video is focused on the technique to achieve Group By with delegation in check.

[@carlw]

@@RezaDorrani yes I aligned them, they're just a couple of labels. In a small area. I've seen this behaviour in previous years but forgot. Definite in crease in space between rows as parent row increases. Must be a browser bug. It's at the point you have to clear cache every five minutes in order to make this stuff work RELIABLY. Cheers

[@RezaDorrani]

@@carlw :)

[@marney720]

Hey Reza, @14.21 when you change the text to Choices, what would you do if its a Person column instead please? Thank you!

[@RezaDorrani]

Choices are a fixed set of choices. Person type column is not fixed. Key to Group By with delegation is having a fixed set of choices. You could run a Distinct function on your Person type column but it will not be delegable.

[@rubenu5157]

Great videos as always. Reza, do you have any online PowerApps classes that I can follow step by step? Thanks

[@RezaDorrani]

Connect with me on my email [e-mail] for details on online training. I am working on an online training portal.

[@RezaDorrani]

Check channel memberships. I have gone live with a training tier that you can sign up for now. kzbin.infojoin

[@efrainperaza3754]

Hey Reza, Thanks again! Just a comment on the GroupBy and Addcolums work around for complex columns 02:31 , It seems that this does not work with multiple choice columns, the only solution I found for this is to concat the selected options in the new added column.

[@RezaDorrani]

Multiple choice columns would return an array. Concat would be an approach, but then individual groupings would be a challenge + multi-select columns do not support delegation when filtering.

[@efrainperaza3754]

@@RezaDorrani Thanks!

[@user-tq1xl5qv8j]

Reza, this is brilliant. How do you patch all data to SharePoint. Can you let me know please? I tried the ForAll Function but the data is not patching to sharepoint list.

[@RezaDorrani]

I have done videos on patching bulk data. Check those.

[@srinidhi9998]

Hi Reza, Thankyou for the very informative video. I was trying to achieve something similar but I do not have any choice column in my SharePoint list I only have text columns. In that scenario how can I achieve grouping for large data set along with filters? Can you please help me

[@RezaDorrani]

Text columns will run into delegation issues. Im not aware of any workarounds for that.

[@tarunamatharu6785]

Hi Reza, Very clearly explained, Thanks. I have a question, in a scenario where we have to group by 2 columns, Program and Project I tried using 3 layers of Gallery, level one Program, level two Project then last level Data. I am having issue all projects are reflected in all programs, another issue is how can I make this work when you select project , it should display only that corresponding data?

[@RezaDorrani]

I have not tried with 3 layered gallery hence not sure. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

[@tarunamatharu6785]

@@RezaDorrani just did

[@RezaDorrani]

@@tarunamatharu6785 Good luck. There are many experts who assist on the forums. I go to forums only in my free time.

[@lihtnes29]

Another great topic! I'm implementing the same area where i have to group based on certain incident types. I have 6 incident types and out of which 3 has got data and those 3 types are grouped properly with count. I also want to bring the other 3 with 0 as a count value.. Is there a direct way on grouping to do that to have all the items of the group by column and show value 0 for the type which doesn't have value.

[@RezaDorrani]

I believe possible but I would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@lihtnes29]

@@RezaDorrani - Sure. Thanks for the input. Let me put the query on the community! I can think of an ugly way of having an outside loop of all incident types and create a sub-table, but am sure there would be a direct way of doing it

[@assyabassya007]

Hi, Reza, thank you very much for one more inspirational and great video! I tried it and the delegation works lovely BUT I decided to take it a step further and I added "Blank vertical' as Nested Gallery, instead of 'Blank flexible height'. On the line level of the Nested Gallery added an 'Edit' icon and also a new screen with Edit From. But I got stuck how to set Items = ... in the Edit Form. Any suggestions how to get out of that or you have another a video I can watch? Appreciating your help a lot! PowerPlatform learning newbie, Assya

[@RezaDorrani]

I will have to look at your App in action or try out your scenario to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@assyabassya007]

@@RezaDorrani In between I solved my problem with VarID, Text Input and Patch, so for now can live without an Edit Form :)

[@kalpseditz9535]

You are my Savior. thank God.

[@RezaDorrani]

Most welcome

[@2007pradipta]

Thanks for the grt video Reza 😊 ... I want to Collapse/Expand the selected Region. currently it only Expand and if select different Region then only the other one Expand. so I want if click once it should Expand and if I click again it should Collapse same..

[@RezaDorrani]

I do not have a video reference on expand collapse scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@2007pradipta]

@@RezaDorrani thanks for quick response..i am asking same video at 09:13 where you click North it Expand. I want if click it again it should Collapse

[@RezaDorrani]

@@2007pradipta That I use the show hide logic. The video is not built for expand and collapse. You would need to set variables to track the state and accordingly expand and collapse.

[@Karthikeyan-lc7vt]

@@2007pradipta do u find any reference video link for expand and collapse pls share me

[@2007pradipta]

@@Karthikeyan-lc7vt will update you once get any help

[@carlw]

Trying this out, works well. Can the RegionText be concatenated and sorted together with an order field? e.g.: (1) North, (2) South, (3) West, (4) East for example given order is a field in the list.

[@RezaDorrani]

You could drive Regions data from a list which has named of Regions and Order. Gallery 1 items property would be - Sort(Regions,Order,Descending) or Ascending

[@carlw]

@@RezaDorrani tx, I'll try that. I also had flow merge them into a new text field, (order) title

[@MrOwenjames24]

Thanks Reza, very helpful - for my app I just have headings instead of buttons. How would I go about hiding the headings where no items exist? For example, if your North category had no items in the sub-gallery, how would you hide that from the view?

[@RezaDorrani]

For that you would need to write logic to check if items do exist in gallery within and accordingly show and hide. Not something I have tried though hence can only guide.

[@MrOwenjames24]

@@RezaDorrani I’ve got it working on the visible property, but now the gallery just has a big gap. Going to maybe try sorting the gallery by number of items so empty nested galleries are at the bottom…

[@fadiahdab]

Thank you so much , impressive as usual ,i still have something can't figure out till this moment which is getting the number of records or the sum of intended colum , without scrolling the whole gallery ☹️

[@RezaDorrani]

Video explains why you should not (will not) get total count for large result sets. Count, Sum etc. are not delegable functions.

[@fadiahdab]

@@RezaDorrani is there anyway to get the total and sum, I am just wondering

[@RezaDorrani]

@@fadiahdab Via flow. Check kzbin.info/www/bejne/r4nZdZ1sZZJmj7M

[@mardithpascua8112]

Hi Reza, can we group by "Week" the data from sharepoint? Like for example Time Tracking Log App

[@RezaDorrani]

Possible but that would involve calculation for week which would result in delegation warnings

[@stanleym69]

Hey Reza, How would you tackle a scenario where the choice column allow multiselect? It makes the choice column a table, I have tried to the 'in' operator but that or ungroup isn't delagable. Thanks Sam

[@RezaDorrani]

In is not delegable. You will run into delegation issues with multi select choice columns.

[@danielavasques5952]

Reza, first of all, thank you for one more incredible video! I have a question that you may be able to help me. I have a gallery in power apps and I have a filter in the items property of the gallery in order to filter the gallery by the current user (to only show the relevant information for them). However, I’d also like to add a GroupBy because I want to display the info based on a lookup column that I have. Both formulas work are working perfectly separately, but when I try do combine the filter with the group by to have everything in the items properly simultaneously, I always get errors. What can I do? 🙁

[@RezaDorrani]

Most welcome. I do not have a video reference on this scenario and would have to try it out to know more about it. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

[@danielavasques5952]

Thank you reza 🙏🏼

[@danielavasques5952]

​@@RezaDorrani I have another question, sorry. I have this in the items property of my gallery, as you described in your video: GroupBy( AddColumns('My Info', "CitizenIDText", 'Citizen ID'.Value), "CitizenIDText", "Data" ) In this 'MyInfo' list I have another column named "Short Description" which has 5 uses cases and another column named "Environent" with 3 options. As each Short Description is applied to each Environment, each Short Description is repeated 3 times for each citizen ID. The thing is that I don't want to repeat the Short Description 3 times, I'd like to only show it 1 time and then ahead have the text label for the 3 environments. Do you have any tip?

[@RezaDorrani]

@@danielavasques5952 I would have to try this out. I recommend to post your query with screenshots on the forums

[@usiripellishalomji9615]

Hi Reza, Can we display Groupby data inside the nested gallery in single string seperated by commas, for eg: In South we have Title column in nested gallery ,Can we display all of the Title names in a single Label seperated by commas? If so could you please tell me how to do it

[@RezaDorrani]

My guess would be Yes. For the how - I would have to try it out to provide guidance. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

[@adelinabordeianu6509]

Hi really great video and really helpful. I tried to recreate this on my own but it seems like still I cannot cross the 2000 items limit. Am I doing something wrong?

[@RezaDorrani]

I have not come across the mentioned issue and hence not sure what the reason for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

[@mardithpascua8112]

Is it possible to us 2 level group by? Example: raw data is: Employee Name, Emp Log In, Emp Log Out, TaskName, Duration - I would want to first Group it by Per Empoyee Name then each Employee name would have grouped of Distinct or Unique Taskname with their total duration? Hope you could notice this. Thank you!

[@RezaDorrani]

Possible but not something I have done or have a video reference for. I recommend checking on forums in case someone has done something similar powerusers.microsoft.com

[@derekgray3019]

Brilliant Rezza, I've just created a GroupedBy flexible height gallery with a nested flexible height gallery to show some KPIs from this tutorial. I am trying to get the nested gallery to be collapsed, then open/closed OnSelect of the button, but unable to get it to work. Do you have a solution for that?

[@RezaDorrani]

I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@derekgray3019]

@@RezaDorrani thank you Rezza, I’ll post details in a few days time in the community forum.

[@radhikap3322]

Hi do you have an example of one ->many->many like one teacher can teach multiple scujects and each subject is enrolled by may students in canvas app using gallery if possible

[@RezaDorrani]

I do not have a video reference on this scenario. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@jasona7029]

Can you group by based on lookup or relationship from different Sharepoint list?

[@RezaDorrani]

Key will be to get your list of choices from lookup list similar to what was showcased in video for choice column.

[@sureshpeddyreddy8324]

Can we add one more nested gallery or can we implement group of two column and their hyperlinks as third level

[@RezaDorrani]

I don’t believe galleries allow nesting to 2 levels

[@traidang1]

Thanks, very nice work, but I'm still can't figure out how button link to detail screen, i.e Gallery.Selected in Item property in Detail screen because GroupBy uses "Data"

[@RezaDorrani]

I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@dandrem.4074]

I have to say this is pretty nice. Can it be done on an edit form?

[@RezaDorrani]

Edit form works with a single item. A gallery is a collection of data on which group by is being performed.

[@dandrem.4074]

@@RezaDorrani Would you happen to have a video for that? 😅

[@RezaDorrani]

@@dandrem.4074 I do not

[@dandrem.4074]

@@RezaDorrani awwww

[@pedrosanteloy]

What if the source was an Azure SQL data table? What could be an option for Choices function to handle with delegation?

[@RezaDorrani]

You would need to find a way to get the group by headings. It could be a view in sql that has the distinct group by headings. Once you have that, the pattern would be similar to the one showcased in the video.

[@mudassirsyedrashidali9787]

Elon Musk of Power Platform strikes again:)

[@RezaDorrani]

Most of my videos are based on viewer suggestions. All credit goes to them.

[@sanjaypradhan8168]

Hi Reza, Good Morning, Flexible Gallary not showing all items though I scroll till last after expand. Any suggestion please?

[@RezaDorrani]

I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

[@tonyon9497]

Thanks Again Reza, Would you by any chance have a Udemy training course, where you may have elaborated on the above training on "Group By", "Sorting", etc, delegations

[@RezaDorrani]

I do not have any courses on Udemy.

[@tonyon9497]

@@RezaDorrani I love your training and was wondering if you do have or host any online training program

[@RezaDorrani]

@@tonyon9497 I do plan on live training via channel memberships. Currently, channel members get a quarterly office hours session

[@RezaDorrani]

Check channel memberships. I have gone live with a training tier that you can sign up for now. kzbin.infojoin

[@venkateshu1796]

after grouping patch button not working , it is working only when i removed ForAll ( Gallery1.Allitems ) for only few controls like title & Date it patching.any correction required in my code? ForAll( Gallery1.AllItems, Patch( ABC, Defaults(ABC), { Title: name.Text, Date: DatePicker1.SelectedDate, Question: QLab.Text, Answers: Radio1.Selected.Option } ) )

[@RezaDorrani]

I cannot help fix issue by looking at code here on chat. Best place to post issues with screenshots is the forums. There are many experts on forums who assist in their free time. powerusers.microsoft.com

[@marney720]

hey Reza, @19.21 when you are applying the filter, is there a way to make the result come to the top of the gallery? In your app, it's showing "no items" so you would have to click on South, East, West to find the results in Class 1. Thanks so much Reza,

[@RezaDorrani]

For that you would have to check the count of items in each gallery which would run into a delegation issue again since Count is not delegable.

[@marney720]

@@RezaDorrani thanks for the reply Reza! I'm not too worried about the delegation issue as my list won't be that big but if you have any tips on how to get the result to the top of the gallery that would be amazing! thanks again

[@RezaDorrani]

@@marney720 You would need to define a custom sort order logic for the top gallery. Order it based on count of number of items within them. I would have to try it out to provide the steps. I would recommend checking on forums in case someone has done something similar powerusers.microsoft.com

[@genovjillella3602]

Great video, I need to use groupby to summarize data by group and show totals in main group and details in a sub gallery with large dataset in dataverse and avoid delegation issues. In your video you started with groupby and then went away from it. How can I code groupby in items to avoid delegation. can I filter dataset first then use groupby? How would you code that example. Thanks

[@RezaDorrani]

GroupBy is not a delegable function. That is reason why I showcased another technique to obtain a similar output.

[@genovjillella3602]

How do summarize by group with your technique. I am trying to filter by from - to date first then I was trying to groupby employee and summarize each employee's time entered. Any ideas would be great. How would the code look like Thanks, I appreciate

[@RezaDorrani]

@@genovjillella3602 Key would be to have a predetermined set of groupings maintained separately. Example choices of a choice column or your employee list. That you can query directly (without group by) and use technique shown in video. There is no way to use groupby function and make it delegable.

[@genovjillella3602]

I'm not using a choices column. I'm using name column. I'm getting error "name isn't valid" items: Choices(TimeData.TM_Employee) TM_Employee isn't a choices column its a text column how do I code this to get the desired results

[@genovjillella3602]

additional info I'm filtering Time data entries first Filter( TimeDataEntries, TM_Date >= DatePicker_start_4.SelectedDate And TM_Date

[@rhydonplay9190]

I have a 8000+ records in a sharepoint list, with documents that people need to sign, but, its only loading 2000 as the limit, I dont have any Choices column, can this work with a Person column? Group by Person documents related? To show documents that belongs to current user only?

[@RezaDorrani]

Person type column is delegable. A very old video but proves the delegation concept for person column (single select) - kzbin.info/www/bejne/qoHbdpJjeciKock

[@ravindrakotwal7348]

How we can patch grouped data into a list? Just need to patch grope headings, not whole data inside groups.

[@RezaDorrani]

Group headings are based on data available in data source. Why would you patch them as the value already exists?

[@poojashetty2195]

Hi Reza, Do you have any idea how we can get more than 1000 rows of data in powerapp when using powerbi as a datasource?

[@RezaDorrani]

That is a limit and cannot be changed. There is no way around it.

[@poojashetty2195]

Thanks for the reply @Reza Dorrani

[@sandy-rj8wu]

Hi Reza, I am looking for solution to get random people pair up for coffee sessions. Is there any video covering shuffle or random selection.

[@RezaDorrani]

I do not have a video reference on that scenario. I will recommend checking on forums in case someone has done something similar powerusers.microsoft.com

[@OZerador]

Is there a way to transform an existing gallery into one with a flexible height?

[@RezaDorrani]

There is no option for that as far as I know. You would need to build one from scratch.

[@aafreensultana1835]

Hi Reza, what if i am grouping the data twice, how can i get the data in the nested gallery ?

[@RezaDorrani]

You would need to nest again I guess. I have not tried multi level grouping. Hence Im not sure of the steps.