Hide display of duplicate data in a dropdown

I am displaying data in a dropdown where the data in the field has duplicate entries. Iwould like to only display each duplicate entry once.

My dropdown is set to display values from a_dept so it displays ‘Dept 1’ twice because there are 2 records with Dept 1.

How do I limit the dropdown list to display ‘Dept 1’ only once.

Sorry if this is a silly question…I’m new here.

Thanks.

1 Like

After you have entered your search in the drop down element, click in the input box again and you will see :unique as a term you can use. This will do what you want.

Can get slow on many thousand rows.

Thanks Nigel.

I now have :unique elements in the Choices Source however duplicates are still displaying.

Ah, yes you will need to have “type of choices” as Text instead of Approver.

However I would have thought you could use “Department” if it is a thing in its own right, rather than something somebody types in ?

Use grouped by. Shew! That took me like an hour. Do search for ____ :grouped by then it will likely be the same thing you searched for. @michael.nitson and @NigelG .

Prevent Duplicates In Dropdown from table with multiple matching items in data

9 Likes

Absolute Legend

Hello,
I did this to avoid displaying duplicate data.
However, when I need a price corresponding to the chosen value to be displayed, the price is no longer displayed…
Do you know why?