Unanswered

Recurring Trigger at specific days of each month

(0) Share

Report

Posted on by diogoalves

Hi,

I need to create a flow that triggers on a specific day of each month throughout the year. Is it possible? If so, how do I do it?

For example, the flow runs on March 13, April 9, May 12, June 6, etc.

Thanks!

Diogo

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

mmollet 3,187 on at

Like (0)

Report

When you create a new flow you can pick a scheduled flow and choose a date for it to run on or a starting date and a repeat date. So start on monday and repeat every 2 weeks etc or start on monday at 8am and repeat every hour etc.

Was this reply helpful? Yes No
diogoalves 10 on at

Like (0)

Report

I get that, but my problem is, I don't want to run the flow "every 2 weeks". This month, I need it to run on the 16th, next month will be on the 6th and so on. AND it's important that it DOESN'T run any other day.

Was this reply helpful? Yes No
mmollet 3,187 on at

Like (0)

Report
Ah. This im not 100% sure on. The only thing off the top of my head is you could have a list of dates that you want it to run in SP.
Every day run the flow to grab the list and sort it by date.
Get the top date (closest to current day) and check if it is the same as today
If it is then run the flow and remove that date from the list
If it isnt then the flow ends and does nothing
Repeat each day
Not sure if that will work for your situation or not but im sure it would work in general. I do something similar to this for reminders

Was this reply helpful? Yes No
Verified answer

v-chengfen-msft on at

Like (3)

Report
Hi @diogoalves ,
Please try to trigger every day, and then set the judgment condition in Trigger condition z: only when today's date meets one of the conditions will it be triggered
@or(equals(utcNow('MM-dd'),'01-16'),
equals(utcNow('MM-dd'),'02-16'),
equals(utcNow('MM-dd'),'03-16'),
equals(utcNow('MM-dd'),'04-16'),
equals(utcNow('MM-dd'),'05-16'),
equals(utcNow('MM-dd'),'06-16'),
equals(utcNow('MM-dd'),'07-16'),
equals(utcNow('MM-dd'),'08-16'),
equals(utcNow('MM-dd'),'09-16'),
equals(utcNow('MM-dd'),'10-16'),
equals(utcNow('MM-dd'),'11-16'),
equals(utcNow('MM-dd'),'12-16'))
Here is a link on how to set the trigger for your reference
Power Automate Trigger Conditions [33 Useful Examples] - SPGuides

Best Regards
Cheng Feng

2 people found this reply helpful.

Was this reply helpful? Yes No
diogoalves 10 on at

Like (0)

Report

Thanks Cheng! I implemented it, and it SEEMS to work. I'll confirm next week after a few tests.

Was this reply helpful? Yes No
diogoalves 10 on at

Like (0)

Report

Confirmed! This solution works for running a flow at specific dates!

Was this reply helpful? Yes No