URGENT - Automatically setting Planner Due Date to skip weekends

[Anonymous]

Hi, I have a functioning flow which creates a Planner task when an Outlook email is flagged.

This automatically populates the 'Start Date' to the date of when the email was received and the 'Due Date' to be 3 days from the 'Start Date'. 

However I need my flow to skip weekends if this falls on the 3 day period and go to the next working day. 

I have no idea how to do this - any help would be appreciated. 

Due Date Time Expression: 

addDays(outputs('Compose'),3,'yyyy-MM-dd')

[kaitogoto]

I suggest this:

1) Use the dayOfWeek(addDays(outputs('Compose'),3,'yyyy-MM-dd')) expression on the compose action (like you have mentioned). This will return 1, 2 and 3 if Due Date is on Monday, Tuesday and Wednesday etc.

2) Use the condition action to test if the date returned by step 1 is equal to 1, 2, 6 or 7. If yes, return Due Date as

dayOfWeek(addDays(outputs('Compose'),5,'yyyy-MM-dd')). If no, continue to Step 3.

3) Use the condition action to test if the date returned by step 1 is equal to 3. If yes, return Due Date as dayOfWeek(addDays(outputs('Compose'),4,'yyyy-MM-dd')). If no, return Due Date as what was returned by Step 1.

[Anonymous]

@kaitogoto thank you for this. Would this step of my flow go before the 'Create a task' as seen in my attachment. 

[Anonymous]

@kaitogoto can you also show what you have put within each 'Compose'. Thank you

[Anonymous]

I have done the following however the flow failed - please can you advise? 

[Anonymous]

1) dayOfWeek(addDays(outputs('Compose'),3,'yyyy-MM-dd')) is create a task and compose 2 is changed to 5, compose 3 is changed to 4, and compose 4 is changed to 3.

[kaitogoto · Accepted solution]

@Anonymous  Thank you for your reply. Firstly, can you please provide what error was returned on Message 5 and for Message 4, I have provided the expressions I used in the "compose" actions on my initial reply. Secondly, I will clarify the logic I used to adjust the due dates: If you want tasks to be due within three working days, the span from start day to end day must "touch" four weekdays. This is why if three days after start day is Monday, Tuesday, Saturday or Sunday, the due date must be pushed further by two days (i.e. five days after start day) because it "touched" both Saturday and Sunday. This was the logic behind step 2 of my initial reply and same logic applies for step 3.
Please accept as the solution if solved, reply with copy of all error messages if not. All the best!