Distinct

[Sudhavi_84]

Hi

I have a list and it has duplicate values.

I want to bring only disticnt values in to Gallery

I created Screen-->Gallery and selected datasource.. it is displaying all duplicates as well

Specified as Distinct(Table.Field) but is coming error

Any leads please? did google and tried in various ways.

Thank you in advance

[PG_WorXz10]

Hi @Sudhavi_84 ,

Please try 

Distinct(TableName,ColumnName) 

Result will show only Distinct values of one ColumnName by using Distinct(TableName,ColumnName).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.

[Sudhavi_84]

Thanks @PG_WorXz10  for your quick response

I selected datasource in to Gallery, I can see all duplicates too which is perfect and now I want to display Unique field from that particular field.

All Prj is Table Name in List

Category is Field name from All Prj table

I updated formula as you specified Distinct('All Prj',Category).Result

But it says asDistinct('All Prj',Category).Result=  "There is an error in this formula. try revising the formula and running it again"  Data Type:Table

Do you know what I am doing wrong here?

[PG_WorXz10]

Hi @Sudhavi_84 ,

In which Control are you trying to add this Distinct value ? 

Is it a dropdown ? or something else 

[Sudhavi_84]

Hi @PG_WorXz10 ,

Inside Gallery, I clicked on pencil(Edit) button, so it a Label not dropdown

[PG_WorXz10]

Hi @Sudhavi_84 ,

Is not possible to bind a collection type data source in a Label type. You will have to use collection type controls like dropdown, combobox or gallery. 

Otherwise please modify your requirement. 

[Sudhavi_84]

Thanks @PG_WorXz10 

I will create dropdown then and will let you know.

Thank you for letting me know.

[PG_WorXz10]

@Sudhavi_84 ,

Sure. Let me know if any help required further.

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.

[Sudhavi_84]

hI @PG_WorXz10 ,

I added dropdown control into Gallery, and renamed function as Distcinct('Tablename",FieldName)

But it is displaying only one unique field when I click on play button, and I have 2 different values in List.

Anything I am doing wrong here please help

[PG_WorXz10]

Hi @Sudhavi_84 ,

Does your datasource has more than 500 items currently ? 

Also Try 

Distinct(SourceName,FieldName).Result