Applying dropdown filter and search option in same Gallery table.

(0) Share

Report

Posted on by Aman12345

I have 2 columns in my sharepoint table and based on these 2 columns data. In my gallery table, I need to apply filter to one column and search in other column.

In the attached image, I have to filter with "Make" column ( dropdown filter marked in red), so i have applied following formula to the gallery table and I am getting desired result.

If(DropMaker.Selected.Result="All",'WIS List_1',Filter('WIS List_1',Maker=DropMaker.Selected.Result))

Next I have to display result based on my searchbox, and I have applied following formula and I am getting desired result.

Search('WIS List_1',SearchboxWIS_1.Text,"WISName")

But when I try to apply both formulas to Gallery seperated by a ; then I am getting error in formula bar.

Please help

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Aman12345

Search( If( DropMaker.Selected.Result="All",'WIS List_1', Filter( 'WIS List_1',Maker=DropMaker.Selected.Result ) ),SearchboxWIS_1.Text,"WISName" )

Was this reply helpful? Yes No