AnsweredAssumed Answered

Displaying large number of options in dropdown list

Question asked by shk21 on Nov 3, 2015
Latest reply on Sep 13, 2016 by kk89

Hi all,

 

I have a requirement to retrieve around 15,000 values via web service call and display them on Nintex form as option values in a drop down list.

 

This drop down list needs to sit in a repeating section control so it needs to show on each new row as well.

 

Options I thought of are below but I was wondering what would be the best one or if you have a better suggestion.

 

1. Store them in a SharePoint list and use list lookup on the form, however, there is SharePoint limitation of 5,000 records that can be retrieved.

2. Store them in a SQL database and lookup from from. Possible performance issue on retrieval? any limitations? I measured the total size of 15,000 records in string format and it is around 300kb.

3. custom jquery that calls a web service using the first 1-3 letters typed in and display filtered options? This option is preferred one but not sure if it will work in a repeating section control?

 

thanks

Outcomes