Skip to main content
Nintex Community Menu Bar

hi everyone, I hope I can get help here. I need to get data on a Nintex form from a list via lookup column. The related list has 20476 items. I was hoping to archive the cascading filter shown here 

 but I can’t get the items. I did a test with the same list but with less items and it works, I’ve read here people had no issues with bigger lists - does anyone has video instructions on how to do it? Or any tips?

The issue is in filtering: when i set up a filter to show only items based on a specific column I am not getting anything at all (I checked the format and the text to be exactly as it is in the connected list so not typo or other “user” issues there)

 

Hi ​@KatyM 

Likely this is a list view threshold error.  Generally speaking, you can’t query more than 5000 items from a list.  That said the methods to work with large lists is to use indexed columns to reduce your filtering below the 5000 item limit.  In your case I’d recommend you start off by indexing the EntityID column and seeing if that resolves your issue.

You can find out more about large lists and the list vew threshold here: https://support.microsoft.com/en-us/office/overview-of-large-lists-and-libraries-e2ea4d5d-ec23-4171-95c4-c7f5b5dbfd8a

Hi ​@KatyM 

Likely this is a list view threshold error.  Generally speaking, you can’t query more than 5000 items from a list.  That said the methods to work with large lists is to use indexed columns to reduce your filtering below the 5000 item limit.  In your case I’d recommend you start off by indexing the EntityID column and seeing if that resolves your issue.

You can find out more about large lists and the list vew threshold here: https://support.microsoft.com/en-us/office/overview-of-large-lists-and-libraries-e2ea4d5d-ec23-4171-95c4-c7f5b5dbfd8a

Thank you to the moon and back Brent!!! That did resolve my problem!!!!

Sidebar Buttons
Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
Terms & ConditionsCookie SettingsAccessibility statement