web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / create a time of day t...
Power Automate
Answered

create a time of day trigger

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

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?

Categories:
  • Tom_Slosse Profile Picture
    1,430 on at

    Hey @Anonymous 

     

     

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

     

    Kind regards

     

     

    Tom

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hi @Tom_Slosse 

    There isn't much to it as this is my first time creating one.

    sample.JPG

  • Verified answer
    Community Power Platform Member Profile Picture
    Microsoft Employee on at

    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

    image.png

     

    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 Platform Member Profile Picture
    Microsoft Employee on at

    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?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 273 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 235

#3
David_MA Profile Picture

David_MA 172 Super User 2026 Season 2

Last 30 days Overall leaderboard