Hello all,
I have a search that’s pulling from a SharePoint list with the column being name
for example Smith, John
Filter(list, startswith(NAME, textsearchbox1.text)
this works but will only search for last name since the first name is separated by the comma
is there a way to search both last name and first name by adding something that says to keep going after the comma? Or even a ‘contains’ rather than ‘startswith’ I looked around and couldn’t find anything specifically on this issue.
