Answered

filter on browsegallery

(0) Share

Report

Posted on by ZT-15110834-0

I'm trying to filter on multiple columns in the BrowseGallery but I'm getting an error on the Search. Can anyone provide me any help

SortByColumns(
    Filter(
    [@Boekenlijst];
    Search(Boekenlijst; TextSearchBox1.Text;TITEL;AUTEUR) 
    );
     "Title"; If(SortDescending1; SortOrder.Descending; SortOrder.Ascending))
 
 

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Suggested answer

SpongYe 5,909 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello,

Try this:

SortByColumns( Filter( [@Boekenlijst]; StartsWith(TITEL; TextSearchBox1.Text) || StartsWith(AUTEUR; TextSearchBox1.Text) ); "Title"; If(SortDescending1; SortOrder.Descending; SortOrder.Ascending) )

Was this reply helpful? Yes No
Verified answer

mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
hey

can u try this:

SortByColumns( Filter( [@Boekenlijst], TextSearchBox1.Text = "" || (TextSearchBox1.Text in TITEL || TextSearchBox1.Text in AUTEUR) ), "TITEL", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending) )

if my answer helped please mark as verified,

cheers

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,119 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi ZT-15110834-0

Firstly the response from mmbr1606 is correct using the alternate in filter. For your future reference, if you want to use Search, this is the structure
SortByColumns( Search( [@Boekenlijst]; TextSearchBox1.Text; TITEL; AUTEUR ); "Title"; If( SortDescending1; SortOrder.Descending; SortOrder.Ascending ) )

Was this reply helpful? Yes No