Skip to main content

I have 2 site collections - "Site Collection A" has a list with source data and I have Site collection B with Nintex forms that lookup to the list in the site collection A. I am able to retrieve data into lookup dropdown on the form. But, unable to bind other source list columns to calculated values on the form

I used the following formula on calculated value

lookup("/sites/mysitecollection|mylist","ID",Store,"District")

I was able to set the calculated values from the lookup if the lookup list is inside the same site. 

have you provided correct path to mylist's site (collection)?

could you post how does the list URL looks like when you navigate to it within the browser?


/sites/Hub/Lists/ClientInformation


so your list reference in lookup() function should be: "/sites/Hub|ClientInformation"

have you tried it this way?


I missed "/" before sites/hub. Thanks, it works now


great!

please mark correct answer.


Reply