cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
robthompson
New Member

Send Email X days before first Monday

I would like to automate an MS365 email to go out a specific number of days (3) before the 1st Monday of each month. 

 

Another example, i'd like to send an email 3 days before the 3rd Thursday of each Month. 

 

I have other examples, but hopefully you understand the concept of what I'm trying to do.

 

I've googled and tested, and I just can't figure this out.  Can you help?

1 ACCEPTED SOLUTION

Accepted Solutions
v-xiaochen-msft
Community Support
Community Support

Hi @robthompson ,

 

I did a test for you to get the first Monday of each month. 

It should be noted that my solution does not consider the time zone.

vxiaochenmsft_0-1634549883541.png

startOfMonth(utcNow())

 

vxiaochenmsft_3-1634549998694.png

dayOfWeek(variables('Var'))
dayOfWeek(variables('Var'))
addDays(variables('Var'),1)

 

vxiaochenmsft_4-1634550058394.png

 

Best Regards,

Wearsky

 

 

 

 

 

View solution in original post

1 REPLY 1
v-xiaochen-msft
Community Support
Community Support

Hi @robthompson ,

 

I did a test for you to get the first Monday of each month. 

It should be noted that my solution does not consider the time zone.

vxiaochenmsft_0-1634549883541.png

startOfMonth(utcNow())

 

vxiaochenmsft_3-1634549998694.png

dayOfWeek(variables('Var'))
dayOfWeek(variables('Var'))
addDays(variables('Var'),1)

 

vxiaochenmsft_4-1634550058394.png

 

Best Regards,

Wearsky

 

 

 

 

 

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Users online (3,278)