Unanswered

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

(0) Share

Report

Posted on by C21

Hi, I have created a flow 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.

The flow works fine until the Due Date Time is the same as the Start Date Time then I get the following message

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

I have tied to learn from previous posts in the community forum that I can use a condition Action to solve this problem. However, I’m struggling to get the condition to work properly. Can anyone help? I’ve currently got the condition set as Converted Time Zone Due Date is less than or equal to Converted Time Zone Submission Time. I’m probably making some obvious error but I’m new to Power Automate and struggling. @v-yujincui-msft you were able to help on the last issue like this. Any ideas?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

rzaneti 4,241 Super User 2025 Season 2 on at

Like (0)

Report

Hi @C21 ,

What exactly is the error that you are receiving in the condition?

Also, I don't know how did you populate the "Create a task" actions inside each condition block, but it looks like in case of your "Converted due date" is less or equal to the "Converted submission date", you would like to create the tasks in the different days, and not in the same.

Was this reply helpful? Yes No
C21 35 on at

Like (0)

Report
Hi @rzaneti , what I want to be able to do is create a Planner task that is automatically pre-populated with the task Due Date (as specified on the form).
However, without the Condition Action if the Due Date specified on the form is the same as the Start Date I get the error “Schema validation has failed. Validation for field 'DueDate', on entity 'Task' has failed: DueDate cannot be earlier than the StartDate”.
Below is a screen shot of the Submission time and Due Date outputs for you.
I want to be able to use the Condition Action say
if the Due Date is the same as the Start Date, create a task where the Due Date and Start Date are the same (i.e. the same date).
Or, if the Due Date is later than the Start Date, create a task where the Start Date is the time the flow runs, and the Due Date is the date as specified on the form.
With the way the flow is set up now I can only get one side of the action to work. I can’t get either side to work depending on the date input. Please see the extract from a Planner task below. The Due Date should be 15 February but its task Due Date is 2 February.
Have I explained this better now?

Was this reply helpful? Yes No
rzaneti 4,241 Super User 2025 Season 2 on at

Like (0)

Report

Hi @C21 ,

Thank you for the additional context!

About this specific flow run where you had a due date of Feb 15, but the flow generated a task due to Feb 2nd, could you please share an image of the "Convert time zone due date" outputs? It's weird, because in the description the task has the information of "Deadline to Feb 15", so technically Power Automate is getting a correct date...

Was this reply helpful? Yes No