how to create a table of unique values? HELP

(0) Share

Report

Posted on by AaronArias

hello,

im new in Powerapps.

I have a table that depends on some filters. But i need unique value (Id_Cita)

If the solution is a collection, how do I do it?
thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @AaronArias,

Do you want to collect all the Id_Cita from the filtered result?

I think you could directly collect it by adding a button and set its OnSelect property as below:

ClearCollect(colId_Cita,Filter(Data,<your condition>).Id_Cita)

Was this reply helpful? Yes No
AaronArias 3 on at

Like
a
(0)

Report
Copy link

Link copied!

NO, I WANT THE TABLE TO SHOW ONLY THE UNIQUE VALUES. THE ID_CITA COLUMN IS REPEATED

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @AaronArias,

If you want to just display unique Id_Cita with corresponding records, I think you could try the GroupBy() function, which will help you group by the Id_Cita column and have a nested table including all the records sharing the same Id_Cita .

GroupBy(List,"Id_Cita","GroupId")

However, the DataTable is different from the Gallery on grouped records displaying.

The GroupBy() make your original data source changes like below:

Id_Cita GroupId

1298 [Table]

9259 [Table]

And the nested table expands with all the other column values, so if you want to display other column values, you should use AddColumns() to create a temporary column to display.

You could not use the Concat() function on the original field to show the grouped field values because all the other column values are shaped into the GroupId group.

To display other column values, you could set the Items property as below:

AddColumns(GroupBy(List,"Id_Cita","GroupId"),"TitleNew",Concat(Filter(GroupId,Id_Cita=Id_Cita).Title,Title,","))

Was this reply helpful? Yes No