How to add search text box for gallery along with another existing filters in gallery?

(0) Share

Report

Posted on by DineshK_

207

Hi Experts,

I am using a form with gallery with the formula as below :

If(Dropdown1_1.Selected.Value = "All",'Delivery Updates', Dropdown1_1.Selected.Value = "All",Filter('Delivery Updates','Delivery Manager Name'=Dropdown1.Selected.Value),Dropdown1.Selected.Value = "All",Filter('Delivery Updates','Portfolio Head'=Dropdown1_1.Selected.Value),Filter('Delivery Updates','Delivery Manager Name'=Dropdown1.Selected.Value && 'Portfolio Head'=Dropdown1_1.Selected.Value))

I have added search box to filter the gallery , so if already have a filters on gallery page , how to add one more filters for search box?

i have tried to add filters based on the search textbox as the below but invalid arguments errors occurred.

Please suggest ..

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Shravyashree_01 174 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @DineshK_ , Im not very clear here. But Im assuming that your filter works fine and you want to add search to the filtered items

you can try , here column1, column2.. are the columns you would want to apply search for

Search( If(Dropdown1_1.Selected.Value = "All",'Delivery Updates', Dropdown1_1.Selected.Value = "All",Filter('Delivery Updates','Delivery Manager Name'=Dropdown1.Selected.Value),Dropdown1.Selected.Value = "All",Filter('Delivery Updates','Portfolio Head'=Dropdown1_1.Selected.Value),Filter('Delivery Updates','Delivery Manager Name'=Dropdown1.Selected.Value && 'Portfolio Head'=Dropdown1_1.Selected.Value)) , Search_Input.Text , column1, column2 )

Here the source of your search is the filtered data.

Let me know if this helps

Was this reply helpful? Yes No
DineshK_ 207 on at

Like
a
(0)

Report
Copy link

Link copied!

@Shravyashree_01 Yes the same i have applied and works cool 🙂
Thanks for your solution 🙂

Was this reply helpful? Yes No