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

Notifications

Announcements

Community site session details

Community site session details

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

create a time of day trigger

(0) ShareShare
ReportReport
Posted on by

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:
I have the same question (0)
  • 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
    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
    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
    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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 538 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 405 Moderator

#3
abm abm Profile Picture

abm abm 252 Most Valuable Professional

Last 30 days Overall leaderboard