Solved

Responsive Designer List Lookup

  • 11 March 2022
  • 4 replies
  • 19 views

Badge +4

Hi

 

Does anyone know what the limits are to a list lookup field in the Responsive designer?  Looking to find the limit and see if there is a way to filter the lookup by item ID possibly.  Putting 1/2 the list into one lookup and the rest in a 2nd, worst case. 

 

Thank you! 

icon

Best answer by zbean 15 March 2022, 13:52

View original

4 replies

When you have a form and you refer to the smartobject, you can put limits on the lookup by filtering from a different column.   I have a sharepoint list that  has 4k+ items in it, and i processes it just fine.  There is a small delay due to the download onto the form to write the information.

Badge +4

Thanks, yea i have used filters.  For my use case i am picking up a column from a parent list to use.  That column needs to bring in just over 3000 items so that the user can pick a single selection. The drop down has recently started cutting off options, as if there is a limit to the amount the lookup can retrieve. 

Badge +4

This was resolved with the settings for the lookup limit in the Responsive designer.  So we can get hit 5k rows. Thanks!

Userlevel 1
Badge +6

I have lookups to lists with over 25,000 items. It is a bit slow, but it works. Using filters definitely speeds things up. However, if you want it to work really fast, do away with the drop-down if you can.


 


For a number of forms that I have, it contains information about our product parts. For most forms people know what the part number is. When the part number is entered, create a rule with the Lookup (nintex.com) function to the list to populate any other data (in my example, part description, unit price, category, export restriction, etc.).


 


Also, if you are looking for solution to sync your backend system data with a SharePoint list, Data Integration & File Sync for SharePoint and Office 365 | Layer2 Cloud Connector (layer2solutions.com) is great for this. This is what we use to keep our parts list updated.

Reply