AnsweredAssumed Answered

Count List Items based on User Name

Question asked by jhong88 on Jan 31, 2018
Latest reply on Feb 2, 2018 by emha

Hi Everyone


I have a SP list with the following columns


Assigned to

Due Date


I want to query the list based on the due date then count how many items each "Assigned to" person has and send that out via email.  So if the list has the following


Due Date           Assigned To

01/01/2018         Mike

01/01/2018         Mike

01/01/2018        Charles


I want the email to show:


Due Date 01/01/2018

Mike: 2

Charles: 1


 I know that I can use the Query item and filter out each person, then do a count on the collection, but that's not really feasible as users come and go.  I tried using the "For Each" I can get the user name based on the index, but can't count based on the index, I'm stuck.   Help!