I'm trying to set the value of a field in a lookup column using a SPD 2013 workflow. The column is set to allow multiple values in the lookup.
I've seen many sources stating that the syntax for achieving this is either id1;#;#id2;#;#id3
or id1;#value1;#id2;#value2;#id3;#value3
, where id
and value
are the ID of the list item and the value from the lookup field respectively. However, people are usually referring to SPD 2010 workflows, and this post suggests that this syntax cannot be used in 2013 workflows.
I want to use a native SPD 2013 workflow but when I tried the methods above they both fail with the following error:
"An unexpected 'PrimitiveValue' node was found when reading from the JSON reader. A 'StartObject' node was expected."
From this I assumed that I should be providing some kind of JSON object of the form {"results":[id1,id2,id3]}
or {"results":[{"Id":id1,"Value":value1"},{"Id":id2,"Value":value2},{"Id":id3,"Value":value3}]}
, which is what you get if you retrieve an existing field as a string. I attempted to build a dictionary with some test values, but I still got the same error.
Am I heading in the right direction here? Is this even possible with SPD 2013 workflows? I'd appreciate any advice on this subject.
Thanks, Jon