"Remind for follow up on important emails sent, with no response" not triggering from Office 365 Outlook

[jporter]

Hi All,

I'm having trouble with the "Remind for follow up on important emails sent, with no response" workflow.  It works when I tested the flow using "data from Office 365", but it does not work whenever I send a high priority email from the Office 365 Outlook account ( I tested it by sending high priority emails to my colleague).    Does anyone have suggestions on how I can get this template to work properly?  See images below.  Any guidance would be appreciated!

Test Flow Results

When I sent test emails to coworker

Here are the settings for my workflow

[v-alzhan-msft]

Hi @jporter ,

Why are you has two trigger in the flow?

One flow could only has one trigger, the trigger when a send an emails wouldn't work, you should only create a flow with trigger when a new email arrives, and when a new email arrives, the flow would run.

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jporter]

Hi @v-alzhan-msft  ,

Thank you for your response.  I used the public template (see link below) for this workflow and it automatically generated the triggers you saw.

When I send an email marked as high importance, I want to get a prompt response. However, sometimes my co-workers may not respond quickly. This flow should remind me X hours after I send an email marked as High Importance, if, and only if, nobody responds to it.

I'd like to receive an email notification only when my coworker has not responded to a high importance email I sent, after a certain period of time.  I hope this provides clarity to my goal for this workflow.

Thanks!

https://us.flow.microsoft.com/en-us/galleries/public/templates/2b5075ef950548339116c00149b7d6f4/remi...

[jporter · Accepted solution]

Hi everyone,

I've figured out how to make the workflow function properly.  I'll post screenshots below for anyone who may be struggling with this.  Hope this helps!

[v-alzhan-msft]

Hi @jporter ,

I couldn't create connection to the office 365 Outlook connector, so I can't open the template that you provided.

And I'm afraid that your requirement couldn't be achieved in Microsoft flow currently since there is no any function could check if an email has been replied.

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jporter]

Hi Alice,

Thank you for trying!  I was able to configure the work flow to work appropriately (see my solution in the post above).  For future reference, more than one trigger can be used in a work flow and using a "condition" action with parameters will allow you to check for an email response.  It took a lot of trial and error, but I got it to work!  The next improvement to my work flow will be filtering out 'Automatic reply' responses.

[hermes-msft]

Hello @jporter, I'm trying to get this flow working and came across your solution; however, even though I'm replicating your values I'm getting this error:

ActionConditionFailed. The execution of template action 'Condition' is skipped: the 'runAfter' condition for action 'When_a_new_email_arrives' is not satisfied. Expected status values 'Succeeded' and actual value 'TimedOut'.

Did you come across this error by any chance? Also, would you mind sharing the settings you had on each step of the flow?

Thank you!

Hermes.

[dguzauckas]

I have tried using the solution as presented and get this error:

The execution of template action 'Apply_to_each_2' failed: the result of the evaluation of 'foreach' expression '@body('When_a_new_email_arrives')?['value']' is of type 'Null'. The result must be a valid array.

Thanks for your help.

Donald

[MTW]

Thanks for this! How can I change it to be ANY email and 2 days instead of 4 hours?

[mpals22]

@MTW

To change the emails from Important to ANY: Under "When I send a High importance email" press show advanced options, the from the drop down press ANY. 

To change period of occurrence: Under "When a new email arrives" press the three dots on the right, then select Settings. In the Timeout section enter P2D, to change from 4 hours to two days. 

I'm new to Power Automate so there may be different/better ways to do this; however, this is what I have found in my research.

[ssh1]

hi all,

i have tried to change the time to PT5D but i think the flow just stopped at "when a new email arrives" and never goes to the next step of "condition" and action.

does anyone have the same problem?

[ssh1]

Hi MTW,

Did you get this flow work for 2 days? mine does not seem to work

[mpals22]

For anyone having issues with the workflow I was finally able to fix mine and make it simpler. The big change is that I removed the condition for yes and no as it was not necessary. Below are screenshots of my current flow and I'll go over any issues I had and how I fixed them. I still used the template as a base. 

Overview of new work flow:

When I send a High importance email:

I added a subject filter so that only high importance emails with that word are selected for the flow

When a new email arrives:

I changed the length of timeout to 7 days. The duration is in ISO 8601 format. An explanation of the format can be found on Wikipedia, under the Durations section. For example, "P3Y6M4DT12H30M5S" represents a duration of "three years, six months, four days, twelve hours, thirty minutes, and five seconds". P2W is two weeks, P2D is two days, PT4H is four hours.

I had issues with entering the format incorrectly so this could be what is happening if the duration isn't working like you think it should.

Condition:

Delete the condition, as it is not necessary

Add a new step:

Send me an email notification

Send me an email notification:

When typing and entering dynamic content, DO NOT select any content under the section "when a new email arrives."

This is where my biggest issues were coming from. There is no data for Power Automated to pull from under the "when a new email arrives" section because the flow is running due to no email arriving. It may sound simple, but it took me too long to realize I needed to scroll farther, to the "When I send a High importance email" section.

Incorrect:

Correct:

ONE OF THE MOST IMPORTANT STEPS:

Make sure "has timed out" is selected. Once the time duration of the flow, set previously, has past then the action "send me an email notification" will run. My flow runs great without having "has failed" as another selection, so I did not select it like jporter did. 

Then Save!

Hope this helps someone!

If you have any issues I would be happy to help figure them out if you reply with screenshots and descriptions of your issues! 🙂

[mpals22]

Hi! The duration code should be P5D for 5 days. The T code is only needed if you are doing anything less then a day. 

The duration is in ISO 8601 format. An explanation of the format can be found on Wikipedia, under the Durations section. For example, "P3Y6M4DT12H30M5S" represents a duration of "three years, six months, four days, twelve hours, thirty minutes, and five seconds". P2W is two weeks, P2D is two days, PT4H is four hours.

[mpals22]

Hi! The duration code should be P2D for 2 days. The T code is only needed if you are doing anything less then a day. 

The duration is in ISO 8601 format. An explanation of the format can be found on Wikipedia, under the Durations section. For example, "P3Y6M4DT12H30M5S" represents a duration of "three years, six months, four days, twelve hours, thirty minutes, and five seconds". P2W is two weeks, P2D is two days, PT4H is four hours.

[vuhq133]

Thanks this is very helpful. Do you know how can we create an automated flow for follow up email for the recipient(s) that did not respond after a timeout. I tried to do it by adding "Email notification" flow to what you have but it does not have the condition option as to which recipients(that did not respond) need to be followed up.

[mpals22]

@vuhq133 

I have not found a way to do it through Power Automate because this flow marks one response as a completed flow and will stop tracking. So it doesn't check who out of everyone you emailed responded or not. 

There is this article that goes over setting custom flags for recipients along with using VBA code. I would play around with that and the custom flags. You're able to remind people to reply, like below. 

I hope that helps!

[Anonymous]

Hey my issue is i get the notification even if the email has been replied too, im trying to get the notification only if the email i sent hasn't had a reply

[Anonymous]

hey this is great, my issue is i only want a notification if the email hasn't been replied too, and no notification if it has been replied too! Any ideas, hope this makes sense!