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.......
