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
