Answered

Planner Task Update fails when Start Date is set to today

(0) Share

Report

Posted on by Community Power Pla...

I'm running into this issue and I'm not sure how to address it. When users submit a form response, the Start Date on a task in Planner is set to the day the form was submitted. On the form, they pick a date when their request needs to be actioned by, so I've used Flow to update the task due date to match what they selected. Planner is actually setting the due date to the selected date, minus 1 day.

I am OK with this as it means we get the reminder emails from Planner that we have tasks coming due soon a little earlier. However, if the user picks the date on form for the day they're submitting it (even though they're told not to, as we need 48 hours notice... sigh), the Flow fails as the task Due Date cannot be set earlier than the task Start Date, as Planner keeps setting the Due Date as the date the user picked minus 1 day.

Is there a way to either make Planner not set subtract 1 day from the Due Date to prevent this (not ideal), or for it to calculate that the Due Date is equal to the start date and automatically add a day to the Due Date to prevent the error?

Thanks!

All responses (4)

Answers (1)

v-litu-msft on at

Like (0)

Report

Re: Planner Task Update fails when Start Date is set to today

Hi @Anonymous,

OK, you could create a condition action to determine the submitted date if equals Start Date.

If it equals, add 1 day, or not add.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Power Pla... on at

Like (0)

Report

Re: Planner Task Update fails when Start Date is set to today

Thanks, that helps me add a day onto the Due Date. However, I only want that to happen when the date the form was submitted matches the Start Date on the task, not every time.
Verified answer

v-litu-msft on at

Like (1)

Report
Re: Planner Task Update fails when Start Date is set to today

Hi @Anonymous,

You could use the addDays() function to add one day based on the due date in case Planner subtract 1 day, for example:

addDays('2020-10-01',1,'yyyy-MM-ddThh:mm:ssZ')

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Power Pla... on at

Like (0)

Report

Re: Planner Task Update fails when Start Date is set to today

To add some more context:

The start date time is set as follows:

The Due Date is set in another step, to a substring from the email notification body that contains the date the user selected. The data that it enters into the 'Due Date Time' field is the user selected date in the format: YYYY-MM-DD. Here's a screenshot of one of the failures: