Answered

Filter Gellery Then By Text Search

(0) Share

Report

Posted on by Barber_Chris

Hi,

I have a gallery that filters my suppliers by there supplier code which works fine. I now need to add a search bar to my gallery so i can filter for individual invoices.

I am using the following code but its not showing results.

SortByColumns(Filter('Supplier Invoices',Title=Gallery2_16.Selected.'Supplier ID' && 'Invoice Number'=Search_1.Text),"ReceivedDate",Descending)

Any helps is appreciated.

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,748 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Barber_Chris ,
Your text is valid if all the control references are.
Try this first - make the Default of Search1 (I assume this is the name of your Text Control) "" (two double quotes or an empty string), then put this in the Items of the Gallery
SortByColumns( Filter( 'Supplier Invoices', Title=Gallery2_16.Selected.'Supplier ID' && StartsWith('Invoice Number',Search_1.Text) ), "ReceivedDate", Descending )
and see what happens when you start typing text (you should see all results filtered on Title before this)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Barber_Chris 99 on at

Like
a
(0)

Report
Copy link

Link copied!

That worked a treat, thanks!

If i wanted to search more columns from the same search box how could i modify it?

Regards,
Chris
WarrenBelz 156,748 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Barber_Chris ,
SortByColumns( Filter( 'Supplier Invoices', Title=Gallery2_16.Selected.'Supplier ID' && ( StartsWith('Invoice Number',Search_1.Text) || StartsWith(YourOtherField,Search_1.Text) ) ), "ReceivedDate", Descending )