good day all!
I have an app that allows for searches through a gallery of a couple thousand entries of a sharepoint. The below snip shows a couple of the boxes that they can put in to search. The box that I am having the problem with is the 'title' box, as nearly every one of our titles are more than one word. However, when you put anything in that box, it only searches the FIRST word of all of the titles and makes a match there. Where should I be looking in order to change the code, so that it responds to ANY match? Note: I thought it might mean changing the 'startswith' to 'search' and that just broke things.
picture of boxes -
Code for the gallery -
Table({Filter: "All"}, {Filter: "My requests"})
code for that box -
//Set(isLoading,true);
//Set(searchQuery,searchInput.Text);
//ClearCollect(collItems, SortByColumns(Filter('CV&S Intake Request',StartsWith("Title",searchQuery)),"Created_Date",Descending));
//Clear(bandItems);
//ForAll(collItems,
// Collect(bandItems,
// Last(FirstN(AddColumns(collItems,
// "RowIndex",
// CountRows(bandItems)+1
// ),
// CountRows(bandItems)+1
// )
// )
// )
//);
//Set(
// totalrecords,
// CountRows(bandItems)
//);
//Set(isLoading,false);
