cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ccranberg
Frequent Visitor

Recurrence Email on Weekdays AND Send Weekend Emails on Following Monday

Hello All,

 

I have created a flow that sends automatic email reminders to customers when the current date is 30 days prior to a due date in a Sharepoint table. Currently, I have the Recurrence set to daily; however, I would like tweak it so customers do not receive emails over the weekends. In instances where the current date is 30 days prior to the due date AND the current date is a weekend, I'd like the email to be sent on the preceding Monday. I don't see a way to set this up in recurrence and cannot think of how I would go about doing that with a conditional tree. 

 

Has anyone found a solution for something like this?

1 ACCEPTED SOLUTION

Accepted Solutions
Redders
Continued Contributor
Continued Contributor

Hi @ccranberg,

 

I would set up a switch to delay the email being sent for either 1 or 2 days depending on whether it is Saturday or Sunday with no delay as defauly

 

Redders_0-1666824341314.png

 

Edit: The screenshot shows the delays in the wrong boxes, you should put a 2 day delay for the case that equals 6 (Saturday) and 1 day delay for the case that equals 0 (Sunday)

 

The switch would have the expression

 

 

dayOfWeek(utcNow())

 

 

 

Depending on what is in your flow, you may need to prevent the flow from timing out, just go into settings to see if the action times out

Redders_1-1666824503067.png

 

P3D will only time out after 3 days

 

Redders_2-1666824554918.png

I hope that this helps you, if you liked my response, please consider giving it a 👍If I have answered your , please mark my post as ✔️.

 

Solved questions helps users in the future who may have the same issue or question quickly find a resolution via search. Thank you!

View solution in original post

2 REPLIES 2
Redders
Continued Contributor
Continued Contributor

Hi @ccranberg,

 

I would set up a switch to delay the email being sent for either 1 or 2 days depending on whether it is Saturday or Sunday with no delay as defauly

 

Redders_0-1666824341314.png

 

Edit: The screenshot shows the delays in the wrong boxes, you should put a 2 day delay for the case that equals 6 (Saturday) and 1 day delay for the case that equals 0 (Sunday)

 

The switch would have the expression

 

 

dayOfWeek(utcNow())

 

 

 

Depending on what is in your flow, you may need to prevent the flow from timing out, just go into settings to see if the action times out

Redders_1-1666824503067.png

 

P3D will only time out after 3 days

 

Redders_2-1666824554918.png

I hope that this helps you, if you liked my response, please consider giving it a 👍If I have answered your , please mark my post as ✔️.

 

Solved questions helps users in the future who may have the same issue or question quickly find a resolution via search. Thank you!

ccranberg
Frequent Visitor

Hello, @Redders.

 

This looks exactly like what I needed! I am testing it out over the weekend and will mark your answer as the solution when I verify that emails from Saturday and Sunday were sent on Monday. Thanks again for the help!

 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,820)