Skip to main content
Nintex Community Menu Bar

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

  • Dec 18, 2017 4:55 PM UTC
  • 5 replies
  • 61 views
  • Translate All

Forum|alt.badge.img+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

Forum|alt.badge.img+14
  • Scholar
  • Dec 19, 2017 12:48 AM UTC

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?

Translate

Forum|alt.badge.img+1
  • Author
  • Dec 20, 2017 7:17 PM UTC

/sites/Hub/Lists/ClientInformation

Translate

Forum|alt.badge.img+14
  • Scholar
  • Dec 20, 2017 9:50 PM UTC

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

have you tried it this way?

Translate

Forum|alt.badge.img+1
  • Author
  • Dec 21, 2017 8:13 PM UTC

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

Translate

Forum|alt.badge.img+14
  • Scholar
  • Dec 22, 2017 12:09 AM UTC

great!

please mark correct answer.

Translate