Counting number of items in a list using power automate

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!