Data Connections

Re: InfoPath Query to SharePoint List Only Returns First 100 Items

Potemkine — Mon, 09 Aug 2010 20:45:16 GMT

Good !!

I'm glad that I could help you with that.

Re: InfoPath Query to SharePoint List Only Returns First 100 Items

Daren_D — Mon, 09 Aug 2010 20:19:10 GMT

That worked like a charm!

Thanks!!!!

Re: InfoPath Query to SharePoint List Only Returns First 100 Items

Potemkine — Mon, 09 Aug 2010 20:11:25 GMT

Hi Daren_D, Infopath use Sharepoint Default view if your view just show your 100 first items, your data connection just show you that.

You have to change your default view to show you all your items.

InfoPath Query to SharePoint List Only Returns First 100 Items

Daren_D — Mon, 09 Aug 2010 20:04:38 GMT

I've created a dropdown list in an InfoPath 2007 form that connects to a SharePoint 2007 list (I used the DataConnection Wizard) with 600+ items in it, but it's only returning the first 100 items in the list. Has anyone else run into this problem?

A buddy of mine is pulling a list of over 6000 items with no problem, but from a different SharePoint site with a seperate company....and he can't seem to find an error with my InfoPath coding.

I'm wondering if its a SharePoint setting.

Thanks in advance!

Daren