I'm using this to populate a gallery and it's fine:
Distinct('The List', TheUserId)
which populates a gallery item text with:
ThisItem.Result (as it only contains TheUserId).
but I'd like to display more than one piece of information in the gallery for each result:
is there a way for ThisItem.Result to have access to multiple columns from the list?
I can do it using another query in the gallery item:
First(Filter( 'The List', TheUserId = ThisItem.Result)).TheUserName
hi @codebrane i think GroupBy('The List', TheUserId,SomeColumnName) will be best if you need added columns but maybe there is another way, i will keep my eye on this.
the gallery will have ThisItem.TheUserId and First(thisItem.omeColumnName).TheUserName
Or have alook a tthis if this is more what you llooking for: Solved: Make a distinct with many columns (like in SQL) - Power Platform Community (microsoft.com)
hope it helps
Hope it helps.
Check out our new profile badges recognizing authored solutions!
We are excited to announce the Power Apps Super Users!
Did you miss the call? Check out the Power Apps Community Call here.