Counting number of items in a list using power automate

Question

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.&nbsp; I have found examples of getting the number of items in a list, but none based on a condition.&nbsp; Any examples that anyone knows of?&nbsp;Thanks

arefhalmstrand · Answer

rbutgins21&nbsp;Hello,Please check this link below:https://powerusers.microsoft.com/t5/General-Power-Automate/How-to-get-an-item-from-list/td-p/194239&nbsp;The scenario is built for fetching a specific item by id, however you could change the values to match your request.

rbutgins21 · Answer

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

rbutgins21 · Answer

I figured it out, thanks!

nidhisingh · Answer

rbutgins21&nbsp;I have a requirement:1. The data is fetched from Power BI data.2. If count of column &lt; 10, then send email in plain text HTML format .3. If count of column &gt;10, send email as excel attachment.&nbsp;

Forum Discussion

Counting number of items in a list using power automate

Share

Resources