Oct 14 2020 12:21 PM
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
Oct 14 2020 12:41 PM
@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.
Oct 14 2020 01:17 PM
@ArefHalmstrandI was trying to use a filter array part and then check the count, but it isn't matching the count
Oct 14 2020 01:22 PM
I figured it out, thanks!
Jun 09 2022 03:43 AM
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.