AnsweredAssumed Answered

lookup to a list on a different page / site ?

Question asked by bimi82 on Nov 28, 2017
Latest reply on Nov 29, 2017 by greenawayr

Hello,

 

I am trying to implement the lookup function to check the selected value from a drop down and
then show me the result from column Manager.

 

 

The cost center is a lookup function which looks at a list on a different page. My idea behind is so that when a cost center number is selected from the drop down, then it should show the relevant manager.

 

The CostCentre list contains Cost Cetre Nr | Manager | Exec etc.

 

The problem is for me how to make the lookup fetch the data from a list on a different page??
This is the url to the actual list: https://domain.com/X/Lists/CostCentre/AllItems.aspx 

 

I have tried the following as a calculated function:

lookup("https://domain.com/X/Lists|CostCentre ", "ID",CostCentre,"Manager")

 

 

the result states "Loading..." but no results showing.

Any advise in what I am doing wrong .... ???

Outcomes