cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Super User
Super User

Looking for ideas on a workaround for the nested gallery limit workaround

There may well not be a solution, but I'm looking for ideas if anyone has any... I am looking to improve this report view and what I really need is 3 levels of nested galleries which is not permitted.  (I have voted for the existing idea someone submitted for this).  Here is the current report which uses 2 nested galleries:

Report sample.jpg

 

Notice that the project name (Test Project 1) is being repeated for each milestone.  What I REALLY want is to show the project name once, followed by a list of all the milestones for that project, then the next project name (not shown here), followed by its milestones like this...

Report sample 2.jpg

To do that I need to next one more level of gallery which can't be done today.  I explored using a data table for the intermost level but it automatically gets added to the 1st gallery, not the second, no matter what I do.  

 

I suspect this might be the best I can do but if anyone has any bright ideas, I'm all ears.

Thanks,

LRVinNC

LRVinNC

------------------
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
14 REPLIES 14

@LRVinNC 

I thought you might like that!! 

So, some of the rational is that I was throwing this together quickly. So, I have no doubt that some refactoring would be beneficial.  AND, there are actually some issues with it when doing anything OTHER than the sample data.  SO, it's not ideal!  (hope that doesn't burst your Happy Monday Morning bubble)

 

Let me fidget with it a little more and I'll get you some more specific details (and perhaps a more universal formula).

 

As for the Collect and Filter - that's not an issue as it is not "altering" of the collection.  We can look at aspects of the collection while collecting it, we run into trouble when trying to alter the collection while collecting the same collection.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

@LRVinNC 

Finally got a chance to review it again...Yes, I was correct, there were a lot of "rush this together" moments in there.

The issue was, that if you added any other projects to departments, things got a little wacky. 

 

So, attached is a new version of the same.  The formula in the OnStart is quite different and this time it accounts for all the levels, all the projects and the grouping/association of each.  As well, it adds sorting at all levels.

I added some more test data in the sample collection.  More importantly, that I added items somewhat randomly in the data to ensure that grouping of projects and departments along with the proper milestones would occur...it does.

 

Take a look over it and let me know what you think or if you have any questions.

I think there could still be some refactoring that would help, but only had a little time to look it over.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

View solution in original post

Holy smokes @RandyHayes . Your app shows a very cool use for SortByColumns. Also @LRVinNC, your table is well organized for this type of application. 

This is an ALLSTAR example of the PowerApps community. Excellent collaboration and thank you both for being so committed and willing to share!

@RandyHayes I did not think my jaw could drop any lower... I was wrong.  {Bowing to the master}

 

And thank you for the annotations.  I'll work tomorrow to integrate this into one of my reports and let you know how it goes.  I couldn't have dreamed this up in a month of Sundays and the fact that you can do certain things is still fuzzy in places, but it clearly works well. 

 

Thanks for all the thought you put into this.  Amazing solution.

LRVinNC

------------------
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

@LRVinNC 

I'm very happy that it will have some practical use.  Definitely let me know how it works in your app.

I believe this works pretty well for any situation where there are at least three levels deep like you have in the data.  It could probably easily have more levels integrated into it.

Hopefully I threw in enough annotation to guide, but if there are any questions, just shout!  Smiley Happy

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

Helpful resources

Announcements
News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (7,986)