Error copying checklist from Planner into newly created Task

[bbpa]

The logic is straightforward in that I use the "Get Task Details" action to get the details for my template task (I filter the tasks from Get Tasks and know it's working properly) and then attempt to set the Checklist array as the checklist in my newly created task using Update Task Details.

The error I receive is "The 'inputs.parameters' of workflow operation 'Update_task_details' of type 'OpenApiConnection' is not valid. Error details: The API operation 'UpdateTaskDetails_V2' is missing required property 'body/checklist/0/title'."

The action seems to be looking for a title property in the wrong place. 

Has anybody been able to copy checklists in Planner successfully?

Here is the Checklist object

[
  {
    "id": "10011",
    "value": {
      "@odata.type": "#microsoft.graph.plannerChecklistItem",
      "isChecked": false,
      "title": "Executing: SME content received: Content, quiz questions/answers, etc. ",
      "orderHint": "858606854jW",
      "lastModifiedDateTime": "2021-02-23T15:55:14.1311887Z",
      "lastModifiedBy": {
        "user": {
          "displayName": null,
          "id": "aac56acb-2866-464c-867b-2882ca76f6e8"
        }
      }
    }
  },
  {
    "id": "20794",
    "value": {
      "@odata.type": "#microsoft.graph.plannerChecklistItem",
      "isChecked": false,
      "title": "Closing: Conducted after-action review with project team, share lessons learned",
      "orderHint": "8586068544;",
      "lastModifiedDateTime": "2021-02-23T15:55:14.1311887Z",
      "lastModifiedBy": {
        "user": {
          "displayName": null,
          "id": "aac56acb-2866-464c-867b-2882ca76f6e8"
        }
      }
    }
  },
  {
    "id": "23637",
    "value": {
      "@odata.type": "#microsoft.graph.plannerChecklistItem",
      "isChecked": false,
      "title": "Executing: Final review completed: show stoppers, QA, bias, legal (when needed)",
      "orderHint": "858606854=@",
      "lastModifiedDateTime": "2021-02-23T15:55:14.1311887Z",
      "lastModifiedBy": {
        "user": {
          "displayName": null,
          "id": "aac56acb-2866-464c-867b-2882ca76f6e8"
        }
      }
    }
  },
  {
    "id": "25322",
    "value": {
      "@odata.type": "#microsoft.graph.plannerChecklistItem",
      "isChecked": false,
      "title": "Executing: Delivered/Assigned learning products, including knowledge checks and surveys",
      "orderHint": "8586068548p6",
      "lastModifiedDateTime": "2021-02-23T15:55:14.1311887Z",
      "lastModifiedBy": {
        "user": {
          "displayName": null,
          "id": "aac56acb-2866-464c-867b-2882ca76f6e8"
        }
      }
    }
  },
  {
    "id": "33505",
    "value": {
      "@odata.type": "#microsoft.graph.plannerChecklistItem",
      "isChecked": false,
      "title": "Executing: Conducted feedback reviews of learning products",
      "orderHint": "858606854Ek",
      "lastModifiedDateTime": "2021-02-23T15:55:14.1311887Z",
      "lastModifiedBy": {
        "user": {
          "displayName": null,
          "id": "aac56acb-2866-464c-867b-2882ca76f6e8"
        }
      }
    }
  },
  {
    "id": "34834",
    "value": {
      "@odata.type": "#microsoft.graph.plannerChecklistItem",
      "isChecked": false,
      "title": "Planning: Communication plan, Stakeholder engagement",
      "orderHint": "8586068552QF",
      "lastModifiedDateTime": "2021-02-23T15:55:14.1311887Z",
      "lastModifiedBy": {
        "user": {
          "displayName": null,
          "id": "aac56acb-2866-464c-867b-2882ca76f6e8"
        }
      }
    }
  },
  {
    "id": "35231",
    "value": {
      "@odata.type": "#microsoft.graph.plannerChecklistItem",
      "isChecked": false,
      "title": "Closing: Learning teammates document project outcomes to goals and yearly performance ",
      "orderHint": "858604B",
      "lastModifiedDateTime": "2021-02-23T15:55:14.1311887Z",
      "lastModifiedBy": {
        "user": {
          "displayName": null,
          "id": "aac56acb-2866-464c-867b-2882ca76f6e8"
        }
      }
    }
  },
  {
    "id": "38385",
    "value": {
      "@odata.type": "#microsoft.graph.plannerChecklistItem",
      "isChecked": false,
      "title": "Initiating: Identified Goals/Objectives",
      "orderHint": "8586068552|W",
      "lastModifiedDateTime": "2021-02-23T15:55:14.1311887Z",
      "lastModifiedBy": {
        "user": {
          "displayName": null,
          "id": "aac56acb-2866-464c-867b-2882ca76f6e8"
        }
      }
    }
  },
  {
    "id": "43160",
    "value": {
      "@odata.type": "#microsoft.graph.plannerChecklistItem",
      "isChecked": false,
      "title": "Initiating: Identified Decision Maker and SMEs",
      "orderHint": "ZO",
      "lastModifiedDateTime": "2021-02-23T15:55:14.1311887Z",
      "lastModifiedBy": {
        "user": {
          "displayName": null,
          "id": "aac56acb-2866-464c-867b-2882ca76f6e8"
        }
      }
    }
  },
  {
    "id": "51873",
    "value": {
      "@odata.type": "#microsoft.graph.plannerChecklistItem",
      "isChecked": false,
      "title": "Monitoring: Reported attendance, completions, survey results",
      "orderHint": "8586068547t4",
      "lastModifiedDateTime": "2021-02-23T15:55:14.1311887Z",
      "lastModifiedBy": {
        "user": {
          "displayName": null,
          "id": "aac56acb-2866-464c-867b-2882ca76f6e8"
        }
      }
    }
  },
  {
    "id": "53203",
    "value": {
      "@odata.type": "#microsoft.graph.plannerChecklistItem",
      "isChecked": false,
      "title": "Monitoring: Analyzed for trends in learning, look for gaps or needed boosters",
      "orderHint": "8586068546n",
      "lastModifiedDateTime": "2021-02-23T15:55:14.1311887Z",
      "lastModifiedBy": {
        "user": {
          "displayName": null,
          "id": "aac56acb-2866-464c-867b-2882ca76f6e8"
        }
      }
    }
  },
  {
    "id": "61538",
    "value": {
      "@odata.type": "#microsoft.graph.plannerChecklistItem",
      "isChecked": false,
      "title": "Executing: Sent appropriate communication/invites ",
      "orderHint": "858606854:%",
      "lastModifiedDateTime": "2021-02-23T15:55:14.1311887Z",
      "lastModifiedBy": {
        "user": {
          "displayName": null,
          "id": "aac56acb-2866-464c-867b-2882ca76f6e8"
        }
      }
    }
  },
  {
    "id": "61599",
    "value": {
      "@odata.type": "#microsoft.graph.plannerChecklistItem",
      "isChecked": false,
      "title": "Planning: Determined metrics to be measured and how/when the project ends",
      "orderHint": "858606854z:",
      "lastModifiedDateTime": "2021-02-23T15:55:14.1311887Z",
      "lastModifiedBy": {
        "user": {
          "displayName": null,
          "id": "aac56acb-2866-464c-867b-2882ca76f6e8"
        }
      }
    }
  },
  {
    "id": "70000",
    "value": {
      "@odata.type": "#microsoft.graph.plannerChecklistItem",
      "isChecked": false,
      "title": "Planning: Established MS Team structure, file storage, daily comm, live meeting cadence",
      "orderHint": "8586068551w<",
      "lastModifiedDateTime": "2021-02-23T15:55:14.1311887Z",
      "lastModifiedBy": {
        "user": {
          "displayName": null,
          "id": "aac56acb-2866-464c-867b-2882ca76f6e8"
        }
      }
    }
  },
  {
    "id": "71514",
    "value": {
      "@odata.type": "#microsoft.graph.plannerChecklistItem",
      "isChecked": false,
      "title": "Planning: Design Plan approved, list deliverables",
      "orderHint": "8586068552c5",
      "lastModifiedDateTime": "2021-02-23T15:55:14.1311887Z",
      "lastModifiedBy": {
        "user": {
          "displayName": null,
          "id": "aac56acb-2866-464c-867b-2882ca76f6e8"
        }
      }
    }
  },
  {
    "id": "73063",
    "value": {
      "@odata.type": "#microsoft.graph.plannerChecklistItem",
      "isChecked": false,
      "title": "Executing: Produced learning products: elearning, live content/platform, videos, surveys, etc.",
      "orderHint": "858606854U%",
      "lastModifiedDateTime": "2021-02-23T15:55:14.1311887Z",
      "lastModifiedBy": {
        "user": {
          "displayName": null,
          "id": "aac56acb-2866-464c-867b-2882ca76f6e8"
        }
      }
    }
  },
  {
    "id": "74342",
    "value": {
      "@odata.type": "#microsoft.graph.plannerChecklistItem",
      "isChecked": false,
      "title": "Planning: Learning Plan proposal approved",
      "orderHint": "8586068552s7",
      "lastModifiedDateTime": "2021-02-23T15:55:14.1311887Z",
      "lastModifiedBy": {
        "user": {
          "displayName": null,
          "id": "aac56acb-2866-464c-867b-2882ca76f6e8"
        }
      }
    }
  },
  {
    "id": "79138",
    "value": {
      "@odata.type": "#microsoft.graph.plannerChecklistItem",
      "isChecked": false,
      "title": "Initiating: Assigned Learning teammates (TTM/ID)",
      "orderHint": "uh",
      "lastModifiedDateTime": "2021-02-23T15:55:14.1311887Z",
      "lastModifiedBy": {
        "user": {
          "displayName": null,
          "id": "aac56acb-2866-464c-867b-2882ca76f6e8"
        }
      }
    }
  },
  {
    "id": "80380",
    "value": {
      "@odata.type": "#microsoft.graph.plannerChecklistItem",
      "isChecked": false,
      "title": "Initiating: Stakeholder Interviews and Existing Content",
      "orderHint": "@;",
      "lastModifiedDateTime": "2021-02-23T15:55:14.1311887Z",
      "lastModifiedBy": {
        "user": {
          "displayName": null,
          "id": "aac56acb-2866-464c-867b-2882ca76f6e8"
        }
      }
    }
  },
  {
    "id": "97838",
    "value": {
      "@odata.type": "#microsoft.graph.plannerChecklistItem",
      "isChecked": false,
      "title": "Closing: Analyzed metrics for business value creation",
      "orderHint": "8586068542S",
      "lastModifiedDateTime": "2021-02-23T15:55:14.1311887Z",
      "lastModifiedBy": {
        "user": {
          "displayName": null,
          "id": "aac56acb-2866-464c-867b-2882ca76f6e8"
        }
      }
    }
  }
]

[bbpa · Accepted solution]

The error message led me to rebuilding the JSON in a format that the update action would play nice with. 

This is driven from a MS Form submission which is where the Title comes from in "Create a task 2" also the References Resource in "Update Task Details"

One thing to note is I'm not sure how to keep the checklist in the proper order... even if the source template is created in a certain order the orderHint value doesn't seem to reference it

[v-litu-msft]

Hi @bbpa,

Has your problem been solved?
If your problem has been solved, You could go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

Best Regards,
Community Support Team _ Lin Tu

[edugrt]

Hello, @bbpa 

This is exacly the problem I am facing right now. I understand you shared your solution but I cannot reproduce it because a few steps are missing from the screenshots you've shared (which I am not sure they are relevant anyway) and I cannot see the full schema from the parce JSON.

Would you share those with us, please?

Thanks!

[bbpa]

I updated my screenshots with the extra steps (some are important) and here's the JSON schema... I got it by examining the data from the Checklist object 

{

    "type": "object",

    "properties": {

        "id": {

            "type": "string"

        },

        "title": {

            "type": "string"

        },

        "value": {

            "type": "object",

            "properties": {

                "@@odata.type": {

                    "type": "string"

                },

                "lastModifiedDateTime": {

                    "type": "string"

                },

                "lastModifiedBy": {

                    "type": "object",

                    "properties": {

                        "user": {

                            "type": "object",

                            "properties": {

                                "displayName": {},

                                "id": {

                                    "type": "string"

                                }

                            }

                        }

                    }

                }

            }

        }

    }

}

[lnoman]

Hello @bbpa ,

While I'm using 'Update Task Details' I'm getting the following error:

The request is invalid:
An unexpected 'StartObject' node was found for property named 'lastModifiedBy' when reading from the JSON reader. A 'PrimitiveValue' node was expected.

Here is the raw input:

{
     "body": {
        "description": "2.12.1.3.2",
        "checklist": {
            "28451": {
                "@odata.type": "#microsoft.graph.plannerChecklistItem",
                "isChecked": false,
                "title": "Test",
                "orderHint": "8585863207722652781PM",
                "lastModifiedDateTime": "2021-03-09T10:36:13.2279249Z",
                "lastModifiedBy": {
                    "user": {
                        "displayName": null,
                        "id": "3d8364eb-8e45-474a-8758-2c6d2bb0033f"
                    }
                }
            }
        }
    }
}

My Flow was built straight forward, with no customs fields other than 'Dynamic Contents' so I can't understand why I'm receiving this error. Could you bring me some light? Thank you in advance.

[bbpa]

It looks like maybe you're trying to pass in a value for the lastModifiedBy field? Perhaps leaving that out of your action would help

[lnoman]

Hello @bbpa, thanks for your response.

I share my flow below. Actually, I'm not trying to pass any value to this field.

If I try to put on checklist the following, it returns the error: The execution of template action 'Apply_to_each_2' failed: the result of the evaluation of 'foreach' expression '@body('Get_task_details_from_Template_Task')?['checklist']' is of type 'Object'. The result must be a valid array.

Any sugestions? Thank you.