cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Hoowie01
New Member

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

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.

Hoowie01_0-1596917390483.jpeg

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 

Hoowie01_1-1596918104243.jpeg


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 

   

3 REPLIES 3
Hoowie01
New Member

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
New Member

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

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?

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,060)