cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
milo1234
Helper III
Helper III

Add a planner task due date that excludes weekends

can someone help with my flow please? 

I have a due date set to 3 days from the start date however I want it to exclude weekends. 

This is my flow:

 

milo1234_0-1622639761755.png

milo1234_1-1622639769505.png

 

milo1234_2-1622639778979.png

 

milo1234_3-1622639784793.png

 

 

 

 

5 REPLIES 5
Rahber
Super User
Super User

there is this function which is called dayOfWeek . if day of week is 0 or 6 that means its Saturday and Sunday.

 

So when you get today and the next 3 days having 0 or 6 in them you add 1 or 2 days depending on the value you get from dayOfWeek.

 

Example

Today is Friday that means its day of week 5 so this means you need to add 5 days instead of 3

 

Please click Accept as Solution if it resolved your problem or give it a Thumbs Up if it helped you in anyway this will allow other people to search correct solutions effectively.

Thanks,
Rahber

milo1234
Helper III
Helper III

Hi @Rahber thank you for this. Are you able to incorporate this into my current flow please as I am a beginner with Power Automate? It would be much appreciated. 

 

Before you create a task. Add a multi condition if. and use these conditions.

 

(dayOfWeek = 3 or 6 add 4 days OR if dayofWeek is 4 or 5 add 5 days else add 3 days) 

 

Please click Accept as Solution if it resolved your problem or give it a Thumbs Up if it helped you in anyway this will allow other people to search correct solutions effectively.

Thanks,
Rahber

@Rahber Sorry this doesn't help me much. Would you be able to mock up a quick example please? 

milo1234
Helper III
Helper III

@Rahber I have done this another way where you add 5 days if received date equals to 3 (Wednesday), and add 4 days if received date equals to 4 (Thursday), else add 3 days. 

 

I am getting an error message however not sure how to resolve - please find attached.

 

evidence2.pngevidenc.png

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.

Users online (1,200)