Solved

Lookup function in calculate field for list in other sites

  • 23 January 2017
  • 4 replies
  • 69 views

Badge +8

I have a form, I need that Lookup function in calculate field, read a field in the column in list in another site.

 

This list (Named "CLIENTE") in the other site (Catálogos) have a full URL:

 

https://labstein.sharepoint.com/Finanzas/Cat%C3%A1logos/Lists/CLIENTE/Allitemsg.aspx 

 

I dont know write the URL in the function.

 

Help me, thanks

 

Federico

 

197855_pastedImage_8.png

icon

Best answer by pwarrak 8 March 2017, 11:38

View original

4 replies

Userlevel 7
Badge +17

‌ have you found out how to solve your problem? Can you share the solution with us?

Regards,

Tomasz

Badge +8

Hi,

I don't have a answer yet.

I don't know if the problem is about nintex and sharepoint 365 (On line).

Thanks,

FMS.

Badge +7

Dear,

 

Here an example, 

 

Am working with a web called "POC" and I want to retrieve a field from a list named "Countries" from another web called business "BusinessTrip" both under the same site collection:

 

Below the code:

lookup("/BusinessTrip|Countries","Title","Italy","VAT") 

 

 

Cheers...

Badge +11

Hi @pwarrak 


Thanks for your excellent example. 


 


I have a list that I want to lookup to from a calculated value. It is in the same collection, however the lookup list is at the top site collection level rather than in a different subsite. 


 


I want to get the following:


lookup("/SiteCollectionName|Countries","Title","Italy","VAT") 


from 


subsite. 


 


The example doesn't seem to work for that scenario. Any ideas?

Reply