Counting number of items in a list using power automate

%3CLINGO-SUB%20id%3D%22lingo-sub-1780952%22%20slang%3D%22en-US%22%3ECounting%20number%20of%20items%20in%20a%20list%20using%20power%20automate%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1780952%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20afternoon%2C%3C%2FP%3E%3CP%3EI%20am%20needing%20to%20build%20a%20flow%20that%20will%20count%20the%20number%20of%20items%20with%20a%20certain%20value%20in%20the%20status%20field%20and%20then%20if%20the%20count%20is%20a%20specific%20number%2C%20send%20an%20email.%26nbsp%3B%20I%20have%20found%20examples%20of%20getting%20the%20number%20of%20items%20in%20a%20list%2C%20but%20none%20based%20on%20a%20condition.%26nbsp%3B%20Any%20examples%20that%20anyone%20knows%20of%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1780952%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1781037%22%20slang%3D%22en-US%22%3ERe%3A%20Counting%20number%20of%20items%20in%20a%20list%20using%20power%20automate%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1781037%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F634702%22%20target%3D%22_blank%22%3E%40rbutgins21%3C%2FA%3E%26nbsp%3BHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3EPlease%20check%20this%20link%20below%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FGeneral-Power-Automate%2FHow-to-get-an-item-from-list%2Ftd-p%2F194239%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FGeneral-Power-Automate%2FHow-to-get-an-item-from-list%2Ftd-p%2F194239%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20scenario%20is%20built%20for%20fetching%20a%20specific%20item%20by%20id%2C%20however%20you%20could%20change%20the%20values%20to%20match%20your%20request.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Contributor

Good afternoon,

I am needing to build a flow that will count the number of items with a certain value in the status field and then if the count is a specific number, send an email.  I have found examples of getting the number of items in a list, but none based on a condition.  Any examples that anyone knows of?

 

Thanks

3 Replies
Highlighted

@rbutgins21 Hello,

Please check this link below:

https://powerusers.microsoft.com/t5/General-Power-Automate/How-to-get-an-item-from-list/td-p/194239

 

The scenario is built for fetching a specific item by id, however you could change the values to match your request.

Highlighted

@ArefHalmstrandI was trying to use a filter array part and then check the count, but it isn't matching the count

 

rbutgins21_0-1602706636843.png

 

Highlighted

I figured it out, thanks!