cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Gorilla_8
Super User
Super User

Distinct a GroupBy on one dropdown

I got a GroupBy on my OnStart:

GroupBy( TableWithTheDataSource; "a";"b";"c";"d";"e";"NameOfTheColumn")

 

So I want to Distinct(NameOfTheColumn;Choices)

 

How I can do that?

 

25 REPLIES 25
Gorilla_8
Super User
Super User

@BCLS776 

 

He got the "Title" column from the list, not the data from the column "COORD_x002e__x0020_ADILIS" in the table "itemChoices"

 

Please revise the code to use a column, other than Title, that contains the items you want to run the Distinct function on. I used Title as an example only as I don't know which column from your table is the correct one to use.

_________________________________________________________________________________________
Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.
Gorilla_8
Super User
Super User

@BCLS776 

 

Yes, but its not showing result on dropdown

BCLS776
Super User
Super User

I realize your dropdown is not working, and I do want to help you with it. However, I cannot examine your app for myself and need you to provide more information to indicate what is going on.

 

Are you able to share what your collection looks like now that we have used AddColumns to modify it?

_________________________________________________________________________________________
Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.
Gorilla_8
Super User
Super User

@BCLS776 

 

Gorilla_8_0-1628204100023.png

 


@Gorilla_8 wrote:

@BCLS776 

 

Gorilla_8_0-1628204100023.png

 


As we can see from your screenshot, ItemChoices still has nested records within it. Have a look inside of there to see if we need to go one level deeper, or if there are further levels of abstraction. The Distinct function doesn't work with records, so keep going with AddColumns or . references until we get to a simple data type. 

_________________________________________________________________________________________
Help the community help more users by choosing to "Accept as Solution" if this post met your needs. If you liked the post and want to show some appreciation, please give it a Thumbs Up.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,408)