Update Multi-lookup field in SharePoint 2013 Workflow

I was developing a SharePoint 2013 workflow using Visual Studio (SharePoint add-in) and I got following error while creating/updating list item with multi-lookup column.

An unexpected 'PrimitiveValue' node was found when reading from the JSON reader. A 'StartObject' node was expected.

I searched a lot but unfortunately I could not able to find solution anywhere. Then I remembered that SharePoint 2013 Workflow communicate with list using Rest API and I found how the API expects value for multi-lookup field.

  • Single Lookup value format: LookupFieldName: LookupIdVal
  • Mutiple Lookup value format: LookupFieldName: {"results":[LookupIdVal1,LookupIdVal2] }
Now the challenge is how to provide this input since it is in JSON formatted string. Initially I thought that I have to provide JSON formatted string and tried to search for the solution but no luck. I have no clue how to build this. Got tired but at last, I got a clue from the following blog. Here, he is building a dynamic value to update managed metadata field.

http://www.jrjlee.com/2015/01/custom-workflow-activity-for-setting.html

Finally I was able to build results string as below. I have created a variable called vCollLookup and the variable type is DynamicValue.


Click on View properties, provide value for results array.


Behind the scenes the workflow sends this dynamic value in below format.

{"results":[LookupIdVal1,LookupIdVal2] }

Finally, I have used this dynamic value in UpdateListItem activity as below.


Hope it will help others.

Comments

Post a Comment

Popular posts from this blog

Switch from Classic to Claims Authentication in SharePoint 2010

SharePoint 2013 tutorials, SharePoint 2010 articles, SharePoint interview questions: Switch from Classic to Claims Authentication in Sh... : In this article we will discuss how to switch from Classic Mode Authentication to Claims Authentication. $webApp = Get-SPWebApplication “http://web application URL/” $webApp.UseClaimsAuthentication = 1 $webApp.Update() $webApp.ProvisionGlobally() $webApp.MigrateUsers($True)
Read more

How to query list data using web service

In SharePoint, to query list data we can also use web services provided by SharePoint other than SharePoint API. We can call web services from two places one is JavaScript and another one is .Net client application. Here I will show you both methods. .Net client application To query list data we will use a web service called lists.asmx . 1. Create .net project either windows/console. 2. Add the web reference and the URL looks like http://<servername:portno>/_vti_bin/lists.asmx 3. Give the web reference name as ListsSvc . 3. Add the following code snippet to get list data. ListsSvc. Lists listService = new  ListsSvc. Lists (); // If the current user is having access you can use below code listService.Credentials = CredentialCache .DefaultCredentials; // In case if you want to pass specific user credentials listService.Credentials = new NetworkCredential ( "<username>" , "<password>" , "<domain>" ); string v...
Read more