Nintex Forms - set calculated value from lookup list in different site collection.

  • 18 December 2017
  • 5 replies
  • 11 views

Badge +1

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. 


5 replies

Userlevel 5
Badge +14

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?

Badge +1

/sites/Hub/Lists/ClientInformation

Userlevel 5
Badge +14

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

have you tried it this way?

Badge +1

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

Userlevel 5
Badge +14

great!

please mark correct answer.

Reply