Search gallery only when button is pressed

(0) Share

Report

Posted on by Tango

1,164

Hi,

Is it possible to search a Sharepoint list/gallery ONLY when a button is pressed.

Think a complex search that would require adding columns

This would be in addition to some simple search boxes that already exist and are all working fine.

Thanks in advance for any tips

Todd

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Rusk 1,369 Super User 2024 Season 1 on at

Like (1)

Report

I believe the answer is "yes". You can use your button to set a variable, if the variable is true then show your "complicated" gallery instead of the normal one... something like that could work

Was this reply helpful? Yes No
BCBuizer 22,505 Super User 2025 Season 2 on at

Like (1)

Report
Hi @Tango ,

If I understand correctly, you wish to add some condition to the Items property that is triggered by keeping a button pressed. You can use the Pressed property for this:

If( Button1.Pressed, // Statement for when the button is pressed , // Statement for when the button is not pressed )

Was this reply helpful? Yes No
Tango 1,164 on at

Like (0)

Report

Thanks @BCBuizer @Rusk Is it possible to point the results to a gallery?

My thinking is just on select filter(listname,Current = true)

But how do I send those results to the existing gallery?

Cheers

Todd

Was this reply helpful? Yes No
Rusk 1,369 Super User 2024 Season 1 on at

Like (0)

Report

You could add a Filter formula to your Gallery Items:

If(varButton,Filter(DataSource...) If you provide an example of your current Gallery formula, and the filtering you want to apply, I could give you a better example

Was this reply helpful? Yes No
Tango 1,164 on at

Like (0)

Report

The gallery and its fields will be the same for a simple or complex search. Its just that the actual searching will be more complex and search deeper in to some other related Sharepoint lists

Was this reply helpful? Yes No
Tango 1,164 on at

Like (0)

Report

Its also about not loading or performing any of the complex tasks, unless and only if the button is pressed

Was this reply helpful? Yes No
Verified answer

Rusk 1,369 Super User 2024 Season 1 on at

Like (1)

Report

Got it. It should be as simple as using an If statement to check for the button press. If true, then use the complicated filter. If false, use your normal filter.

Was this reply helpful? Yes No
Tango 1,164 on at

Like (0)

Report

@Rusk Thanks for that. My if statement is quite long as it is. Was hoping to have this filter somewhere seperate

Was this reply helpful? Yes No