Announcements
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?
Put something like this into your dropdown Items:
Distinct(myGroupedTable, NameOfTheColumn).Result
myGroupedTable can be a collection resulting from your GroupBy, or it can be the return from the GroupBy itself.
@BCLS776
Thanks for the help!I got this:
And this on my "Items":
So, why he didn't show:
@Gorilla_8 wrote:@BCLS776 Thanks for the help!I got this: And this on my "Items": So, why he didn't show:
That issue is probably to do with grouping by five different columns (a,b,c,d & e in your example). Try grouping by one column to start, so you can see if you are getting the collection you want.
The same result with one or two columns
When grouping by one column, can you view the collection and verify that the column named NameOfTheColumn contains values that are not nested records? See example:
Distinct on this collection produces this:
Yes, I can see this:
All the column have multiple names, but one column has two differents values
I'm on my phone, so it's tough to see, but that does not look like a collection grouped by a single column. Are you using the right one?
Yes, I put this on my OnStart:
ClearCollect(ColecaoGSL;GroupBy( TabelaAuxiliar; "COORD_x002e__x0020_ADILIS";"TST_x0020_ADILIS";"AUDITOR_x0020_01";"AUDITOR_x0020_02";"AUDITOR_x0020_03";"NomeDoAvaliadorGSLTST"))
Can you please modify your GroupBy so it groups by only one column? The collection will look much different (and work better) if you can do that.
Same result:
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 547
WarrenBelz 444 Most Valuable Professional
Valantis 322
