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

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

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

(0) ShareShare
ReportReport
Posted on by

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?

I have the same question (0)
  • AlanPs1 Profile Picture
    2,471 on at
    Re: Flow to trigger Dynamics 365 workflow one x per year - How to write date string?

    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
    on at
    Re: Flow to trigger Dynamics 365 workflow one x per year - How to write date string?

    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
    Re: Flow to trigger Dynamics 365 workflow one x per year - How to write date string?

    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
    on at
    Re: Flow to trigger Dynamics 365 workflow one x per year - How to write date string?

    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

Coming soon: forum hierarchy changes

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
Tomac Profile Picture

Tomac 532 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 461 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 256

Last 30 days Overall leaderboard