Flow to count items in a SharePoint List

%3CLINGO-SUB%20id%3D%22lingo-sub-250801%22%20slang%3D%22en-US%22%3EFlow%20to%20count%20items%20in%20a%20SharePoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-250801%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20create%20a%20flow%20that%20counts%20the%20number%20of%20items%20within%20a%20SharePoint%20List%2C%20based%20on%20a%20value%20within%20a%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20my%20list%20I%20have%20a%20'Assigned%20To'%20column%20which%20will%20always%20be%201%20of%203%20names.%20I%20would%20like%20to%20create%20a%20flow%20that%20sends%20out%20an%20email%20(using%20the%20recurrence%20action)%20to%20each%20of%20the%20three%20people%20saying%20how%20many%20items%20they%20have%20assigned%20to%20them.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20another%20column%2C%20called%20'Progress'%20that%20has%20a%20value%20called%20'Resolved'.%20I%20wouldn't%20want%20any%20of%20the%20items%20that%20have%20been%20'Resolved'%20to%20be%20include%20in%20the%20count.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20something%20that%20Flow%20can%20do%2C%20and%20if%20so%2C%20how%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-250801%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-250877%22%20slang%3D%22en-US%22%3ERe%3A%20Flow%20to%20count%20items%20in%20a%20SharePoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-250877%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Fsharepointlibrarian.com%2F2018%2F08%2F21%2Fuse-microsoft-flow-to-get-the-number-of-items-in-a-sharepoint-list-or-library%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsharepointlibrarian.com%2F2018%2F08%2F21%2Fuse-microsoft-flow-to-get-the-number-of-items-in-a-sharepoint-list-or-library%2F%3C%2FA%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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?

 

 

1 Reply