This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Learn More

Remove From My Forums

Cross site lookup columns with additional fields

Question
0

Sign in to vote

Hello,

I have main site with several sub sites underneath it. I have a list on the main site containing employee info. I have several lists on the sub sites that use employee info as a lookup via a site column I made at the root of the site collection.

I can create the lookup just fine on a single field. However when I add additional fields to the lookup, none of the fields will populate. Also the link created by the lookup does not work.

When the same lookup is used on a list within the same site, The additional fields checked in the site column for that lookup will work.

How do I get the additional fields to work in a cross site situation?

fr0stsp1re

Monday, June 2, 2014 11:50 PM

Answers

0

Sign in to vote
Hi,

According to your post, my understanding is that you wanted to get lookup values from another site collection.

I recommend to use rest service to get the values form the other site collections, and then set the values to the lookup column.

Here is a similar blog for your reference:

http://www.hamishking.com/2010/07/16/referencing-lists-from-external-site-collections-cross-site-collection-lookup-with-rest-and-the-dvwp/

In addition, you can do a cross site collection look up and populate it as a dropdown control in your SharePoint application using JQuery.

For more information, you can refer to:

http://www.sharepointfix.com/2010/11/cross-site-collection-dropdown-look-up.html

More information:

Cross-site Lookup Column for SharePoint 2013 and SharePoint Online in Office 365 - CodeProject

Best Regards,

Linda Li
Linda Li
TechNet Community Support
- Marked as answer by JasonGuo Sunday, June 15, 2014 4:20 AM
Tuesday, June 10, 2014 7:52 AM