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 Platform Build Tools

All responses (3)

Answers (2)

Verified answer

WarrenBelz 148,795 Most Valuable Professional on at

Like (1)

Report
filter on browsegallery

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 ) )
Verified answer

mmbr1606 13,193 Super User 2025 Season 1 on at

Like (0)

Report
filter on browsegallery

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
Suggested answer

SpongYe 5,580 Super User 2025 Season 1 on at

Like (0)

Report
filter on browsegallery

Hello,

Try this:

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