Display Only Unique Options in a List

re: Display Only Unique Options in a List

Crazymaca69 — Fri, 05 Dec 2014 17:36:33 GMT

Hi can anyone tell me how to do this when using an xml source?

Im having to use an xml source to be allow dynamic pictures from a picture library on Sharepoint. I had it working using a normal Sharepoint list but can't figure out what the string should be for xml?

re: Display Only Unique Options in a List

Elmholt — Tue, 13 Dec 2011 15:28:55 GMT

Hi.

I need a filter like this on my dropdown list, but i am not sure how to define the expression

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

What does "my:group2" and "my:field2" refer to?

Show unique rows in a secondary repeating data source table - no code!

Mel Balsamo — Sun, 16 Oct 2011 21:15:21 GMT

When designing an InfoPath form that integrates with a secondary data source such as a SharePoint list

re: Display Only Unique Options in a List

rhallock — Wed, 13 May 2009 16:17:20 GMT

If you haven't figured this out, I'd start by removing the additional condition you have to see if it's the problem.

re: Display Only Unique Options in a List

granack — Tue, 05 May 2009 20:59:46 GMT

I'm having a problem with the filter including all of the values. I'm using the following from a secondary data source:

not(. = ../preceding::dfs:_18-740-886-402_pg14/@kV)

I also have an additional condition that the name from the Main data source match the name from the secondary (sharepoint list) (i.e. BreakerSelection is equal to Type1). This is in order to determine which kV data to return to the list

The data I am testing for this filter is 4.76, 8.25, 8.25, 8.25, 15, 15, 15, 15, 15, 15, 15

The filter only returns 8.25 and 15 for the dropdown, why is it not including 4.76 since it is itself a unique value?

re: Display Only Unique Options in a List

rhallock — Wed, 21 Jan 2009 22:44:27 GMT

For a Secondary Data Source, the steps are the same but your XPath will look a bit different.

For example, my secondary data source looks like the following:

/dfs:myFields/dfs:dataFields/dfs:Program_Fee_Reports/@Partner

For the filter expression, my XPath looks like this:

not(. = ../preceding::dfs:Program_Fee_Reports/@Partner)

re: Display Only Unique Options in a List

dave_2k8 — Thu, 11 Dec 2008 11:12:05 GMT

rab2k - Did you ever find a solution to you issue with pulling unique values from a SharePoint list.

I am looking to do the same - but cannot find a way to do it.

Thanks..Dave

re: Display Only Unique Options in a List

rab2k — Tue, 08 Jul 2008 05:26:26 GMT

Greg - Could you provide the syntax for pulling unique values from a SharePoint list? I am using a Sharepoint List with duplicate values to populate the InfoPath Sharepoint dropdown, but would like it to only display unique values.

re: Display Only Unique Options in a List

Lalato — Mon, 14 Apr 2008 17:08:24 GMT

Never mind... I figured out my problem. Thanks for the great info.

--sam

re: Display Only Unique Options in a List

Lalato — Mon, 14 Apr 2008 17:05:30 GMT

Will this same logic work for a secondary data source? I would like to do this with an XML file, but I keep getting duplicates.

Thanks,

--sam

re: Display Only Unique Options in a List

Greg Collins — Tue, 15 Jan 2008 17:53:01 GMT

Thank you zaphi, I'm glad to hear you got it working!

re: Display Only Unique Options in a List

zaphi — Mon, 03 Dec 2007 08:46:39 GMT

Hi Greg

Sorry, I had a problem with the german syntax. I could correct it, and it works correctly.

Your how-to is very good!

Best regards.

Philippe

re: Display Only Unique Options in a List

zaphi — Fri, 30 Nov 2007 15:45:45 GMT

Hi Greg

Sorry, but I have done exactly this sampler like explained, but I get duplicates in the list.

I have infoPath 2003 SP2, and work in german.

Can you explain it?

Best regards.

Philippe