Newbie Questions

Re: unique drop down list choices from share point list

Grinch — Thu, 25 Aug 2011 03:50:46 GMT

Is there an equivelant to the shrinking list for Infopath 2010. the "not" is not working now we are using Infopath 2010.

My list no longer shrinks

thanks

Anthony

Aruna Akella — Thu, 29 Apr 2010 16:10:49 GMT

I am glad it's working! :).

rbuchanan — Thu, 29 Apr 2010 15:42:04 GMT

Thanks.

I looked at your form and the filter you used for your drop down

not(. = ../preceding::my:group2/my:field2)

My initial selction with no filtering at all from the Sharepoint List I'm using as a Secondary Data Source is

/dfs:myFields/dfs:dataFields/dfs:BE_BU_3/@BE

I tried modifying your filter

not(. = ../preceding::dfs:BE_BU_3/@BE)

It seems to have worked.

THANK YOU VERY MUCH.

Aruna Akella — Wed, 28 Apr 2010 20:18:15 GMT

Here is the screenshot.

Aruna Akella — Wed, 28 Apr 2010 20:17:37 GMT

Attached my test form - I used the same link I posted earlier with some modfications.

rbuchanan — Wed, 28 Apr 2010 15:47:49 GMT

Thanks. I read through the article but it seems to be for making sure that from a datasource the value can only be picked once.

My problem is that my list I'm trying to use to populate the Drop Down List has a series of values like

I need to see only BE1,BE2,BE3,BE4 in the drop down.

Let me know if I missed something in the article or there's any other information I can provide.

Thanks again for your help.

Aruna Akella — Wed, 28 Apr 2010 05:25:19 GMT

Can you look at this article? - http://www.bizsupportonline.net/infopath2003/shrinking-dropdown-list-repeating-table-infopath.htm - scroll down to the section (Populate the drop-down list box with unique values) where it explains about how to specify filter conditions.

I hope it works for you with minor changes to the filter conditions.

rbuchanan — Tue, 27 Apr 2010 21:21:34 GMT

I'm using infopath 2003 with sharepoint 2007.

I have a form with a drop down list that uses a column from a sharepoint list as a data source.

The column has numerous duplicates but I'm trying to retrive a unique list.

I've been trying trying to stumble my way through trying to create a filter but haven't had much luck.

Any help or suggestions would be great I haven't had much with the posts I've found so far.

Thanks