Answered

Flow updates Planner with responses to Form: I want to set the deadline to 3 working days away.

(0) Share

Report

Posted on by ShaunSmith

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 🙂

All responses (2)

Answers (1)

ShaunSmith 6 on at

Like (0)

Report

Re: Flow updates Planner with responses to Form: I want to set the deadline to 3 working days away.

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!
Verified answer

v-bacao-msft on at

Like (0)

Report
Re: Flow updates Planner with responses to Form: I want to set the deadline to 3 working days away.

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,

Community site session details

Flow updates Planner with responses to Form: I want to set the deadline to 3 working days away.

Helpful resources

News and Announcements

Quick Links

Paul Stork – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Leaderboard > Power Automate

Featured topics

Product updates

Community site session details

Flow updates Planner with responses to Form: I want to set the deadline to 3 working days away.

Helpful resources

News and Announcements

Quick Links

Paul Stork – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate

Featured topics

Product updates