cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dewhite
Regular Visitor

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

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.

3 REPLIES 3
Expiscornovus
Dual Super User
Dual Super User

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'))

 

checknumberofnotifications.PNG

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
Dual Super User
Dual Super User

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 🙂

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Users online (3,466)