Answered

How to make a scheduled flow run on the 1st and 3rd Monday of each month

(0) Share

Report

Posted on by stacycakes891

Hey there! I have a simple flow that is currently triggered to run weekly, every other Monday but I would like it to run on the 1st and 3rd Monday of each month. It looks like I need to put in a trigger condition but I'm not sure of the formatting, can someone help?

My flow is 2 parts, the recurrence trigger and sending an email.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

mrcwojcik 53 on at

Like (0)

Report
Hello,

so in your trigger you need to go to Settings and there in trigger conditions you should check date. Something like this.

or(equals(dayOfWeek(utcNow(),1)), equals(int(utcNow('dd')),3))

Was this reply helpful? Yes No
stacycakes891 12 on at

Like (0)

Report
Thanks for the quick response @mrcwojcik

I understand the first half of the formula you posted but can you elaborate on this part? I'm not familiar with the DD or what the 3 represents. Much appreciated!

equals(int(utcNow('dd')),3))

Was this reply helpful? Yes No
Suggested answer

SpongYe 5,616 Super User 2025 Season 2 on at

Like (1)

Report
Hi @stacycakes891

To run on the 1st and 3rd Monday of each month you trigger code would look like:

@or( // Check if today is the 1st Monday of the month and( equals(dayOfWeek(utcNow()), 1), // Is today Monday? lessOrEquals(day(utcNow()), 7) // Is today between the 1st and 7th? ), // Check if today is the 3rd Monday of the month and( equals(dayOfWeek(utcNow()), 1), // Is today Monday? greaterOrEquals(day(utcNow()), 15), // Is today the 15th or later? lessOrEquals(day(utcNow()), 21) // Is today the 21st or earlier? ) )

Hope this helps!

Was this reply helpful? Yes No
stacycakes891 12 on at

Like (0)

Report

Thanks for the details @SpongYe

I pasted that into my Trigger Condition but I'm getting an error, should I paste into the Code View? Sorry I'm fairly new to Power Automate so still learning...

What should I change my frequency to? Daily?

This is what I had before:

Was this reply helpful? Yes No
Verified answer

SpongYe 5,616 Super User 2025 Season 2 on at

Like (0)

Report
Under recurrence select the three dots:

Click add trigger conditions and add the code:

@or(and(equals(dayOfWeek(utcNow()),1),lessOrEquals(day(utcNow()),7)),and(equals(dayOfWeek(utcNow()),1),greaterOrEquals(day(utcNow()),15),lessOrEquals(day(utcNow()),21)))

Was this reply helpful? Yes No