MS Form to Planner: DueDate cannot be earlier than the StartDate

[Barking_Mad1]

Hi,

I have a flow set-up where a Start Date Time and a Due Date Time are generated in MS Planner (Create Task in Planner) from an MS Form.

• Start Date Time is just the current time the flow runs.
• Due Date Time is a date selected by the user in the MS Form before 90 days are then subtracted from it (as we need to start the process 90 days before this date.

This works fine except when the MS Planner Due Date Time (minus the 90 days) is a date calculated before the MS Planner Start Date Time. This generates the following message:

• Schema validation has failed. Validation for field 'DueDate', on entity 'Task' has failed: DueDate cannot be earlier than the StartDate

Does anyone have any suggestions on how to overcome this? Here are my two expressions for the two fields:

• Start Date Time = utcNow()
• Due Date Time = addDays(outputs('Collates_all_the_Return_Form_details')?['body/r32b3f83f2db64a07a1d1b3cae0f4fccf'],-90,'dd-MMM-yy')

Thanks 🙂

[abm]

Hi @Barking_Mad1 

Believe your addDays() expression date format must be

yyyy-MM-dd

Try the above and let me know.

Thanks

[Barking_Mad1]

Hi,

Thanks for the reply. That makes no difference I'm afraid. I'm pretty sure it's just when it calculates the due date by removing 90 days from the date in the form and it ends up being before the Planner start date. Planner understandably won't allow it.  Ideally Id just like to say to Planner:

if calculated due date (-90 days from MS Form date) < start date then due date == start date

In reality this won't happen very often, but when it does it won't add the MS Form entry to the Plan, which will obviously be an issue.

[abm]

Hi @Barking_Mad1 

Thanks for your reply. Yes I realised that format is for displaying the date in the specified format. So if the due date is less than the start date then by default you will get this error and this is by design. There is no way around for this.

Thanks

[v-yujincui-msft · Accepted solution]

Hi @Barking_Mad1 ,

I agree with what @abm said that DueDate cannot be earlier than the StartDate, this is by design.

In addition, I noticed that you said that: 'Ideally I'd just like to say to Planner: if calculated due date (-90 days from MS Form date) < start date then due date == start date'.

Maybe you could consider adding a condition Action, I have made a test for your reference.

1. Here is my MS Form.

2. Here is my Flow.

addDays(outputs('Get_response_details')?['body/r8ebd219320044105a057c44589134ff7'],-90,'yyyy-MM-dd')

formatDateTime(utcNow(),'yyyy-MM-dd')

Result Screenshot:

Best Regards,

Charlie Choi

[Barking_Mad1]

Hi,

Thanks for that - that's a nice way round the problem 🙂