Document Library Multi-value lookup to Field in External List


  • Hi All,

    I have been looking at connecting to external lists for lookup fields.
    This seems to work properly (I think I simply haven't configured the filters properly) for single values.

    However, SP 2010 still does not seem to support multi-value lookups, which is a real pain and means the external data may as well not be available. 

    Is there any work-around that might just work for a document library?  Seemingly Infopath allows you to do this for lists, but I need it for a document library.

    Any help would be appreciated. 


    Tuesday, November 09, 2010 3:07 PM


  • Hi RonanBe,


    First you can try to create an external content type by using SharePoint designer 2010, then you can create an external list from the SharePoint Designer 2010. Finally, you can create a document library, and add a lookup column, make sure you select “allow multiple values” option.


    For more information about how to create an external list, please refer to the following article:


    Getting Started – How to Create an External List from Scratch?


    Hope this helps.


    Rock Wang

    Regards, Rock Wang Microsoft Online Community Support
    Thursday, November 18, 2010 8:17 AM

All replies