InfoPath Query to SharePoint List Only Returns First 100 Items

Last post 08-09-2010 01:45 PM by Potemkine. 3 replies.

Page 1 of 1 (4 items)
	Sort Posts: Previous Next

08-09-2010 01:04 PM

Daren_D
Joined on 08-09-2010
Posts 19

InfoPath Query to SharePoint List Only Returns First 100 Items

Reply Contact

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

Filed under: connection secondary form, data connections, data connection, dropdownlist, 2007, cascading dropdown filter xPath, Infopath data connection, infopath data connection sharepoint lists, infopath 2007, Connection, infopath dropdowns

08-09-2010 01:11 PM In reply to

Potemkine
Joined on 06-21-2010
Posts 451

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

Mark as Not Answer Mark as Answer ...

Reply Contact

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.

08-09-2010 01:19 PM In reply to

Daren_D
Joined on 08-09-2010
Posts 19

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

Mark as Not Answer Mark as Answer ...

Reply Contact

That worked like a charm!

Thanks!!!!

08-09-2010 01:45 PM In reply to

Potemkine
Joined on 06-21-2010
Posts 451

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

Mark as Not Answer Mark as Answer ...

Reply Contact

Good !!

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

Page 1 of 1 (4 items)

InfoPath Dev