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:
myGroupedTable can be a collection resulting from your GroupBy, or it can be the return from the GroupBy itself.
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.
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:
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.
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.