Answered

Filter gallery off value combinations in multiple columns

(0) Share

Report

Posted on by CatOnTheWEb

Hello,

The datasource for an app I'm working on is large, and I want to filter information in the gallery so that by default it only shows unique value combinations, like a multi-column Distinct.

For example, I want to filter the below table,

Apple	Red
Apple	Red
Apple	Green
Banana	Yellow
Banana	Green
Banana	Green

So that the gallery just shows

Apple	Red
Apple	Green
Banana	Yellow
Banana	Green

Any help would be appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

WarrenBelz 154,924 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @CatOnTheWEb ,

I will call the the columns Fruit and Colour - you need the GroupBy function

GroupBy( YourListName, "Fruit" "Colour", "OtherData" )

however, this is not Delegable and will only work on record numbers up to your Delegation limit. How many items are in your list?

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
WarrenBelz 154,924 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @CatOnTheWEb ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
CatOnTheWEb 5 on at

Like (0)

Report
Copy link

Link copied!

Yep sorry, I've busy for the past few days and haven't had a chance to check this. The datasource shouldn't be so large as to run into the delegation issue, I don't think, but having repeat information would have cluttered up the interface too much.

You're solution helped, thanks!

Was this reply helpful? Yes No