Disable checklist entries if empty (Planner Update task details)

[Phil_NPO]

hey everybody,

it is difficult to develop that flow, but step by step. 

Now I have got problems with updating planner task details.

From a sharepoint list i get a checklist with various counts of entries, now stored in a array variable. 

How can I disable checklist entries if they are empty?

In this example I get an error because I only have 4 entries on checklist and the 5th is empty.

[tom_riha · Accepted solution]

Hello @Phil_NPO ,

you can initialize an array variable, loop through all the checklist items from the SharePoint list, and append them into the array in the following format:

{
    "id": "<checklist item ID>",
    "title": "<checklist item title>",
    "isChecked": false
}

Once you have the array ready (after the loop), you can switch the 'Checklist' field to 'input entire array' and use the array variable as an input.

I published an article how to do this just yesterday.

[Phil_NPO]

This is fantastic! Thank you so much!

Your solution works great. 

Now I am trying to use this for my linklist in a planner task details. 

I know the format:

{
                    "alias": "Link 1",
                    "resourceLink": "https://www.test.com",
                    "type": "Other"
                }

Do you know the best way to store this in a sharepoint list? I am using a sharepoint list with many daily tasks. Each item could have links or not. 

I failed to use an array in a string column, because of max 255 lenght. And multiple choice like I use for checklist, cannot include alias, resourcelink and type at the same time. 

[tom_riha]

Hello @Phil_NPO ,

if I understand correctly you want to store all the information in a single SP column. I'd probably do it as a string with 2 separators, for example one separator to separate the values for a single link, and another to separate the various links. For example , and ; like this:

Link 1,https://www.test.com,Other;Link 2,https://www.test2.com,Other;Link 3,https://www.test3.com,Other

You could split such array by the ; to get data for each of the links into an array:

split([theStringFromSharePoint], ';')

that will create an array as below:
[
    {
        "Link 1,https://www.test.com,Other",
        "Link 2,https://www.test2.com,Other",
        "Link 3,https://www.test3.com,Other"
    }
]

Then loop through that array in 'Apply to each' and split it again, this time by , . That would create another array from each of the rows:

split([CurrentItem], ',')

it'll convert the string into another array:
[
    {
        "Link 1",
        "https://www.test.com",
        "Other"
    }
]

Then you can access each of the item by using index within this array, [0], [1], [2] to get the alias, resourceLink and type.

outputs('TheActionWithSplit')[0]
outputs('TheActionWithSplit')[1]
outputs('TheActionWithSplit')[2]