SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
up vote 3 down vote accepted

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.

share|improve this answer
Thanks for answer! We make same decision, but make custom field according to additional requrements – IAfanasov Jan 19 '12 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 – Anders Rask Jan 19 '12 at 18:36
Thank for comment:) We awared about it – IAfanasov Jan 20 '12 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 Apr 18 '12 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) – Anders Rask Apr 19 '12 at 13:33

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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