Answered

create a time of day trigger

(0) Share

Report

Posted on by Community Power Pla...

I am looking to trigger an auto-reply for emails after-hours. Each day between 5PM and 9AM but I keep getting a time error. Does anyone know the correct format for this?

All responses (4)

Answers (1)

Community Power Pla... on at

Like (0)

Report

Re: create a time of day trigger

Hello Manuela,

The flow test was successful, thanks. One thing I noticed though was the end time in your example shows T 09:00:00-00:00. Should it be the otherway around T 00:00-09:00:00 for midnight to 9AM?
Verified answer

Community Power Pla... on at

Like (1)

Report
Re: create a time of day trigger

Hello,

I've just tried this out and got it to work - in your Start and End time, you have to provide the date as well as the time. In your case, I would assume you want this to be the current date. You can use dynamic content and formulas for that - the formulas I'm using are utcNow() which gives you the current date, formatDateTime() to format the date and time and concat() to concatenate the current date with the timestamp you want:

I've set Start Time to:
concat(formatDateTime(utcNow(), 'yyyy-MM-dd'), 'T','17:00:00-00:00')
I've set End time to (this adds an extra day to the current date for tomorrow using addDays)
concat(formatDateTime(addDays(utcNow(), 1), 'yyyy-MM-dd'), 'T','09:00:00-00:00')
If you click on Start Time/End Time and select dynamic content and then "Expression" and copy the above formula in the bar, that should work for you.

Your action box will look like this then

If expressions are new to you here's a blog about them:
https://flow.microsoft.com/en-us/blog/use-expressions-in-actions/
Community Power Pla... on at

Like (0)

Report

Re: create a time of day trigger

Hi @Tom_Slosse
There isn't much to it as this is my first time creating one.
Tom_Slosse 1,430 on at

Like (0)

Report

Re: create a time of day trigger

Hey @Anonymous

Can you show us your current set up of your trigger?

Kind regards

Tom