Data Connections

Re: Pre-filled drop down field not showing all options

warrtalon — Mon, 02 Nov 2009 19:35:49 GMT

Show All Items just means no filter is being applied. The Item Limit is always in play, though.

Re: Pre-filled drop down field not showing all options

linkkoh — Mon, 02 Nov 2009 19:03:45 GMT

Thank you, i had it set to "show all items" and i changed it to limit it to "1000" and that worked, not sure why "all items" didn't work though

Re: Pre-filled drop down field not showing all options

warrtalon — Mon, 02 Nov 2009 18:58:25 GMT

Default receive data connections from SharePoint only show whatever is in your default view. OOTB, the default view of a list has an Item Limit of 100, so it is not surprising that you're only seeing a subset. 50 would only make sense if the item limit has been lowered to 50 or if your default view has a filter that only shows 50.

To show all data in the dropdown, you have a few options:

1) Change the settings of the default view to show every record with no filters and no item limit

2) Create a new view that isn't your default but shows every record and then create a new XML receive data connection using this method: http://blogs.msdn.com/infopath/archive/2007/01/15/populating-form-data-from-sharepoint-list-views.aspx

3) Lastly, if you want to take #2 even further and be able to pre-filter the data from your list on the server side before it gets to InfoPath, you can use Qdabra's soon-to-release qRules 2.0, which has this feature included.

Re: Pre-filled drop down field not showing all options

linkkoh — Mon, 02 Nov 2009 18:51:38 GMT

I guess http://support.microsoft.com/kb/892954 is what is happening, which is "by design", but what is the work around?

Pre-filled drop down field not showing all options

linkkoh — Mon, 02 Nov 2009 18:41:50 GMT

I have an infopath form that is published to sahrepoint, and one of the data connectors is pointing to sharepoint list, it however only pulls in about 50 records out of 200 that are int he list. Is there an item limit? How can you change the limit? Thank you, Daniel Schmidt