Distinct a GroupBy on one dropdown

[Gorilla_8]

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?

[Gorilla_8]

@BCLS776 

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

[BCLS776]

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.

[Gorilla_8]

@BCLS776 

Yes, but its not showing result on dropdown

[BCLS776]

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?

[Gorilla_8]

@BCLS776 

[BCLS776]

---

@Gorilla_8 wrote:

@BCLS776 

---

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.