unque values in dropdown list

J

Jayco

I'm trying to populate a dropdown list with values from a sharepoint list.
The values repeat and I want to show unique values only. I have found
discussions on how to filter unique by using a code similar to ". = not(. =
preceding::my:field1)" but that only works when populating the list from
repeating tables within the form. I cannot figure out how to alter this code
to work for a secondary data connection. Any ideas?
 
S

S.Y.M. Wong-A-Ton

Replace my:field1 by the field in the secondary data source that is being
used to populate the dropdown list box. Your filter expression on the
dropdown list box should look something like:

not(. = preceding::<field_in_secondary_ds>)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

dropdown depending on second dropdown / filter problem 0
Word VBA - Automatic change content of a cell in table using dropdown list 5
How to Submit rows of a repeating table to a SharePoint list 1
list or combo box 0
How to use/create code in MS Word to calculate age? 0
Populate a field from a Secondary Data Connection from a query valueof a dropdown list 3
Copy data from SharePoint list to InfoPath Form 0
Dropdown list values in color 0

Top