Skip to main content
Nintex Community Menu Bar
Answer

Lookup function in calculate field for list in other sites

  • January 23, 2017
  • 4 replies
  • 109 views
F
Forum|alt.badge.img+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

Best answer by pwarrak

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...

    4 replies

    TomaszPoszytek
    Forum|alt.badge.img+17

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

    Regards,

    Tomasz

    Regards, Tomasz Poszytek
    F
    Forum|alt.badge.img+8
    • fmorales
    • Author
    • February 6, 2017

    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.

    P
    Forum|alt.badge.img+7
    • pwarrak
    • Answer
    • March 8, 2017

    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...

    H
    Forum|alt.badge.img+11
    • harfmt
    • July 22, 2019

    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?

    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsCookie SettingsAccessibility statement