cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RodAtWork
New Member

Check for an email each week day

I need a way of checking my business email each weekday at 9 AM to see if an automated email has arrived or not. If it hasn't arrived, then I want to receive an email about that. If it has arrived, then do nothing. Is that possible with Flow as it currently is, or does some additional functionality have to exist?


Rod
1 ACCEPTED SOLUTION

Accepted Solutions
v-yuazh-msft
Community Support
Community Support

Hi @ RodAtWork ,

 

Could you please show more details about the automated email?

How many times the automated email would arrive every weekday.

Would the automated email always sent by a fixed email address or it always use the same subject?

Does the automated email have attachments?

 

I have made a test on my side, please refer to workaround below:

  1. Add trigger “Recurrence” as screenshots,you could choose the frequency as one week,choose the day of a week to trigger the flow on "On those days"field, you could choose the hour of a day on "At those hours" field.
  2. Add action “Get emails”, choose Inbox in the Folder field, Fetch Only Unread Messages field set to Yes, if the automated email have attachments, set the Include Attachments field to Yes, otherwise set the field to No. set a value in the Top field, make sure the Unread email in your Inbox would less than or equal to the Top value.
  3. Add a “variable”, the Type choose Integer.
  4. Add an apply to each, choose the Body dynamic content of “Get emails” action
  5. Inside the apply to each, add a Condition to filter the emails from your Inbox, if the email would always sent by a fixed email address, you could compare the email address in the Condition, if the email would always use the same subject, you could compare the subject in the Condition.
  6. Inside the if yes of Condition, add a variable “Increment variable”, choose the variable created before, fill 1 in the Value field.
  7. Outside the apply to each, add a Condition2,the first value choose the dynamic content of the variable, the second value fill in 0, the condition in the middle select “is equal to”.  
  8. Inside the if yes of Condition2, add action “Send an email”, fill in the email address ,Subject and Body.

 1.png2.png

 

If the automated email arrives before the flow runs, the flow would run successfully as below:

3.png

 

If the automated email doesn’t arrives before the flow runs, the flow would run successfully as below:

4.png

 

If the automated email would arrive one time, every weekday, you could make the flow as screenshots below:

 5.png

 

 

 

 

Regards,
Alice Zhang

View solution in original post

3 REPLIES 3
v-yuazh-msft
Community Support
Community Support

Hi @ RodAtWork ,

 

Could you please show more details about the automated email?

How many times the automated email would arrive every weekday.

Would the automated email always sent by a fixed email address or it always use the same subject?

Does the automated email have attachments?

 

I have made a test on my side, please refer to workaround below:

  1. Add trigger “Recurrence” as screenshots,you could choose the frequency as one week,choose the day of a week to trigger the flow on "On those days"field, you could choose the hour of a day on "At those hours" field.
  2. Add action “Get emails”, choose Inbox in the Folder field, Fetch Only Unread Messages field set to Yes, if the automated email have attachments, set the Include Attachments field to Yes, otherwise set the field to No. set a value in the Top field, make sure the Unread email in your Inbox would less than or equal to the Top value.
  3. Add a “variable”, the Type choose Integer.
  4. Add an apply to each, choose the Body dynamic content of “Get emails” action
  5. Inside the apply to each, add a Condition to filter the emails from your Inbox, if the email would always sent by a fixed email address, you could compare the email address in the Condition, if the email would always use the same subject, you could compare the subject in the Condition.
  6. Inside the if yes of Condition, add a variable “Increment variable”, choose the variable created before, fill 1 in the Value field.
  7. Outside the apply to each, add a Condition2,the first value choose the dynamic content of the variable, the second value fill in 0, the condition in the middle select “is equal to”.  
  8. Inside the if yes of Condition2, add action “Send an email”, fill in the email address ,Subject and Body.

 1.png2.png

 

If the automated email arrives before the flow runs, the flow would run successfully as below:

3.png

 

If the automated email doesn’t arrives before the flow runs, the flow would run successfully as below:

4.png

 

If the automated email would arrive one time, every weekday, you could make the flow as screenshots below:

 5.png

 

 

 

 

Regards,
Alice Zhang

Basically, I want to automated email to come from my own account. It should run once a day, but about 9 AM. I'm at home now, but when I return to work tomorrow I'll try to give you more details.


Rod

WOW, I cannot believe this, but I've let this lie for 2 years!! My apologies.

 

Here's an example of the email that comes through, upon a successful run of the SQL Server SQL Job:

 

Annotation 2020-02-07 131918.jpg

There's a lot of sensitive information in the email, so I cannot show more than that.

 

As I said, this email came through fine. What I'm interested in is an email that would be sent to me by Power Automate, when an email like the one above does not come through by 9 AM each weekday. If no such email shows up, then I want to get an email from Power Automate alerting me to that.

 

The thing which I believe will complicate this is that we don't have control of the MS Exchange server. I work for a state agency. We have Office 365 for Business, so I've got the latest Outlook. But a different state agency handles the MS Exchange server for everyone. Their Exchange Server is on-premise and it's version 2013, so it's old. I've no idea if that will "play nice" with Power Automate or not.


Rod

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.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

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.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (1,880)