Hello,
Trying to conceptualize how I would build a canvas app screen that would have a drop down that would select a team from a Sharepoint List. Then based upon that team, show all of the distinct team members and also show the number of tickets assisgned to them. I'm guessing CountRows will give me the # of tickets.
For context:
I'm using two SP lists, one "Staff" with a drop down to select the Team name:
Items:
Distinct(
'staff',Team
)
Lets say the column in list "staff" has teams A, B, C. Team A has Sally, Bob, Fred, Team B has Burt, Mike, Jill, Sarah
On the screen I'm going to have a dropdown to pick the team (item above), then I'd like the gallery contain to show a dynamically created number of Text Labels that would then have one label for each team member name and also show the # of countRows (tickets). This count rows would be a filter from a different list called Tickets.
What I'm not getting is how to create the dynamic number of text labels for Team B above (so 5 labels), populate each with the distinct name and the # of rows for each....
I'm wondering if I should use a table and filter that based upon team and then do something to only show distinct team member names and a count of rows...
Ideas anyone?
