I am trying to create a flow that counts the number of items within a SharePoint List, based on a value within a column.
In my list I have a 'Assigned To' column which will always be 1 of 3 names. I would like to create a flow that sends out an email (using the recurrence action) to each of the three people saying how many items they have assigned to them.
I have another column, called 'Progress' that has a value called 'Resolved'. I wouldn't want any of the items that have been 'Resolved' to be include in the count.
Is this something that Flow can do, and if so, how?