Skip to main content
Nintex Community Menu Bar

SharePoint Online Updating Multi-Value Lookup From Workflow

  • February 15, 2022
  • 0 replies
  • 331 views
  • Translate

butlerj
Nintex Employee
Forum|alt.badge.img+20
TOPIC
How to update a multi-value Lookup column through a Nintex for Office 365 workflow.
INSTRUCTIONS
The Update Item action does not support updating multi-value lookup columns in SharePoint Online; the Office 365 Update Items action must be used instead:
  1. Use a Query List action to build a collection of the IDs that will be used to update the Lookup column
    • This will provide a collection output similar to
  2. Use two Replace Substring In String actions to remove the '' characters
  3. Use a Replace Substring In String action to update comma character (,) to a semi-colon (;) between each of the ID values
    • This will result in a string that looks like: 1;3;4;5;7
  4. Use this newly built variable within the Office 365 Update Items action to post the desired values into the multi-value Lookup column 
ADDITIONAL INFORMATION
RELATED LINKS
Did this topic help you find an answer to your question?

0 replies

Be the first to reply!

Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie Settings