Freitag, 10. August 2012 13:40
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?
Freitag, 10. August 2012 13:57
Freitag, 10. August 2012 15:23
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.