InfoPath Dev

I have created an Infopath form in 2010 that has a repeating table with a dropdown list box that displays items from a particular SharePoint list.  I have been asked to ensure that when the form is displayed (Browser Based) that 3 of the items in the list be removed. I am unsure how to do this and any help would be greatly appreciated.

Thanks.

I don't believe filters allow excluding, only including.

So if you have 10 list items with Column1=A and 3 list items with Column2=B, you could filter to return only the items where Column1=A (thus excluding the 3 items with Column2=B).

However, you cannot filter (a default data connection) with a filter like Column2 is not equal to B.

One alternative might be to return ALL items in the list, and then filter the data on the canvas. A dropdown list box will allow a filter on the selection made in "Entries".

Good luck!

Thank you for your response. I am not quite sure what you mean by filter the data on the canvas. I am already returning all the data from the list. I just want to exclude 3 items from showing.

You could put the items (e.g. a textbox control or any other kind of control) in its own section control, then set a condition in the properties of the section control to hide it based on some other value in the form.  I use a "Status" field quite a bit to control what is visible or not visible during the life of the form....

In InfoPath/Sharepoint 2010 you can set the queryField to filter the data on the server. That's the best option - faster performance.

If you bring in all the items into the data connection (without a filter), then you will need to filter in the dropdown itself, when configuring the dropdown properties, in the Entries box.