Ranjith kumar

Update Multiple Values Lookup  in SharePoint Online

Blog Post created by Ranjith kumar on Jun 6, 2018

Hi All

 

How to Update Multiple Values Select Lookup ?

    We can Update Multiple Values Select Lookup column using REST API in Nintex Workflow

Why Rest ?

   When you are using SharePoint Default Update  Action to update, you will get below error, to avoid this we have use REST API 

 

Error Detail  When use Update List Item Action

 

{"error":{"code":"-1, Microsoft.SharePoint.Client.InvalidClientQueryException","message":{"lang":"en-US","value":"A 'PrimitiveValue' node with non-null value was found when trying to read the value of a navigation property; however, a 'StartArray' node, a 'StartObject' node, or a 'PrimitiveValue' node with null value was expected."}}} Bad Request

 

about  this error you may heard, like Microsoft bug or Nintex  bug we cannot update multi select lookup column in SharePoint online Etc

but  We Can Update 

here you can get the solution for that,

using REST API we can update the Multi select lookup column.

 

 Key Point are 

1)Pass value in array  =  [21,42]

2)Column name id      =  ColumnNameId

 

Step by Step 

 

1) Build metadata with you List/Library  SP.Data.AssetsLibraryItem ( for Library) or SP.Data.AssetsLibraryListItem   ( for List)

 

 

2) Pass your Multi Select Value ID in to the Text Variable

 

3)Get Value in Dictionary Variable "here the out put Result is a dictionary Variable"

 

 

4) Pass the Value in to you column name ID   Ex "ColumnnameId" the Key value should be  "Columnname+Id "

 

 

5) usual Update Merge Method , get this in to Request Header 

 

6 Finally {Workflow Context:Current site URL}_api/web/lists/GetByTitle('Listname')/items({Variable:GetID}) with Post Method 

 

That is it, all good,  Enjoy.......

Outcomes