Unanswered

Get a push notification at 05:30 in the morning if I have received any emails during the night

(0) Share

Report

Posted on by E_G

We have a situation that a person wants to be woken up at 05:30 if a certain mail box has recieved any new emails during the night. Is this possible with flow, if so how?

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

v-yuazh-msft on at

Like (1)

Report
Hi @ E_G,

Do you want to get a notification at 05:30 everyday if there are new emails arrive during the night?

Please refer to screenshot below to run the flow at 05:30 everyday to check if there are new emails arrive during the night, if there are new emails arrive during the night,send a mobile notification to the user:

The expression in the condition as below:

@greater(length(body('Get_emails')), 0)

The flow would run successfully to send a mobile notification to the user if there are new emails arrive during the night as screenshot below:

Regards,
Alice Zhang

Was this reply helpful? Yes No
E_G 15 on at

Like (0)

Report

Thank you very much for your response. Would this flow take into account if for example you were to leave a message unread that arrived at 22:00 the same evening? Or does it only take into account the last 10 messages that are unread regardless when they were delivered?

Was this reply helpful? Yes No
Verified answer

vecerpa 786 on at

Like (1)

Report
Hi @E_G,

Solution provided by @v-yuazh-msft is taking 10 latest unread messages that are in "Inbox" folder. No validation against time when they arrived. If you need so, there is needed to add one more condition to validate it. So finall Flow will looks like this:

The formula in condition looks like this:
@greaterOrEquals(items('Apply_to_each')?['DateTimeReceived'],addhours(utcNow(),-8))
In this case the time is utcnow() that means 5;30 - 8hours that means 21:30 to make it simplier.

When there is met this condition then I'm setting help variable "isTrue" to true, variable is boolean. And after this loop I'm checking this variable and if it is true then I'm sending notification, if not nothing happen.

Hope this is helpful.
P.

Was this reply helpful? Yes No
E_G 15 on at

Like (0)

Report

What an incredible forum, you just get the working solution served without doing any work 🙂 I will test this proposed solution asap. Thanks!

Was this reply helpful? Yes No
v-yuazh-msft on at

Like (0)

Report

Hi @ E_G,

Have take a try to test it on your side?

Please let me know if your issue could be solved.

Regards,
Alice Zhang

Was this reply helpful? Yes No
E_G 15 on at

Like (0)

Report

I believe I have it working now. Do you know if the variables one is comparing against, datetimereceived for example, is also in UTC or do I need to make corrections for time zones and DST etc?

Was this reply helpful? Yes No