Answered

Checkbox Single Column Gallery Filter

(0) Share

Report

Posted on by Specthildur

Hi All,

I have a printer supply information screen (sharepoint list based), with a printer selector on the left (which uses a seperate sharepoint list) and a printer hub information in the center. Selecting a printer on the left will populate the gallery screen within the printer hub information screen and tell me what supplies are assigned to that printer. I use the following formula below to sort the gallery field based on the printer choice and if supplies are in stock. The supplies column can have 3 different availability status which are Stock, Used and Discarded.

Filter(Filter('Printer Inventory Stock', 'Printer Name' = Gallery2.Selected.Title),Availability.Value = "Stock")

I've got three check boxes which are - 'Used', 'Discarded' and 'All' as by default it will show me everything in 'Stock'. I'm trying to figure out how to sort the gallery field to show me the results based on if these checkboxes are ticked, while making sure that it's giving me results based on the printer selected on the left. I've tried nesting filters within filters but I can't figure out a way to evenly sort this out.

Any help appreciated thanks!

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Verified answer

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Specthildur - assuming this is the same app as described in your other post, I will modify the other solution to be applicable to this scenario: https://powerusers.microsoft.com/t5/Building-Power-Apps/Filter-Gallery-based-on-another-Gallery/m-p/2569693#M635887

One method:

1. Create another Gallery control with a Title only layout

2. In the Items property of this Gallery control, enter:

Table( {Availability: "Stock"}, {Availability: "Used"}, {Availability: "Discarded"} )

3. Insert a Checkbox control inside the Gallery (so that the control is duplicated per record).

4. In the Text property of the Checkbox control, enter:

ThisItem.Availability

5. On the OnCheck property of the Checkbox control, enter:

Collect( col_CheckboxSelection, ThisItem )

6. On Uncheck property of the Checkbox control, enter:

Remove( col_CheckboxSelection, ThisItem )

7. On the Items property of the printer Gallery, enter:

SortByColumns( AddColumns( Filter( 'Printer Inventory Stock', 'Printer Name' = Gallery2.Selected.Title, Availability.Value in col_CheckboxSelection ), "_Part_Choice", 'Part Type'.Value ), "_Part_Choice", SortOrder.Ascending )
Specthildur 42 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Amik ,

Thank you for help on my posts.

Trying out your instructions seem to work great but I think I've broken it by selecting two check boxes. It's always filtering 'Used' items and 'In-Stock' items, although 'Discarded' items appear to disappear fine. Currently this is what is being shown when the gallery checkbox items are all unticked (as you can see both Used/Instock are filtered). 'Used' always seems to be there no matter but if you tick 'In-Stock' once and untick it will then always show that choice.
Specthildur 42 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Amik ,

Seems like the issue was Modern Checkboxes, I tested on the classic checkbox and it works totally fine! Now I just want to set 'In-Stock' as default but should hopefully be able to do that myself. Thank you so much.
Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Feel free to @ME if you need support on this topic.