cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

List lookup not working. Message Loading.....

Jump to solution

Hello

The first screen shot below shows the problem I am having. The list lookup is allowing me to select the TAX1 value, TAX2 is saying "loading...". Once I select a value in TAX1, the option in TAX2 is only "please select value" with nothing to select.

The next screen shots are the control settings and the 2 lists I am using in the list lookup. The bizarre thing is that this worked previously on a different server, and although the below is just a test for the purpose of this post, I also exported the form from the old server and had the same problem. 

Any help is appreciated

MMTESTTAXLEV1 - LIST

MMTESTTAXLEV2 - LIST

0 Kudos
Reply
8 Replies
Workflow Hero

Re: List lookup not working. Message Loading.....

Jump to solution

it's not obvious from your screenshot, is LEV1 column in MMTESTTAXLEV2 list a lookup field sourced from MMTESTTAXLEV1's LEV1 column?

can you post its configuration?

0 Kudos
Reply
Workflow Hero

Re: List lookup not working. Message Loading.....

Jump to solution

Hello Marian

They are 2 separate lists. MMTESTTAXLEV1 contains the distinct list of values, and MMTESTTAXLEV2 contains the possible combinations. There are no lookup fields in the lists they are single line text fields, in the form I created the look up fields.

I am basically trying to create limit the options available for selection in TAX2 based on what is selected in TAX1.

MMTESTTAXLEV1

MMTESTTAXLEV2

0 Kudos
Reply
Workflow Hero

Re: List lookup not working. Message Loading.....

Jump to solution

ok.

your configuration seem to me to be correct.

since you compare by plain text values make sure the values are exact the same. usually some trailing spaces or doubled spaces may cause problems. or even, key values were copy pasted from different sources, they may contain mix of simple and non breakable spaces.

if that doesn't resolve the problem then I'd try to remove and re-add the controls once again.

0 Kudos
Reply
Workflow Hero

Re: List lookup not working. Message Loading.....

Jump to solution

I have gone over this several times, I have even created lists with only one character in there. Like I said this was working in our DEV server as seen below and I have even exported the lists as templates and exported the form and tried that, but still the same

Both our Dev and Test server have the same versions of SharePoint 2016 and Nintex forms.

Think I will log a case

Thanks for your help

0 Kudos
Reply
Workflow Hero

Re: List lookup not working. Message Loading.....

Jump to solution

these export/import exercises are exactly situations when some (GU)ID or internal dependencies may get broken.

therefore I suggested to configure controls anew.

if that didn't help, I would try to create whole brand new/empty form, just proof checked lookup cascade works there.

btw. have you checked developer console whether there are not reported any errors? they may prevent lookups to work correctly.

0 Kudos
Reply
Workflow Hero

Re: List lookup not working. Message Loading.....

Jump to solution

Thanks.

I will speak to out IT dept. about the developer console. The form I sent in the screen shot of in the first post was a whole new form on a new list using new lists for the lookups. The export and import I tried after I could not get the form to work

0 Kudos
Reply
Workflow Hero

Re: List lookup not working. Message Loading.....

Jump to solution

you needn't to contact anybody for a developer consol, just F12 within browser and it will pops up.

if you tested with new form then it's really strange it doesn't work.

do you have sufficient permissions to read both lists and their items?

0 Kudos
Reply
Workflow Hero

Re: List lookup not working. Message Loading.....

Jump to solution

Hi All. This is now resolved. the message from our SharePoint admin was....

"I created a Site Collection at the top level Web Application.  That seems to be the corrective action.  Only change I made."

Hope this helps someone one day.

Cheers!

Reply