How to add only working days on a flow to set a due date on MS Planner

(0) Share

Report

Posted on by beeswood

Hello

I'm fairly new to Power Automate but I have a flow that sets up a new task on MS Planner and the flow is set up to set a start date of the current date and I then want to set a due date of 2 days from now. Currently I have it set up with the following expression:

addDays(utcNow(), 2)

However we dont work weekends so if a task is created on a Thursday or Friday it will give a due date on the weekend, I want to change it so that on these specific week days it adds 4 days on to take into account saturday and sunday.

I have experimented with an IF expression based on the below:

I tried this using the below expression but kept getting errors and I cant seem to figure out how to write this to make it work

if(dayOfWeek(1,2,3),addDays(utcNow(),2),addDays(utcNow(),4))

Any help would be appreciated

All responses (1)

Answers (1)

Verified answer

tom_riha 10,127 Most Valuable Professional on at

Like (1)

Report

Re: How to add only working days on a flow to set a due date on MS Planner

Hello @beeswood ,

check this solution by @Paulie78 : https://www.tachytelic.net/2022/04/power-automate-flow-add-working-days-date/