Distinct function for combobox is populating blanks

[Barak_S]

Hey guys, im trying to do a simple thing - I have a SP List in which the "Title" column have some duplicate values.
In my app, i would like to populate a combobox with all the UNIQUE "Title" values using the Distinct function, but when im doing it, im getting only blanks:

Any idea why and how can i fix this?

**BTW the "Title" column is text.

Thanks

[WarrenBelz]

Hi @Barak_S ,

Firstly that syntax is correct if test1 is the name of your list and Title is a Single Line of Text column containing values.

A combo box will not show a value until a selection is made. Just for a debugging exercise, put this

Sort(
   Distinct(
      test1,
      Title
   ),
   Result
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[Barak_S]

Works Perfect now!
Why did i need to put in in "sort" and what is "Result"?  Thanks!

[WarrenBelz · Accepted solution]

@Barak_S ,

Just a little bug I have struck before - not sure why it happens at random times. Result is the output of an Distinct Filter.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.