Skip to main content
Nintex Community Menu Bar

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

  • December 18, 2017
  • 5 replies
  • 43 views

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
  • December 19, 2017

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?


Forum|alt.badge.img+1
  • Author
  • December 20, 2017

/sites/Hub/Lists/ClientInformation


Forum|alt.badge.img+14
  • Scholar
  • December 20, 2017

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

have you tried it this way?


Forum|alt.badge.img+1
  • Author
  • December 21, 2017

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


Forum|alt.badge.img+14
  • Scholar
  • December 22, 2017

great!

please mark correct answer.