Get lookup values from another site

Question

Cross Site Lookup for SharePoint  2013:

1. I have created Department list in sub site (not in root site)  that contains the columns Title, Location, Manager.

2. In another site i have created a list, name has TestList and one of the column Department in this column i want to get values of Title from Department list [Ex: Just like lookup].

3. Under TestList new form when selection of department show the related manager value in manager field(i.e., Department list column Manager values). How can i achieve this from client side.

Thanks,

Answer 1

Hi

any other data from other site is visible as external data

https://msdn.microsoft.com/en-us/library/office/ee559346(v=office.14).aspx

---

Romeo Donca, Orange Romania (MCSE, MCITP, CCNA) Please Mark As Answer if my post solves your problem or Vote As Helpful if the post has been helpful for you.

Answer 2

Hi Sushanth Y,

About the second point, you could get values of Title from Department list and set the value of the Department column in the test list by PowerShell command. For more details, you could refer to the article.

SharePoint 2010 Cross-Site Lookup using PowerShell.

http://osric.com/chris/accidental-developer/2012/10/sharepoint-2010-cross-site-lookup-using-powershell/

There is a similar thread:

http://sharepoint.stackexchange.com/questions/79629/cross-site-and-spfieldlookup

About the third point, you could create cascading dropdown lists by customizing the form in InfoPath designer or use SPService by adding the JavaScript code in the content editor web part.

For more detailed information, you could refer to the articles below.

Working With 2/3 level Cascading Dropdown in SharePoint List.

http://microsoftsharepointdevelopment2010.blogspot.jp/2013/01/working-with-cascading-dropdown-in.html

Browser Based InfoPath 2010 – Creating Cascading Dropdown Fields with no Code.

http://www.nothingbutsharepoint.com/2011/03/24/browser-based-infopath-2010-creating-cascading-dropdown-fields-with-no-code-aspx/

Best regards,

Sara Fan

---

TechNet Community Support
Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact [e-mail].