1

I have list A with a Status column of Red/Amber/Green and list B which needs to lookup the Status column from column B.

I know you can't do a straight lookup and found this workaround But it doesn't work on multi-choice. It always returns Red. Any ideas?

Improve this question

1 Answer 1

Reset to default
2

There is no way to do straight lookup for multi-choice field type. The recommendation is you create custom form (new form, display form and edit form). In custom forms, you create select HTML element and bind data from Status column. Then once you submit the new form, you create an SharePoint lookup field value and insert into list B.

References:

Improve this answer
2
  • Thanks @DuyVo, am I missing something? I wasn't talking about creating a form?
    – Dazza
    Jul 25, 2017 at 12:22
  • @Dazza: There is another approach if you don't want to create custom forms. You can use JS Link to do the same way like I mention above. Reference: code.msdn.microsoft.com/office/…
    – Duy Vo
    Jul 25, 2017 at 16:39

Your Answer

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

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