Drop Down box not fully populated with entries from a Sharepoint l

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Colin Jones - 09 Jan 2006 05:36 GMT

I have set up a Sharepoint list with many entries in it. Then designing a
form in Infopath to be used in a Sharepoint Forms Library, I am adding
several different Drop Down boxes (or list boxes) and configuring them to
populate from one or more Sharepoint lists using various Data Connections.

It all works very well and easily until you have a SP list that contains
more than a couple dozen entries! The Drop Down box just stops between 25 and
40 entries in and all the others are simply omitted - no explanation or error
messages..

Can someone please explain this behaviour? This is a really powerful
function, but if it is so limited it kind of renders the whole forms/SP
useless!

Rgds
Col

Reply to this Message

S.Y.M. Wong-A-Ton - 09 Jan 2006 07:47 GMT

Hi Colin,

What is the "Item Limit" for the views set as the "Default View" on each one
of those SP lists?

Regards,
S.Y.M. Wong-A-Ton

> I have set up a Sharepoint list with many entries in it. Then designing a
> form in Infopath to be used in a Sharepoint Forms Library, I am adding
[quoted text clipped - 12 lines]
> Rgds
> Col

Reply to this Message

Mage - 09 Jan 2006 20:00 GMT

It sounds like you need to set the item limit in the list view to a
larger number. I use to have the same problem in a list of 4500+ had
to go into "Modify settigns and Columns" then "all items" under items
then down at the bottom there is "Item Limit" expand it and change the
"Limit the total number of items returned to:" to a number larger then
items in the list.

Craig

> Hi Colin,
>
[quoted text clipped - 20 lines]
> > Rgds
> > Col

Reply to this Message

Colin Jones - 09 Jan 2006 22:40 GMT

Further - is there any easy way to sort the data returned before it populates
the drop down box without having to reconfigure your SP list? The SP lists
are used for data entry and are configured in a particular way for that. So
when I draw down that data for a particular field it is effectively in random
order unless it happens to be the field that the view sort is done on! Can
you tell the Data Connection to use anything other than the Default View for
accessing the data, perhaps?

> It sounds like you need to set the item limit in the list view to a
> larger number. I use to have the same problem in a list of 4500+ had
[quoted text clipped - 29 lines]
> > > Rgds
> > > Col

Reply to this Message

Colin Jones - 09 Jan 2006 21:12 GMT

Thanks for the advice, guys, but it still isn't working.

1) the SP list they draw the data from have multiple views set up, so which
is the one that defines the number of items returned? The Default View?

2) I went through the SP list views (not just the Default View) and checked
the item limit. For all the basic list view types, they were/are now all set
to large values to return "in batches of". And for Data sheet view types,
they are set to "Display All Items"

But it still limits the number of items returned to the same value...

Can you please help????

> Hi Colin,
>
[quoted text clipped - 20 lines]
> > Rgds
> > Col

Reply to this Message

Colin Jones - 09 Jan 2006 21:17 GMT

Sorry guys - I just worked it out!! In the Default View, in the number of
items to display, the default is display all items, which is what I was
using. The other option is to limit it to a number, and that number by
default is 100. I didn't realise that even though that option isn't even
selected, this limits the number returned by the Data Connection!! Not very
intuitive if you ask me. Sorry if that is what you were trying to explain!

Thanks
Col.

> Thanks for the advice, guys, but it still isn't working.
>
[quoted text clipped - 34 lines]
> > > Rgds
> > > Col

Reply to this Message