After Update Nintex Forms 2013 ( 2.11.2.2 ) Lookup Column error

[marcof]

When I call the form comes this message!

and if I change the value in Lookup Column the same message too...

[shrinivasnaik]

Hi Marco,

If you try to open the Nintex designer for the list and republish the form what error do you get ? or does it publish successfully ..? 

Regards,

Shrini

[praios81]

Hi Marco,

do you work with any code in your form?

Did all solutions deploy correctly?

Best regards

Enrico

[marcof]

The problem is the Calculate field with lookup fx to the list from which the dropdown is filled when the fields are empty.

it worked before the update

[shrinivasnaik]

Hi Marco,

What is the exact error message you are getting, I can see the screen shot "There are some problems ...." but the actually error message is not in english? Could you please translate?

Looking at your lookup formula though are you really filtering it by "ID"? or is it some other column? ID is SharePoint's internal ID column?

Regards,

Shrini

[marcof]

Hi Shrini

this message comes when a field in the lookup list is empty!

Message in ENG

Regards,

Marco

[shrinivasnaik]

Hi Marco,

I did a quick try myself on my version on Nintex forms and it seems okay, if there are no rows to retrieve (i.e. if there are no rows in the lookup lists), I believe you might have to trouble shoot a little further as I guess you only started getting this error after a Nintex forms upgrade?

1) Could you create another calculated column and add the same formula to check if it still occurs (just to rule out any form control issues after upgrade). You might have to delete the problem causing calculated column just so that the same error does not crop up. (Please take a backup of your original form though!)

2) Could you check if you query is right? I do see you are selecting ID column to filter on? Is that correct? 

3) Could you try hard-coding a value instead of "Account Number" just to see if the calculated formula is able to lookup an empty list and does not throw an error.

4) Replace the "Account number" control to check?.

You might want to troubleshoot this further because when I did try on my version (which is not of your version though) it seems okay. 

Regards,

Shrini

[marcof]

Hi Shrini,

Thank you for your support

I check the points and give a feedback

Regards,

Marco

[martin_rabe]

Hi,

I am facing the same problem with the current release 2.11.2.2 for Nintex Forms 2013

All referenced calculated values depending on lookup values are throwing the named error message, when the returned value is empty.

Please fix this issue asap.

Creating new controls doesn´t fix the problems.

Regards

Martin

[martin_rabe]

It also applies on form variables when u have build them with a lookup value