How do i get my data shown grouped/nested in correct Way ?

[Hoowie01]

Hi fellow powerusers,

I really much would like to ask if anyone could help with guiding the last step. It is a canvas app. 

My plan with first part of my application is to be able to add anyone in our organisation with use of “people picker “. Afteradds it open up for user to be able to assign the specific person to our projects and the teams within the project.

due to huge amount of people, it is important with the team within a project as well. There are roughly around 20 projects with 2-10 teams in each project. 20-100 assigned to each project. 

I struggle being able to present the data I want for the “dashboard” view of all projects and teams at the same time, where I need your expertise.

to give u better idea below is example with myself. 

first the people related, where I have added myself. The values of the fields from 0365users from people picker are saved to SharePoint when added called “people” with unique people.

On Assigment screen you can do multiple assignments for each unique person.

the values are saved to table “assignments”;

”Train”, “Team”, start date, end date, allocation 

the view I am trying to get on dashboard view is for example as below:

Grouped by “Train”

Grouped by all “Team”s’ Under the “Train”

Data: assigned people, where it will show a few fields and you can click to see more info as on first screenshot for each assigned.

example: 

“Customer” 

   • “Team RandomName”

      - Carsten, 01/01/20 to 31/12/20 100%

      - Ole, 03/05/20 to 08/08/20 50%
      - Preben, 09/06/20 to 09/09/20 100%

  • “ Team RandomName2”

       - Borge 08/09/20 to 31/12/20 100%

       - Anders 08/09/20 to 31/12/20 100%

”NewfancyTrainName”

   • “Teamwhoknows”

        - Batman 08/09/20 to 31/12/20 100%

... onwards 

I can’t get the grouping, with additional grouping under to work. 

please if anyone could help me with achieving this I would appreciate it a lot.

Thank you! 

Br Carsten 

[Hoowie01]

Just to be clear. The dashboard view is on programme level. In the programme we have 20+\- Trains. In each train 2-10 teams. In each team 3-100 people. 

therefor trying to get this grouped in a nice presentable way similar to example a tabular pivot table.

Programme Name is application headline I will be using. “Lvl 0”

______________

Train Name - level 1

        • Team Name - level 2

              - Employee Name - level 3 Count(Employee Name in this team)

Count(total teams in Train), count (total employees in Train)

————————

count(total trains for programme), count(total teams for programme), count(total employees for programme)

Click on a employee to show details for the employee as first screenshot  🙂

let me know if anything unclear! Thanks

[Hoowie01]

Just to be clear. The dashboard view is on programme level. In the programme we have 20+ Or - Trains. In each train 2-10 teams. In each team 3-100 people. 

therefor trying to get this grouped in a nice presentable way similar to example a tabular pivot table.

Programme Name is application headline I will be using. “Lvl 0”

______________

Train Name - level 1

        • Team Name - level 2

              - Employee Name - level 3 Count(Employee Name in this team)

Count(total teams in Train), count (total employees in Train)

————————

count(total trains for programme), count(total teams for programme), count(total employees for programme)

Click on a employee to show details for the employee as first screenshot  🙂

let me know if anything unclear! Thanks

[thjeffri]

Hi Hoowie01,

This sounds like a pretty complex scenario and I'm not sure I get the full picture.  However from your description, what I think you will need to implement is either:

1) A series of galleries, where one gallery filters the next.  Example: Have a gallery of Trains.  The selection on Trains filters the next gallery, which contains Teams.  The selection on Teams filters the next gallery, which contains assignments.

OR

2) A nested gallery, like what is described in these resources:
https://powerusers.microsoft.com/t5/Building-Power-Apps/PowerApps-Nested-Gallery-Filtering/td-p/4687...

https://www.c-sharpcorner.com/article/expand-and-collapse-view-using-nested-gallery-powerapps/

If you do something like this, you should be able to select Train > Team > Assignments.

Does this help answer your question?