cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
venkata
Nintex Newbie

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

Jump to solution

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. 

0 Kudos
Reply
5 Replies
emha
Nintex Newbie

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

Jump to solution

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?

0 Kudos
Reply
venkata
Nintex Newbie

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

Jump to solution

/sites/Hub/Lists/ClientInformation

0 Kudos
Reply
emha
Nintex Newbie

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

Jump to solution

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

have you tried it this way?

Reply
venkata
Nintex Newbie

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

Jump to solution

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

0 Kudos
Reply
emha
Nintex Newbie

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

Jump to solution

great!

please mark correct answer.

0 Kudos
Reply