Thanks in advance.
I have a Sharepoint list which the 'audience' field allows multiple selections for who a class is being held for (i.e. Team A, Team B, Team C, etc.), so a record could have one or more teams selected.
What I am trying to ultimately accomplish is, whenever an item is created or updated, run through the whole list and output a total count of classes (record) that each team is identified in.
For example, I might have
ID Audience
1 Team A
2 Team A, Team C
3 Team B, Team C
4 Team A, Team B, Team C
5 Team C
So, I would want to see is to have a total count updated in their own value in their own record in a different sharepoint list (would use for a graph I am building in Collabion).
i.e.
Team Count
Team A 3
Team B 2
Team C 4
I know I can use a Configure Action - Query List to run through all of the items and put the values into a collection variable, I just don't know how to parse them based on values and count them as groups.
