Nintex Forms lookup functions

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.

simply hit F12 in browser and developer console should pop up.

switch to console tab in there.

run the form and watch what is reported on the console.

@emha 

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?

Thank you

Claire

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?

Regards

Claire

I am not getting the same (or any) IE errors but I am seeing the same result (#value!) from an almost identical lookup function in a named control.

Any ideas?

is it becuase I'm creating the form on a sub site of the main site?

definitelly!

have a look on documentation how list from a differrent site or subsite should be referenced - https://help.nintex.com/en-US/nintex2013/help/#Forms/RootCategory/Designer/Nintex.Forms.LookupFunction.htm%3FTocPath%3DForms%7CUsing%2520the%2520Form%2520Designer%7C_____21

out of your above screenshots, I'd say the list reference in your formula should look like.

the rest seems to be correct. 

have you tried it that way? didn't it work?

/sites/en-EMARNE|Dematic Cost Centres