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

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

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

Like (0)

Report
@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 )

Was this reply helpful? Yes No
Specthildur 42 on at

Like (0)

Report

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.

printerscreen.png

Was this reply helpful? Yes No
Specthildur 42 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report

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

Was this reply helpful? Yes No