3

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 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 sharepoint.stackexchange.com/questions/26910/… or if you want the InfoPath way, see here aanuwizard.wordpress.com/2010/07/11/… – 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
4
+25

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

http://i48.tinypic.com/19w9k0.png

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

http://www.slideshare.net/orbitone/share-point-2010-bcs

http://www.sharepointanalysthq.com/2010/07/bcs-external-list-limitations

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! – Ruben Herman Apr 26 '12 at 15:13
0

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, privacy policy and cookie policy

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