Filter a Gallery with Buttons

(0) Share

Report

Posted on by KristyH

Hi All

I am having trouble filtering my Gallery Results with buttons.

At the moment, I have the multiple buttons in a Container. I have 3 sets of what i want to filter.

1. Request Type - All plus 5 specific options

2. Allocated to - Unallocated, Other plus 3 employee names

3. Progress - Not Started, In Progress, Completed, Cancelled

I want to be able to pick any of the options to filter down my gallery list.

for example, I would click one of the Request Type butons, then an Allocated to name, then Progress. Then if i want to revert to all request types (select All button) I want to ensure all other filters are retained deselected.

I also have the Client Name Search Box working on Items of Gallery: Search('DataSource',SearchBox.Text,"ClientName")

but i am not sure if i need to put the filter items for the buttons in the gallery, and if so, what code.

Thanks for your assistance

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @KristyH ,

Is it possible that uses will select multiple options for a single criterion? For example, Not Started, In Progress, Completed all selected for Progress, which means the user would like to filter items match three progress status.

Best regards,

Was this reply helpful? Yes No
KristyH 63 on at

Like
a
(0)

Report
Copy link

Link copied!

yes that is possible. i want to be able to use the filter for the multiple filters

Was this reply helpful? Yes No
KristyH 63 on at

Like
a
(0)

Report
Copy link

Link copied!

any updates on this team?

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @KristyH ,

I had some thoughts. In short words, there needs to be three collections for the three sets of buttons.

OnSelect of 5 buttons for Request Type:

Collect(colRequestType, {Value:Self.Text})

OnSelect of 5 buttons for Allocated to:

Collect(colAllocatedTo, {Value:Self.Text})

OnSelect of 4 buttons for Progress:

Collect(colProgress, {Value:Self.Text})

OnSelect of "All" Button:

Clear(colProgress);Clear(colRequestType);Clear(colAllocatedTo)

To filter using selected options, formulas could be as follows:

Filter(Search('DataSource',SearchBox.Text,"ClientName"), If(!IsBlank(colRequestType), 'Request Type' in colRequestType.Value, true), If(!IsBlank(colAllocatedTo), 'Allocated To' in colAllocatedTo.Value, true), If(!IsBlank(colProgress), Progress in colProgress.Value, true))

Best regards,

Was this reply helpful? Yes No
KristyH 63 on at

Like
a
(0)

Report
Copy link

Link copied!

hi @v-jefferni i have tried your suggestion above, however there is no data showing in my gallery. even when pressign the buttons, it has not shown any results. my galelry is just blank

Was this reply helpful? Yes No