I have a SP list with the following columns
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
I want the email to show:
Due Date 01/01/2018
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!