Counting number of items in a list using power automate

[rbutgins21]

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

[#2]

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

[#3]

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

[#4]

I figured it out, thanks!

[#5]

@rbutgins21 

I have a requirement:

1. The data is fetched from Power BI data.

2. If count of column < 10, then send email in plain text HTML format .

3. If count of column >10, send email as excel attachment.