Dear all, I would appreciate your advice on how to schedule a flow to run 4 times per year (every quarter) on the following dates:
March,1st
June, 1st
September, 1st
November,1st
So, the complexity I have here is that it needs to run every 3 months for the first 3 quarters of the year (Q1, Q2, Q3), but after 2 months since the last run (Q3) for the last quarter of the year (Q4)
Any suggestion on how to best address this requirement?
Schedule your flow to run every day at the desired time and then add a trigger condition to check if the current date is one of the four days you want it to run:
You would use this expression in the trigger: @or(equals(formatDateTime(utcNow(),'yyyy-MM-dd'), formatDateTime(utcNow(),'yyyy-03-01')), equals(formatDateTime(utcNow(),'yyyy-MM-dd'), formatDateTime(utcNow(),'yyyy-06-01')), equals(formatDateTime(utcNow(),'yyyy-MM-dd'), formatDateTime(utcNow(),'yyyy-09-01')), equals(formatDateTime(utcNow(),'yyyy-MM-dd'), formatDateTime(utcNow(),'yyyy-11-01')))
1 people found this reply helpful.
Was this reply helpful?YesNo
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.
6
Share
Report
All responses (
Answers (
