Preface: I'm pretty new to PowerApps. I have a gallery that is linked to a SharePoint List. I want to be able to search across all fields with one search box. I can get it working when searching for 1 field but when I try to modify it to search across multiple fields, it breaks.
SP Online List Name: Data Stewards
Fields: Area, Steward Name, Type of Steward
Working function when searching across 1 field: SortByColumns(Filter([@'Data Stewards'], StartsWith(Title, TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending))
What modifications need to be made to the above function to be able to use 1 search box and search across all 3 fields?
Solved! Go to Solution.
I appreciate everyone's feedback/suggestions. I got it working withe name field but when I try with Type or Business Area, it says that the type is unsupported for evaluation. All 3 of these fields are single lines of text in the SharePoint list.
Update - Just got this working. Apparently I was choosing the wrong field.
Hi, I am unsure of how to combine two search functions together. For instance, I have
Search('PC',txtRF.Text, "and the column name")
Search('PC',txtPF.Text, "and the column name")
They both work individually but, I am unsure how to combine both of them.
how would I go about with two different text boxes with two different columns? So I want a search for RF which is one filter and then another text box for PF so it is another filter box. I don't want to combine them into the same box.
@kendallsmith I haven't nested searches, but I know you can nest Filters. Here's an example:
I'd simply add "OR" with more "StartsWith" columns, noting that if the columns have multiple words and spaces to use apostrophes (see 3rd example column):
Or StartsWith('Steward Name', TextSearchBox1.Text)
Or StartsWith('Type of Steward', TextSearchBox1.Text)
), "Title", If(SortDescending1, Descending, Ascending))
Note: I left "Title" as the SortDescending1, Descending, Ascending, but that could be changed to a different column.
Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.
Your chance to join an engaging competition of Power Platform enthusiasts.