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

All responses (4)

Answers (0)

Sort by

CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@ajblodgett ,

The code seems right to me ...

Is Subtitle a column from your Sharepoint List ?

Can you show the error you receive ?
ajblodgett 6 on at

Like
a
(0)

Report
Copy link

Link copied!

@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.
CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@ajblodgett ,

Actually yes ... you filter the items from datasource.
mmbr1606 14,629 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@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