I'm trying to create a search box that search for Employee name from a SP List with the column name "Employee"; however, when I type in a name it does not pull in the result from the gallery. The gallery becomes blank. The name is there.
syntax used on the gallery Item property Filter('Org Chart',StartsWith("Employee",SearchBox.Text))
The column type is a single line of text in SP list and the Employee name is in full ex. " John Smith" if that helps.