Answered

Adding Multiple Checklist items to Planner

(0) Share

Report

Posted on by jslsmithyx

Hi guys,

I've recently noticed that Microsoft have added the ability to create checklist items on Planner with Flow... I'm just looking for some guidance / documentation on how this works? I think its a fairly recent addition, so cannot find anything online thus far:

I have a SharePoint multi line column. The items I would like creating into a checklist are stored here, each separated by a ';' (checklistitem1;checklistitem2;checklistitem3;). I would like to create a checklist item for each item after the ;

I imagine this will be done with some sort of array, as I have used a similar technique to attach multiple list attachments onto an email however I'm not sure how to tweak that to suit the checklist solution

Any help on the solution would be appreciated, thank you!

Joe

Categories:

Using flows

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Verified answer

v-yiwenxie-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @jslsmithyx

In my understanding, you want to create a checklist item for each item after the “;” for only one cell in a sharepoint multi line column.

For example, the cell is as below:

I’ve created a flow to meet your need.

I’ve used split() and item() function.
For more info about split(), please go to the link: Reference guide for functions in expressions - Azure Logic Apps | Microsoft Docs
For more info about item(), please go to the link: Reference guide for functions in expressions - Azure Logic Apps | Microsoft Docs

The whole flow is as below:

The detailed steps are as below:

For the ‘checklists’ array variable, the “Id”, “Title”, “IsChecked” are required. Otherwise, the flow will fail.

The functions used are:
split(outputs('Get_item')?['body/ChecklistItems'],';')
item()

For the split function, ChecklistItems is an example, you should fill the column name of yours.

This is the outcome of the flow:

Best Regards,
Community Support Team _ Kira Xie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
jslsmithyx 97 on at

Like (0)

Report
Copy link

Link copied!

Great! Thanks for the info. I'll put this together & get back to you.

Was this reply helpful? Yes No
jslsmithyx 97 on at

Like (0)

Report
Copy link

Link copied!

Hi,
Just trying to put your suggestion together. I have used 'Get Items' rather than 'Get Item' & when it comes to the 'Compose' operation I do not have the option to split the 'ChecklistItem' Output:

Not a huge problem, as I can tweak my solution to work of 'Get Item' rather than 'Get Items' with a Filter Query - but if it can work of 'Get Items' with a filter, that would be ideal..

Any ideas?

Thanks

Was this reply helpful? Yes No
jslsmithyx 97 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-yiwenxie-msft

Your solution worked perfectly - thank you.

Was this reply helpful? Yes No
Rama96x 149 on at

Like (0)

Report
Copy link

Link copied!

Hey, would this flow also work in Excel? I have the same issue where I'm storing planner tasks in an Excel table but as soon as someone adds checklist items, it creates several rows with the items

Was this reply helpful? Yes No
Falcon60 2 on at

Like (0)

Report
Copy link

Link copied!

Hello, Impressive knowledge you show. I am not at your level but have tried to implement the script into my existing script. In this connection, I get the following error message (ref attachment). Is there an easy fix for this?

Was this reply helpful? Yes No