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%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%3CLINGO-SUB%20id%3D%22lingo-sub-1781139%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-1781139%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F284426%22%20target%3D%22_blank%22%3E%40ArefHalmstrand%3C%2FA%3EI%20was%20trying%20to%20use%20a%20filter%20array%20part%20and%20then%20check%20the%20count%2C%20but%20it%20isn't%20matching%20the%20count%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22rbutgins21_0-1602706636843.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F226741i33123C2DC9E3BE8C%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22rbutgins21_0-1602706636843.png%22%20alt%3D%22rbutgins21_0-1602706636843.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
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

@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.

@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

 

I figured it out, thanks!