Count notification emails daily and trigger email alert if there are less than 23 notifications.

[Dewhite]

Hello everyone,

There is a hourly notification email received from specific email address.

Every 24 hours, the amount will be counted to ensure there is no missed notification.

Appreciate if any configuration with screenshots can be shared.

[Expiscornovus]

Hi @Dewhite,

You could use a filter array action to check the receivedDateTime values of the e-mails received from that specific email. With a length function you could check the number of items in a condition action.

Below is an example of that approach.

In this example I am running the flow every day at 23:45.

In the Filter Array I am checking that the Received time is greater than or equal to 

utcNow('yyyy-MM-ddT00:00:00+00:00')

With this expression the number of items is checked:

length(body('Filter_array'))

[Dewhite]

Hi, @Expiscornovus

Thank you so much for the detailed instruction.

I scheduled the run time as 13:45, so the result is not correct.

I guess I should follow your setup (23:45) because:

Top 24 emails will be checked.

The fitter will fetch the emails of the day.

If all notifications were received successfully, the array should contain 24 items.

[Expiscornovus]

Hi @Dewhite,

Yes, this example setup works best when you run it at the end of the day.

If you want to run it in the middle of the day the setup should be changed. In that case you probably use an addhours function (-24) with the Utcnow. Is that a requirement to run it in the middle of the day? Otherwise stick to the end of the day 🙂