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 🙂
Solved! Go to Solution.
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:
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,
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:
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,
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!
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
77 | |
26 | |
20 | |
16 | |
16 |
User | Count |
---|---|
145 | |
44 | |
44 | |
33 | |
30 |