cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Reply
bbpa
Frequent Visitor

Error copying checklist from Planner into newly created Task

‎02-23-2021 10:21 AM

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"
        }
      }
    }
  }
]
Labels:
Message 1 of 8
455 Views
0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
bbpa
Frequent Visitor

‎02-23-2021 01:20 PM

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

Message 2 of 8
435 Views
0 Kudos
7 REPLIES 7
bbpa
Frequent Visitor

‎02-23-2021 01:20 PM

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

Message 2 of 8
436 Views
0 Kudos
v-litu-msft
Community Support
Community Support

‎02-23-2021 09:49 PM

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

Message 3 of 8
425 Views
0 Kudos
edugrt
New Member

‎03-04-2021 05:53 AM

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!

Message 4 of 8
409 Views
0 Kudos
bbpa
Frequent Visitor
In response to edugrt

‎03-04-2021 12:00 PM

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"
                                }
                            }
                        }
                    }
                }
            }
        }
    }
}
Message 5 of 8
405 Views
0 Kudos
lnoman
Frequent Visitor
In response to bbpa

‎04-14-2021 03:43 AM

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.

Message 6 of 8
374 Views
0 Kudos
bbpa
Frequent Visitor
In response to lnoman

‎04-14-2021 10:14 AM

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

Message 7 of 8
348 Views
0 Kudos
lnoman
Frequent Visitor
In response to bbpa

‎04-14-2021 10:59 AM

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.

Message 8 of 8
347 Views
0 Kudos

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power automate tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

View All
Users online (3,139)