cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bbpa
Frequent Visitor

Error copying checklist from Planner into newly created Task

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.

bbpa_0-1614104372833.png

bbpa_1-1614104409147.png

 

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"
        }
      }
    }
  }
]
1 ACCEPTED SOLUTION

Accepted Solutions
bbpa
Frequent Visitor

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

bbpa_1-1614887531839.png

 

bbpa_0-1614115144839.png

bbpa_2-1614887549823.png

bbpa_1-1614115173018.png

bbpa_4-1614887681312.png

bbpa_5-1614887734254.png

 

bbpa_3-1614115192951.png

 

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

View solution in original post

7 REPLIES 7
bbpa
Frequent Visitor

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

bbpa_1-1614887531839.png

 

bbpa_0-1614115144839.png

bbpa_2-1614887549823.png

bbpa_1-1614115173018.png

bbpa_4-1614887681312.png

bbpa_5-1614887734254.png

 

bbpa_3-1614115192951.png

 

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

View solution in original post

v-litu-msft
Community Support
Community Support

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
New Member

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
Frequent Visitor

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
Frequent Visitor

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
Frequent Visitor

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
Frequent Visitor

Hello @bbpa, thanks for your response.

 

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

 

lnoman_1-1618422994521.png

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.

lnoman_2-1618423096802.png

 

Any sugestions? Thank you.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Users online (2,983)