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 / Auto-reply for specifi...
Power Automate
Answered

Auto-reply for specific dates

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

We have created a flow for holidays that we turn on when one is upcoming. We have run into an issue though as we have made the flow too simplistic I suspect.  We have set the trigger to be a day of the week which the holiday happens to fall on and simply turn the flow on the day before, but this is causing the flow to trigger on emails already in the inbox which were there from previous Wednesdays in this case.  Is there a variable we can put in here for a specific date, say December 25 2020 instead of 'day'?

Micah_0-1605728282916.png

 

Categories:
I have the same question (0)
  • Verified answer
    Expiscornovus Profile Picture
    33,933 Most Valuable Professional on at

    Hi @Anonymous,

     

    I suspect you already use a formatDateTime function since you have a variable called day?

     

    You could use a different format:

     

     

    formatDateTime(utcNow(), 'M')

     

     

    The output of this format is like this:

    formatdatetime_M.png

     

    Other date time formats can be found over here:

    https://docs.microsoft.com/en-us/dotnet/standard/base-types/standard-date-and-time-format-strings

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Thanks for the assist Espiscornovus.  I honestly don't know a whole lot about flows but you lead me in the right direction.  I was able to work with a co-worker to change the format of our day variable to include a full date instead of just the day format.

     

    Sincerest thanks.

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

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 229 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 227

#3
Haque Profile Picture

Haque 181

Last 30 days Overall leaderboard