Answered

How do i fix distinct not working properly?

(0) Share

Report

Posted on by riley2

i am using distinct to make the list only show distinct names but for some reason it shows the distinct points for a name and not only the name. sorry i don't really know how to explain this because I've never experienced it before.

Categories:

Building Power Apps

I have the same question (0)

All responses (19)

Answers (1)

leonsig93 229 on at

Like (0)

Report
Copy link

Link copied!

I don't think you need that ForAll around the Distinct if all you're trying to get is a list of all the names.

Distinct wants a table first, then the column you want to filter down to unique values.

Used a formula instead of a collection but it should all be the same:

Was this reply helpful? Yes No
riley2 22 on at

Like (0)

Report
Copy link

Link copied!

I'm using it for a text box, also the table is already created in a datastore legacy system table that has a separate column for the name and another for the points.
I cant distinct a singular column because then it will only show said column where as i need it to show the points column too in the collection

Was this reply helpful? Yes No
leonsig93 229 on at

Like (0)

Report
Copy link

Link copied!

Oh so you're trying to create a gallery that has a row per person not just a control, gotcha.

So you still wouldn't use ForAll, but it does change how you'd go about it. Distinct will only ever give you a one column table (see Distinct Function)

Are you trying to add up the points and show them as a total or do you need to show them individually?

Was this reply helpful? Yes No
riley2 22 on at

Like (0)

Report
Copy link

Link copied!

you can make it show all the columns for each row using ThisRecord with a forall instead of just the name of the column you want to distinct. the only issue im having is its showing a row for each of the names that have a different amount of points

Was this reply helpful? Yes No
leonsig93 229 on at

Like (0)

Report
Copy link

Link copied!

Right, but I think adding ThisRecord is sort of contradicting the Distinct. It won't throw an error but I don't think it will give you one row per name.

You're trying to get something like this right?

Was this reply helpful? Yes No
riley2 22 on at

Like (0)

Report
Copy link

Link copied!

no, im trying to get this with a single collection (i currently use a separate collection for the points and another collection for the names and because of this im not able to sort it by the points since the gallerys items is used to distinct the names in the first collection so im trying to do it with 1 collection)

Was this reply helpful? Yes No
Verified answer

leonsig93 229 on at

Like (0)

Report
Copy link

Link copied!
Okay this should be it. I left the inside gallery just to show the Points and then summed them.
What you need is to use GroupBy function and then you can use the Sum function to add up the Points table it creates

So your items property turns into (replace fmlDistinct with your 'newcollection')
AddColumns( GroupBy( fmlDistinct, Name, Points ), PointTotal, Sum( ThisRecord.Points, Points ) )
Doing it this way lets you use the collection you made and simply add a new column that totals the points for the person.

Was this reply helpful? Yes No
riley2 22 on at

Like (0)

Report
Copy link

Link copied!

it seems to work but the points are being weird, it doesnt show the points

Was this reply helpful? Yes No
leonsig93 229 on at

Like (0)

Report
Copy link

Link copied!

What's in your text field/whatever your using to display the points total?

Was this reply helpful? Yes No
riley2 22 on at

Like (0)

Report
Copy link

Link copied!

i am just using thisitem.pointtotal
it comes up with this

Was this reply helpful? Yes No