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 / Flow to trigger Dynami...
Power Automate
Unanswered

Flow to trigger Dynamics 365 workflow one x per year - How to write date string?

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Creating a Flow to run daily, check today's date, if does not equal January 1st, end workflow. If equals January 1st, continue Flow. What is the date/string formula to check against to make this run?

Categories:
I have the same question (0)
  • AlanPs1 Profile Picture
    2,471 on at

    Hi @Anonymous , thank you for posting in the Flow Community Forum!

    Here is how I would address this below:Capture-489.png

    The "Compose DateTime" is a simulation of 1st January this year.

    I format it to "01-01" format (MM-dd).

    I match it to string for the same "01-01".

     

    This will retrun true if January the 1st so if you set the condition up after your recurrence this should meet your needs.

     

    If you have found my post helpful, please mark thumbs up.

     

    Any other questions, just ask.

     

    Thanks, Alan

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Alan, thanks. I've entered the flow as you mention. I continue to return this error upon saving flow.

    flow.jpg

    Thoughts?

     

    Carrie

  • AlanPs1 Profile Picture
    2,471 on at

    Hi @Anonymous (Carrie).

    Sorry about the confusion but what I am doing is "simulating" the date hence the use of the "Compose" called "Compose DateTime". You will need to cahnge to wherever you are getting your date from, you haven't mentioned that in your post hence my simulation.

     

    Please see your error:Capture-490.png

    It says ... "Compose_DateTime ... not defined in the template"

    So you need to change:

    formatDateTime(outputs('Compose_DateTime'), 'MM-dd')

    to ....

    formatDateTime(<The name of your dynamics attribute with date>, 'MM-dd')

     

    If you find my posts helpful, please mark thumbs up.

    If these posts make up the solution, please click, "accept as solution".

     

    Any other questions, just ask.

     

    Thanks, Alan

  • v-bacao-msft Profile Picture
    Microsoft Employee on at

    Hi @Anonymous ,

     

    Please use Recurrence as the trigger, set the cycle to run Flow once a day.

    Check if the current date is equal to January 1, use the following Expression to get the current date and determine if it is ‘01-01’.

    Expression reference:

    utcNow('MM-dd')

    Image reference:

    8.PNG

     

    Please take a try.

     

    Best Regards,

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 262 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 227

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard