Skip to main content
Nintex Community Menu Bar

Maximum number of list items required for a list lookup control in nintex forms

  • December 21, 2020
  • 1 reply
  • 36 views
Forum|alt.badge.img

With Nintex Forms for Sharepoint 2016 / Sharepoint Online, I am currently using a list lookup control connected to a SP list that could potentially exceed 65000 items. 

 

Is it best practice to keep this configuration or Should I expect potential issues, such as display problem or long search delays ? 

 

Thank you for your help.     

    1 reply

    Michel
    Nintex Partner
    Forum|alt.badge.img+7
    • MichelNintex Partner
    • Nintex Partner
    • December 29, 2020
    It is always best to reduce the number of items in a single list, but sometimes that just doesn't work within each business situation.

    The more items, the longer it could take for a query to be executed and, since 65.000 items is pretty much, could become a problem. Make sure to use Column Indexing on columns you are using in your query. More information about Column Indexing; https://support.microsoft.com/en-us/office/add-an-index-to-a-list-or-library-column-f3f00554-b7dc-44d1-a2ed-d477eac463b0
    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsAccessibility statement