Dropdown list showing to many options and how to filter empty/all

Need help
1

I have a dropdown I want to populate with elements from the field “Category”, but I don’t know how to limit the options to only show each categoy once.
As it is now each category item is shown as individual items.

image

How do I “clear” the filter so I can see all elements no matter the category?

2

Using a condition. If the category is empty then the RG data all elements.

1 Like
3

Thanks. I solved the second part with empty/filtrating.

Still unsure about the first.

4

http://joxi.ru/Dr8QQBvTzLLaZm

5

I made changes to the Choises Source so it matches the image you posted.
I cant do the same for Option caption so the dropdown still has all elements.

image

6

You need to add ‘RaskCategory’ in the choices source before the unique elements. At the moment you are just picking a unique type of RiskDescriptions and not the Category.

7

Thanks got it to work.
I needed to convert the decision to text in the Choises source

8

This topic was automatically closed after 70 days. New replies are no longer allowed.