We need to store multiple value from external source in the one column. Same multiple lookup.

Is there any exiting way to do it?

If no, i think about developing custom entity piecker, but it need time to development. Where are might be more effective ways. I will thank for some ideas.

1 Answer 1


For this requirement you could use either BCS (Business Connectivity Services) or a custom populated Term Set (timer job that migrates data).

Be aware that BCS has some limitations both in data amounts and doesnt work with Content Type Hub. Term Sets also has boundaries (i believe its 30.000) terms per term set.

  • Thanks for answer! We make same decision, but make custom field according to additional requrements
    – IAfanasov
    Commented Jan 19, 2012 at 13:51
  • Careful with custom fields. They are not compatible with Office, Data Sheet View, SharePoint Workspace and alot of other stuff, and should generally be avoided Commented Jan 19, 2012 at 18:36
  • Thank for comment:) We awared about it
    – IAfanasov
    Commented Jan 20, 2012 at 7:34
  • @AndersRask: I'm having the same requirement than IAfanasov. Your suggestion to use a populated term set looks like to solve a great number of problems, however, using this technique, we loose the ability to display other columns... right ? If I'm right, do you have any suggestion to keep this behavior (choosing one item, and displaying several of its column) ?
    – Steve B
    Commented Apr 18, 2012 at 8:55
  • If you do not need to associate more than one item per list, BCS field is an option. Just remember that you need to associate it on list level as a field in the list content type (like rating and enterprise keywords). This field will be ignored by CT hub. Alternatively taxonomies can be "hacked" to use label as carrying relevant data (like ProductId as primary and ProductName as label) but now we are really abusing Taxonomy fields ;-) Term sets isnt ment to carry data as such, but be a list of words (like a dropdown) Commented Apr 19, 2012 at 13:33

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.