You’re offline. This is a read only version of the page.
Hi everyone, I hope someone can help me,
I'm creating a Flow which takes responses to a Form and creates a task in Planner for the relevant team. I want to set it so that it will automatically work out the Due Date as 3 working days away. I know that the 'workday' function from Excel doesn't work so I worked out that all days need to be set to add 3 days except for Wednesday and Thursday which need to add 5 and 4 days respectively. I tried to create the following expression using nested ifs but I keep getting an invalid expression error message:
if(utcNow('dddd')="Wednesday",addDays(outputs('Get_response_details')?['body/submitDate'],5),if(utcNow('dddd')="Thursday",addDays(outputs('Get_response_details')?['body/submitDate'],4),addDays(outputs('Get_response_details')?['body/submitDate'],3)))
Any support I can get with this flow would be highly appreciated.
Cheers in advance 🙂
Hi Barry,
This is brilliant, thank you. I'm quite new to Flow so I'm still not 100% on the difference in syntax between it and Excel. As you mentioned below the expression didn't work directly in the 'Create task' Action, however I was able to put this straight into an Output Action and it works as intended.
For clarification I didn't actually type in 'outputs ('Get_response_details')? ['Body / submitDate']', that is how the dynamic content appeared in the expression when I was trying to input it.
Thanks again for your help!
Hi @ShaunSmith ,
First, the expression does not support the use of "=", you need to use equals() function instead of "=".
Second, you cannot use "" here, you need to use ''.
Please use this expression:
Share
Report
All responses (
Answers (if(equals(utcNow('dddd'),'Wednesday'),addDays(outputs('Get_response_details')?['body/submitDate'],5),if(equals(utcNow('dddd'),'Thursday'),addDays(outputs('Get_response_details')?['body/submitDate'],4),addDays(outputs('Get_response_details')?['body/submitDate'],3)))
In addition, SubmitDate is a problem in Forms? If so, the way you quote this answer in expression seems a bit problematic.
You should be able to get this value directly through Dynamic content, you don't need to get it through outputs ('Get_response_details')? ['Body / submitDate'].
Like:
Then you just need to configure expression with the output of Compose.
Like:
if(equals(utcNow('dddd'),'Wednesday'),addDays(outputs('Compose'),5),if(equals(utcNow('dddd'),'Thursday'),addDays(outputs('Compose'),4),addDays(outputs('Compose'),3)))
Best Regards,
#1
Tomac
986
Moderator
#2
stampcoin
699
Super User 2025 Season 2
#3
Riyaz_riz11
577
Super User 2025 Season 2
