Answered

Error when created search box and dropdown filter in Gallery

(0) Share

Report

Posted on by Pammie

Hi all, Could you help me to fix this formula? I have one search box and 2 dropdown filter boxes and its error on these below formula.

Filter('AllStock 1609S',
Dropdown1.Selected.'Project Name'=Blank() Or 'Project Name'=Dropdown1.Selected.'Project Name',
Dropdown1_1.Selected.Zone=Blank() Or Zone=Dropdown1_1.Selected.Zone);

SortByColumns(Search([@'AllStock 1609S'], TextInputStockDisplay.Text, "cr746_stockid", "cr746_projectname","cr746_btsmrtairportlink","cr746_houseno","cr746_description","cr746_address"),"cr746_id",SortOrder.Descending)

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (1)

Sort by

BCBuizer 22,831 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Pammie ,

You need to nest the filter in your existing formula, rather than adding it as an extra formula:

SortByColumns( Search( Filter( 'AllStock 1609S', Dropdown1.Selected.'Project Name'=Blank() Or 'Project Name'=Dropdown1.Selected.'Project Name', Dropdown1_1.Selected.Zone=Blank() Or Zone=Dropdown1_1.Selected.Zone ), TextInputStockDisplay.Text, "cr746_stockid", "cr746_projectname","cr746_btsmrtairportlink","cr746_houseno","cr746_description","cr746_address" ), "cr746_id", SortOrder.Descending )

Was this reply helpful? Yes No
Pammie 22 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you sir, its not error but not showing the item in gallery when i try to either searching or filter one of them. do i miss something?

Was this reply helpful? Yes No
BCBuizer 22,831 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Pammie ,

Can you share an example of what is not working? From first looks the formula seems fine.

Was this reply helpful? Yes No
Pammie 22 on at

Like
a
(0)

Report
Copy link

Link copied!

@BCBuizer here. the formula seems fine, no error but its not showing the result of filter

Was this reply helpful? Yes No
BCBuizer 22,831 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Pammie ,

I meant to give an example of a record you would expect to see, together with the values set for DropDown1, DropDown1_1 and TextInputStockDisplay.

Was this reply helpful? Yes No
Pammie 22 on at

Like
a
(0)

Report
Copy link

Link copied!

@BCBuizer i expected to see the lists in gallery when selected either DropDown1 or DropDown1_1 or TextInputStockDisplay, it should be work individually.

Was this reply helpful? Yes No
BCBuizer 22,831 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Pammie ,

Let's try to eliminate where the issue is. Can you use the below for the Items property of the gallery and see if you are now able to filter using the DropDown controls?

Filter('AllStock 1609S', Dropdown1.Selected.'Project Name'=Blank() Or 'Project Name'=Dropdown1.Selected.'Project Name', Dropdown1_1.Selected.Zone=Blank() Or Zone=Dropdown1_1.Selected.Zone)

Was this reply helpful? Yes No
Pammie 22 on at

Like
a
(0)

Report
Copy link

Link copied!

@BCBuizer yes, it works perfectly for filtering by dropdown.

Was this reply helpful? Yes No
BCBuizer 22,831 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Pammie ,

All right, and when you use just the Search part?

SortByColumns(Search([@'AllStock 1609S'], TextInputStockDisplay.Text, "cr746_stockid", "cr746_projectname","cr746_btsmrtairportlink","cr746_houseno","cr746_description","cr746_address"),"cr746_id",SortOrder.Descending)

Was this reply helpful? Yes No
Pammie 22 on at

Like
a
(0)

Report
Copy link

Link copied!

@BCBuizer just for the search part, it's working well. please suggest...

Was this reply helpful? Yes No