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

After Update Nintex Forms 2013 ( 2.11.2.2 ) Lookup Column error

Jump to solution

When I call the form comes this message!

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

Reply
15 Replies
shrinivasnaik
Nintex Newbie

Re: After Update Nintex Forms 2013 ( 2.11.2.2 ) Lookup Column error

Jump to solution

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

0 Kudos
Reply
praios81
Nintex Newbie

Re: After Update Nintex Forms 2013 ( 2.11.2.2 ) Lookup Column error

Jump to solution

Hi Marco,

do you work with any code in your form?

Did all solutions deploy correctly?

Best regards

Enrico

0 Kudos
Reply
marcof
Nintex Newbie

Re: After Update Nintex Forms 2013 ( 2.11.2.2 ) Lookup Column error

Jump to solution

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

0 Kudos
Reply
shrinivasnaik
Nintex Newbie

Re: After Update Nintex Forms 2013 ( 2.11.2.2 ) Lookup Column error

Jump to solution

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

0 Kudos
Reply
marcof
Nintex Newbie

Re: After Update Nintex Forms 2013 ( 2.11.2.2 ) Lookup Column error

Jump to solution

Hi Shrini

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

Message in ENG

Regards,

Marco

0 Kudos
Reply
shrinivasnaik
Nintex Newbie

Re: After Update Nintex Forms 2013 ( 2.11.2.2 ) Lookup Column error

Jump to solution

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

0 Kudos
Reply
marcof
Nintex Newbie

Re: After Update Nintex Forms 2013 ( 2.11.2.2 ) Lookup Column error

Jump to solution

Hi Shrini,

Thank you for your support

I check the points and give a feedback
Regards,
Marco
0 Kudos
Reply
martin_rabe
Nintex Newbie

Re: After Update Nintex Forms 2013 ( 2.11.2.2 ) Lookup Column error

Jump to solution

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

0 Kudos
Reply
martin_rabe
Nintex Newbie

Re: After Update Nintex Forms 2013 ( 2.11.2.2 ) Lookup Column error

Jump to solution

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

0 Kudos
Reply