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

  • 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
    Commented Apr 24, 2012 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
    Commented Apr 24, 2012 at 13:14
  • I believe this question addresses the same point sharepoint.stackexchange.com/questions/26910/… or if you want the InfoPath way, see here aanuwizard.wordpress.com/2010/07/11/… Commented Apr 24, 2012 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
    Commented Apr 24, 2012 at 13:53
  • @RyanS I can't find anything that helps me allong. But if you like I post the code
    – MOI
    Commented Apr 24, 2012 at 14:51

2 Answers 2


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.

  • Nice, this totally worked :) Great work, Frederik! Commented Apr 26, 2012 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. http://www.sparqube.com/SharePoint-Lookup-Column

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.