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

[LRVinNC]

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:

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...

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

[RandyHayes]

@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.

[RandyHayes · Accepted solution]

@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.

[ericonline]

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!

[LRVinNC]

@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.

[RandyHayes]

@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!  

[karimabdelrazek]

love it!

[VP2021]

How would you apply this concept to a single table like a time table of partime emplyees (ID, Name, Date, Time In, Time Out), how would you group the employee with date range in a week (eg.1 Jan 2021 - 7 Jan 2021).

[VP2021]

How would you apply this concept to a single table like a time table for partime emplyees {ID, Name, Date, Time In, Time Out}, how would you group the employee with weekly date range (eg.1 Jan 2021 - 7 Jan 2021).