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

I need to create a list column which contains external data (from BDC). The field has to contain multiple values. But I haven't found a way how to make a external-data-field take multiple values.

Creating such a multi-value field is possible by using the Column-Properties "allow multiple selections" in a user content type. However, creating a column using external data I do not have the ability to add a multi-value column.

It should look like this, just from a external data source (BDC/BCS): multi-value field

Does anyone know how to handle such a situation?

My Environment: SharePoint 2010, Visual studio 2010, SharePoint Designer

share|improve this question
Can you get the standard and limited form code? So we can compare the two; it's likely theres a little change you can make to your current form. – RyanS Apr 24 '12 at 13:06
Do you mean the code from the "NewItem" and "EditItem"-forms? Until now I'm using the standart forms. Sorry, I can't follow, what do you recommend to combine? – MOI Apr 24 '12 at 13:14
I believe this question addresses the same point… or if you want the InfoPath way, see here… – Marius Constantinescu - MVP Apr 24 '12 at 13:23
I mean the snippet for the form that allows you to select multiple selections, and the form that only allows for one. There may be a simple change in title etc – RyanS Apr 24 '12 at 13:53
@RyanS I can't find anything that helps me allong. But if you like I post the code – MOI Apr 24 '12 at 14:51

You can not allow multi values when using a lookup to a external list.

More info about BCS and its limitations can be fount at:

Maybe, you could be able to work around this issue using custom field types for example. But not with OOTB BCS.

share|improve this answer
Nice, this totally worked :) Great work, Frederik! – Ruben Herman Apr 26 '12 at 15:13

OOTB SharePoint Lookup does not supports it. You can try to use commercial add-ons. For example, Sparqube Lookup Extra field type allows multiple values when lookup items from External List.

share|improve this answer

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.