Hi @Casey-Lee ,
Could you please share a bit more about your scenario?
Do you also want to search your Gallery Items based on the 'Sales Consultant Name' column value (Choice type field)?
If you want to search your Gallery Items based on the 'Sales Consultant Name' column value (Choice type field), you should modify the original Sort formula within the Items property of the Gallery. The Original Sort formula could only be searched by 'Title' column.
I have made a test on my side, please consider take a try with the following workaround:
Set the Items property of the Gallery to following formula:
SortByColumns(
Filter(
[@'Pipeline App'],
StartsWith(Title, TextSearchBox1_1.Text) || StartsWith('Sales Consultant Name'.Value, TextSearchBox1_1.Text)
),
"Title",
If(SortDescending1, Descending, Ascending)
)
or
SortByColumns(
Filter(
[@'Pipeline App'],
StartsWith(Title, TextSearchBox1_1.Text) || TextSearchBox1_1.Text in 'Sales Consultant Name'.Value
),
"Title",
If(SortDescending1, Descending, Ascending)
)
Note: Above formula may face a Delegation warning issue, if the amount of your SP List records is not more than 2000, you could ignore this warning issue. Please set the "Data rows limit for Non-delegable queries" option to maximum value -- 2000 within Advanced settings of App settings of your app.
If the amount of your SP List records is more than 2000, please check and see if the alternative solution I mentioned within the following thread would help in your scenario:
https://powerusers.microsoft.com/t5/Building-Power-Apps-Formerly/Sort-gallery-with-multiple-fields/td-p/379730
https://powerusers.microsoft.com/t5/Building-Power-Apps-Formerly/Delegation-Formula-Help/m-p/394039#M115089
Best regards,
