Skip to main content
Nintex Community Menu Bar

For a SharePoint online list I generated automatically the K2 Forms from SharePoint.

On this list I have a Lookup field that is pointing to another SharePoint online list with more than 3000 items.

On the generated forms for new/edit item, the control for this Lookup field is a multi-select, but it shows only the first 100 items.

It is possible to display all the items on the multi-select control?

Or there is a better solution to avoid the load of more than 3000 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.


Hi ​@ovs,

 

Unfortunately, there is no way to display more than 100 values in a multi-select control. The picker is also limited to 1000 rows.

You could, however, change the multi-select control to a lookup control and use a list view bound to the lookup SmO, then filter through the values that way.

 

HTH,

Gem


@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


Solution in FP 17 for 5.8: 

The fix introduces a new config file ''K2 Install Dir]\Program Files\K2\Host Server\Bin\SourceCode.SharePoint15.Client.dll.config'

This config file has a Default value for 'MaxReturnFields = 100', which means only 100 records will return for the SharePoint Lookup columns.


Reply