Setting Multi-Value Lookup Field in another list using spjs.utility.updateItem(

[Mitchell T]

I ran into the problem of not being able to set multi-value lookup field using spjs.utility.updateItem() and stumbled upon the solution and wanted to share as I don’t believe this has been addressed.

Initially I thought something like this would work (but it doesn’t):

spjs.utility.updateItem({
    'listName' : 'GUID of list to be updated',
    'id': 'ID value(s) of items to be updated',
    'data' : {
        'MultiValLookupField' : ['ID1', 'ID2', 'ID3']
    }
)}

However, this is what actually worked:

spjs.utility.updateItem({
    'listName' : 'GUID of list to be updated',
    'id': 'ID value(s) of items to be updated',
    'data' : {
        'MultiValLookupField' : 'ID1;#;#ID2;#;#ID3'
    }
)}

I expected the syntax to be similar to setFieldValue() where you can do:

setFieldValue('MultiValLookupField' , ['ID1', 'ID2' , 'ID3'])

but this was not the case, so be aware of this.

[Alexander Bautz]

Thanks for clarifying this. The format is the same with multiselect lookup columns and multiselect people pickers and the reason for the double ;#;# is that the expected format is like this:

ID_of_item_1;#Label_of_item_1;#ID_of_item_2;#Label_of_item_2;#

The label is however not required and therefore can be left empty.

Alexander

[Author]

Posts