Power Platform Community Forum Thread Details

Hi everyone,

I have an app with a gallery and a search bar. The search bar will search through the gallery but right now it only searches for one criteria, the scheduled date. I'd like to add other columns and information to be searchable through this as well.

I have this formula in the Items property of my search bar, how could I modify it to include more criteria to search through, such as my data card called 'API' which is considered "field_5"?

SortByColumns(
FirstN(
SortByColumns(
Filter(
[@'SharePointListNameHere'],
StartsWith('Scheduled Date', TextSearchBox1.Text)
),
"field_1",
SortOrder.Descending
),
15
),
"field_1",
If(SortDescending1, SortOrder.Ascending, SortOrder.Descending)
)