In SP Online using designer workflow,I am trying to update a lookup column(with multiple values enabled) from another lookup column(with multiple values enabled).Both lookup columns are in different lists. I tried different ways but the update is not happening.

2 Answers 2


From the below thread, I came to know that in SP Online,you cannot update a Lookup column with multiple value using workflow as this a bug. Is this true? Can someone confirm?



Using a 2010 workflow type and updating the Lookup column in 1;#;#2;#;#3 format resolved the issue.Looks like this is a bug in 2013 workflow type.

Update: In SharePoint Designer 2013 workflow,to update a Lookup column, you need to update the ID value of the looked up column,there are no formats to update Lookup column.Have to check if this works for Multi-select Lookup Column

In the below example, SOW# is a Lookup column and its updated using the ID columnenter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.