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  =  s21,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.......