Group Galleries After Filtering

(0) Share

Report

Posted on by dee_han

Hi All,

I am creating a dashboard to monitor all the items in my store:

After I select the Brand in the dropdown list, the gallery below will show all the Items of the Brand selected, also with the quantity of the Items. I stored my database in SharepointList like this:

I want the same Item to only appear once. But the gallery still displays Items in duplicate, because they have not been grouped.

I looking for your help. Thank you

Categories:

Building Power Apps

All responses (4)

Answers (2)

Sort by

Verified answer

WarrenBelz 156,570 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @dee_han ,

I am not sure what you are doing with Status - also replace xxxx with the output (Value/FieldName ) of your Brand drop-down.

AddColumns( GroupBy( Filter( SPList, Brand = YourBrandDD.Selected.xxxx ), "Brand", "Item", "Grouped" ), "Quantity", First(Grouped).Qty )

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.

MVP (Business Applications) Visit my blog Practical Power Apps
dee_han 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz,

Now I have no idea about how to display the list of grouped items in the gallery:
It comes with "false", I put the formula with "ThisItem.IsSelected"
Ignore the number 0 in the image

Thanks.
Verified answer

WarrenBelz 156,570 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@dee_han ,

Your fields should be (with ThisItem. before) Brand, Item and Quantity
dee_han 12 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz,

It works! Thanks for your help 😊