InfoPath 2010 - List throttling for dropdown problem

Question

Hello,

I've been tasked with developing an InfoPath 2010 form which requires a lookup into a secondary datasource which is a SharePoint list that contains 40,000 items. The form works fine in preview (yes, a little slow, but it works) but does not work when I publish it to the SharePoint list. I get the dreaded "The amount of data that was returned by a data connection has exceeded the maximum limit that was configured by the server administrator." message. Since this is a development system, I reset the list throttling on the web app to 50,000 , then 100,000, then 1 million and it had no affect. I continued to get the error message and the dropdown is blank. I also tried to set the limit on the Allitems view for the list to return 100 items only, not batches but a hard 100 item limit. Still no luck.

I know that A SharePoint list is not the most efficient way to use such data but I have no choice, I am not a developer, we do not have a developer and the budget for services is done for this year. Can anyone tell me why the InfoPath form does not see the larger throttling limits or suggest a way that I can use to bind this data to a dropdown control without encountering this error?

Thanks.

Answer 1

Hi SharePoint4You, do you have to load all the 40000+ items when the form loads? Or you can limit the amount of data based on a user's choice?

Cheers
Riccardo

---

Italian SharePoint Community - My blog - My profile

Answer 2

Hi Riccardo,

What they want is to be able to type the name or part of the name and have the matching results returned so they can select one. I tried using rules like creating a field called "TextSearchTerm" to capture their typing, then run a query on the items that "contain" the search term. It takes way too long to parse 40,000 records for a partial match. I have the column indexed but that does not help. If you know of another way that I can limit the records returned based on a partial match, that would be a big help.