Unanswered

Recurring tasks only weekday

(0) Share

Report

Posted on by WoodE1735

Hello!

Currently, I have setup a monthly recurrence that will populate several tasks using Planner in Teams. The recurrence triggers on the 1st of each month, but each task under it populates on a different day. To do this I used the following example formula for the start and due date under the tasks:

addDays((utcNow(), 14)

This makes the task populate in the 15th of the month, since the flow triggers on the 1st.

I would like to have a way for it to not populate on weekends. For example, if the 15th is a Saturday, I would want the task you populate on the 14th instead (Friday). Is this possible by adding to the current formula above? Is there a better formula all together? Please advise!

Thank you.

Categories:

Power Automate Mobile App

I have the same question (0)

All responses (3)

Answers (0)

Kaif_Siddique 2,108 Super User 2024 Season 1 on at

Like (0)

Report

As recurrence triggers on the 1st of each month, there may be possibility that 1st day of the month would be weekend(Saturday or Sunday).

I would suggest create an excel file and save the recurrence trigger date in one column till end date. Next create a recurrence trigger and set the interval day and compare with recurrence trigger date saved in excel with the current date. If the condition is met continue the flow else end flow.

Hope this will help you.

Was this reply helpful? Yes No
Not-a-bot 6 on at

Like (0)

Report

You could have it test what day is 14 days away, then yes/no fork to a day equals Monday-Friday do the thing for that day, day not equals Monday-Friday fork again, day equals Saturday do the thing for -1 day (Friday), day not equals Saturday (must be Sunday) do the thing -2 days (Friday) or +1 day (Monday).
Could get a bit long with forking if you have a single flow doing this for many tasks, but should give you a programmatical way of using this Flow no matter what year it is and what days the dates fall upon.

Was this reply helpful? Yes No
_Ken 120 on at

Like (0)

Report

Several ways to achieve this using dayOfWeek() to test your date.
Note: 0=Sunday, 1=Monday....., 6=Saturday

You could build this into a nested if statement, but a simpler graphical method is to use a Switch action.

Simply initialise a string variable with your calculated date
Test if dayOfWeek() is 0 or 6
Then set the variable accordingly
Sample below calculates next Monday, so add days -1 or -2 if you need the Friday instead
The Default switch does nothing, so you retain the date set when variable is initialised.

Hope this makes sense.

Was this reply helpful? Yes No