https://www.infopathdev.com:443/forums/46.aspx For questions concerning issues in the integration of SharePoint and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/120712.aspxMon, 01 Apr 2019 13:21:17 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120712Michael Boonie0https://www.infopathdev.com:443/forums/thread/120712.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=120712Right, again! As always, thanks for the tip, Hilary!https://www.infopathdev.com:443/forums/thread/120705.aspxFri, 29 Mar 2019 21:41:41 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120705Hilary Stoupa0https://www.infopathdev.com:443/forums/thread/120705.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=120705Does your list have any indexes? That&#39;s where I&#39;d start - indexes on the columns you wish to use for filtering. That is under the List settings, in the columns section.https://www.infopathdev.com:443/forums/thread/120704.aspxFri, 29 Mar 2019 21:24:20 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:120704Michael Boonie0https://www.infopathdev.com:443/forums/thread/120704.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=120704Hi, all. I am developing a form for SharePoint 365 that will utilize three picklists, each of whose source/values should be &quot;cascaded,&quot; i.e. filtered by using previous choices. The best analogy I can use is trying to select a City by drilling down from a <b>State</b> picklist to a <b>County</b> picklist to a <b>City</b> picklist: there are way too many cities in the U.S. to put in a picklist (you would certainly incur the dreaded &quot;The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator&quot; error); but a picklist of 50 States will be able to provide a filtered list of Counties, which in turn will result in a reasonable list of Cities. <br /><br /> However, I find that I am unable to apply any filter values to this large list (78,000+ rows) even though I know the number of records returned would be well under the limit. (The list itself was created by importing a large spreadsheet.) When I try to query the list for Cities that match the County that was selected, I am told the list view threshold has been exceeded. <br /><br /> In attempting to fix the problem, I thought I would start with a nice, filtered default view of less than 100 rows, to avoid SharePoint&#39;s wrath. But I can&#39;t even apply a filter to the view; doing so still throws the &quot;query results too large&quot; error, which seems bizarre since I know the resulting view would return well under the maximum number of records. (I figured I&#39;d use this filtered view and re-filter the list in InfoPath using the selected criteria, which would definitely return an acceptable number of records, as tested in Excel.) <br /><br /> Has anyone hit this impasse before? It&#39;s quite the conundrum: I can&#39;t use the list because there are too many records, but I can&#39;t filter it in SharePoint nor InfoPath, apparently for the same reason??? <br /><br /> I know it seems like a lot of effort for picklists, but this involves hundreds of purchase orders and vendors and account numbers, and this would be the most reliable way to validate the user&#39;s input. <br /><br /> Please help!