Nintex K2 Form for SharePoint online list - lookup limited to 100 items

Hi @ovs,

I would suggest that the multi-select control be changed to a picker control to better assist with loading all those values. The picker control can be configured to return the required number of rows and can also load on demand, so the view/form doesn’t take too long to load.

HTH,

Gem

Hi ​@ovs 
Has your question been answered? 

Thank you ​@gemw18 - the picker control is a solution for this form.

But the main question was “It is possible to display all the items on the multi-select control?”, so not only the first 100 items.

​@gemw18 Thank you! If I understand well, the Picker control allows to search on all the available items (from the lookup List) and select some values. Is not possible - at least in my case - that the user selects more than 10-20 items, so the 1000 items limit on the display is not an issue. I understand from here that the 1000 limit is related to the editable area. It is correct?

​@ovs, no. The picker results are limited to 1000 rows, not the selection.

​@gemw18 I looked at the solution to use a Lookup control as you mentioned. On click on the Lookup control you can show a subview with the records to select, but how can you select more than one row from the subview at a time?
For example, on the subview item doubleclick you need to transfer the data to the lookup. How you can transfer more than one row at a time?

Hi ​@ovs,

There are a number of ways you could display the data on return from the subview. You don’t need a lookup control necessarily, just some way to open the subview. On the subview, you’d need rules to concatenate the values for each selected row on e.g. a button click, and transfer that back to the main view/form. You could use a text area, for example, to then display and save those selected values.

HTH,

Gem