I have been using Nintex Responsive forms for a while now and have used the Look up functions on various forms.
For some reason I am not able to get the result I was expecting when doing the following
lookup("LIST NAME", "ID", parseLookup(NAMED CONTROL, false), "COLUMN NAME")
So the image below in the first picture I am doing a look up from a SP list "Cost Centre Number" which works okay and I can select from the options given, then in the second image I want to show the Cost Centre Number once I have selected the cost centre name from the drop down using the lookup formula as shown above, this has worked loads of times on previous forms but for some reason which I can not work out I get the #value!
have you carefully checked for a typo/case issues?
an extra or missing space character somewhere? non-breakable space instead of simple space? - typical issues if you copy over formulas or object names
different display and internal object names?
some 'sentive' characters in 'NAMED CONTROL' value(s)? (commas, apostrophes, back/slashes...)
permission issue on 'LIST NAME'?
have you tried to add a calculated value control for 'NAMED CONTROL' and parseLookup(NAMED CONTROL, false) just to see how do they evaluate on their own?
any errors on the form reported on developer console?
I'd suggest to debug it out from basics...
first of all check the developer console for any errors reported. if there are any resolve them first.
then as mentioned let evaluate simply 'NAMED CONTROL' in a calculated value control, next parseLookup() function, etc.
Thank you for coming back to me, I have run the developer console and I get error messages.
It shows that the List is not valid, even though it's looking up a SharePoint list in the First look up column on my form and this works okay, but when I add a calculated value this is where I get the error message, as I want it to select from the look up column and then show related information, a bit like a cascasding look up.
I have added test look up to the columns I am trying to look up and they work fine, it's only when I add this formula to the list it does not work as it has before.
Any further suggestions?
fuuu, that's quite a bunch of errors. so it's of no surprise someting doesn't work as expected.
I think the error messahe is quite clear - it's not pssible to find a list with name 'Dematic cost centres' within the site 'https://dematic0.sharepoint.com/sites/en-EMARNE/apps'
so there is either problem with list name or site url.
do yo by any chance look for a list from the other site than where the form runs?
could you share what's the exact 'Dematic cost centres' list URL, and what's the URL of the list the form runs on?
could you post configuration of working 'First lookup column on form'? have you configured 'Source SharePoint site' option there?
The master list is on the top site en-EMARNE-
https://dematic0.sharepoint.com/sites/en-EMARNE/apps (This is a sub site).
This is where the list is stored - https://dematic0.sharepoint.com/sites/en-EMARNE/Lists/Dematic%20Cost%20Centres and configured in the first column which works okay, it looks up the list and finds the information required.
The Calcualted column configuration is as shown below,
is it becuase I'm creating the form on a sub site of the main site?