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?
Solved! Go to Solution.
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
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
P3D will only time out after 3 days
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!
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
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
P3D will only time out after 3 days
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!
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!
User | Count |
---|---|
98 | |
40 | |
27 | |
23 | |
16 |
User | Count |
---|---|
130 | |
52 | |
48 | |
36 | |
24 |