InfoPath data connection not returning all results
In an InfoPath Form, I had a Data Connection to a SharePoint list which has almost 500 items.
When I open or preview the form, only 100 items are being returned from the SharePoint list using the Secondary Data Source of the SharePoint data connection.
InfoPath loads items from SharePoint which appear in the default view of the specified list or library. By default, SharePoint limits the total results of a view to 100, which can be changed by modifying the default view.
See InfoPath data connection not returning all results from a SharePoint list for details.