Lookup function to a Different Server

  • 7 November 2019
  • 2 replies
  • 2 views

Badge

Is it possible to create a lookup to a list within my same domain but on a different server?

 

Example:

My SharePoint site/list lives here: 

http://app290.domain.com/sites/Region/Lists/ListName

I'm able to do this lookup to a different list on my same site without issue.

 

 

However, I want to do a lookup to a list on this site: 

http://app295.domain.com/sites/Region/Lists/DesiredListName

 

I've tried doing this: lookup("http://app295.domain.com/sites/Region|DesiredListName", "PRJID", 12345, "PRJ_Cost")

 

This is not working and I'm wondering if it's even possible with the list being on a different server? Any thoughts/feedback would be appreciated. Thank you. 


2 replies

Badge +12

@hogan24 .....What do you mean by different server? URLs in your description, are they alternate URLs to the same site?

 

If sites are different then did you try to use lookup control instead? In that you can provide the Site URL and then select the list. If you want to use the value in a calculated control then you can feed that value of lookup control to the calculated control and then always hide the lookup control.

Userlevel 6
Badge +22
Hi,

The ListLookup runtime function cannot cross site collections.
You might have to use a Call Web Service action to do this.

Reply