Hello,
I have a sharepoint dataset with many columns,
I try to add a text input to filter the gallery.
The filter function works fine if I use:
Filter('24/7 Client',StartsWith('First Name',TextSearchBox1.Text))
However the filter function return zero result if replace first name with last name:
Filter('24/7 Client',StartsWith('Last Name',TextSearchBox1.Text))
It shows no error at all. I also used the 'Last Name' in card and it works fine:
"Client Name: " & ThisItem.'First Name' & ThisItem.'Last Name'
I have checked the sharepoint settings. Both are set as single line text.
Anyone has a idea why this is happening?
