Answered

Button to Filter Gallery

(0) Share

Report

Posted on by Dave-ITMan

Hi Experts,

I have an app that is a ticketing system, within this, you can view all tickets so I have the below code in a gallery and a search box at the top to filter the gallery

Filter(TicketingSystem, 
ID = Value(SharePointSearch.Text) ||
StartsWith(Status, SharePointSearch.Text) ||
StartsWith(ID, SharePointSearch.Text) ||
StartsWith('Created By'.DisplayName, SharePointSearch.Text) ||
StartsWith(Technician, SharePointSearch.Text)
)

I want to add a button at the top so that users can easily click it and it will filter the gallery to only show entries with the status as "Open" but I still want the users to be able to use the search box at the top to filter if they want to, is this possible please?

Thanks in advance!

Dave

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

anandm08 1,936 Super User 2024 Season 2 on at

Like (2)

Report
Copy link

Link copied!
hi @Dave-ITMan ,
Yes, it's possible to add a button to filter the gallery to show only entries with the status as "Open" while still allowing users to use the search box for further filtering. Here’s how you can achieve this:
Insert a button and set its OnSelect property:
Set(varShowOpenOnly, !varShowOpenOnly)

Modify the Items property of your gallery to include the condition for varShowOpenOnly

Filter( TicketingSystem, (varShowOpenOnly && Status = "Open") || !varShowOpenOnly, ID = Value(SharePointSearch.Text) || StartsWith(Status, SharePointSearch.Text) || StartsWith(ID, SharePointSearch.Text) || StartsWith('Created By'.DisplayName, SharePointSearch.Text) || StartsWith(Technician, SharePointSearch.Text) )

Was this reply helpful? Yes No
Dave-ITMan on at

Like (0)

Report
Copy link

Link copied!

Hi @anandm08
That's great thank you so much!
Regards
Dave

Was this reply helpful? Yes No