Unanswered

Search multiple columns of data in sharepoint list gallery

(0) Share

Report

Posted on by ajblodgett

I am using the default filter which is only searching the title of each card, however I am unable to get the gallery to allow me to search other data points on the card.

This is the working code:

SortByColumns(Filter([@'TBC Staging Inventory'], StartsWith(Title, TextSearchBox1.Text)), "Title", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))

This is what I want to make work:

SortByColumns(Filter([@'TBC Staging Inventory'], StartsWith(Title, TextSearchBox1.Text) || StartsWith(Subtitle, TextSearchBox1.Text)), "Title", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

CU-18081211-6 9,270 Moderator on at

Like (0)

Report

@ajblodgett ,

The code seems right to me ...

Is Subtitle a column from your Sharepoint List ?

Can you show the error you receive ?

Was this reply helpful? Yes No
ajblodgett 6 on at

Like (0)

Report

@gabibalaban

The Subtitle is referring to the subtitle of the gallery card. Please correct me if I'm wrong that it needs to refer to the a column in the sharepoint list.

See attached photo.

Screenshot 2024-0...

Was this reply helpful? Yes No
CU-18081211-6 9,270 Moderator on at

Like (0)

Report

@ajblodgett ,

Actually yes ... you filter the items from datasource.

Was this reply helpful? Yes No
mmbr1606 14,605 Super User 2025 Season 2 on at

Like (0)

Report
@ajblodgett

can you try this please:
SortByColumns( Filter( [@'TBC Staging Inventory'], StartsWith(Title, TextSearchBox1.Text) || StartsWith(Subtitle, TextSearchBox1.Text) || StartsWith(AnotherColumn, TextSearchBox1.Text) ), "Title", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending) )

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No