Merging Search bar and dropdown list to filter a gallery

Like (0) Share

Report

Posted on 24 Aug 2022 08:54:01 by Chainfire74

Hi,

I've built a power app that has a gallery linked to a Sharepoint list. I've created a search bar that works and also a drop down list that works. But I can't figure out a way for them both to work on the same gallery.

Below is the code for the search bar to be working in the gallery:

Search('External Secondees_1',TextInput2.Text,"field_3")

Below is the code for the dropdown list working in the gallery:

Filter('External Secondees_1',L2 = Dropdown1_1.Selected.Value)

Is it possible to merge these two together so that I can have both working simultaneously?

Thanks in advance

All responses (2)

Answers (0)

Gochix 1,933 Super User 2025 Season 1 on 24 Aug 2022 at 09:17:47

Like (1)

Report
Re: Merging Search bar and dropdown list to filter a gallery

Hi @Chainfire74 ,

What you probably are looking is to have an option to either search items depending if the dropdown is selected and if it is then to filter by it.

Try this :

If( IsBlank(Dropdown1_1.Selected.Value), Search( 'External Secondees_1', TextInput2.Text, "field_3" ), Search( Filter( 'External Secondees_1', L2 = Dropdown1_1.Selected.Value ), TextInput2.Text, "field_3" ) )

_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!
Nogueira1306 7,390 Super User 2024 Season 1 on 24 Aug 2022 at 09:03:51

Like (0)

Report

Re: Merging Search bar and dropdown list to filter a gallery

Search(Filter('External Secondees_1',L2 = Dropdown1_1.Selected.Value),TextInput2.Text,"field_3"

Does that work?

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,

Gonçalo Nogueira

Check my LinkedIn!

My website!