You’re offline. This is a read only version of the page.
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.
We really understand that you have more than one issue need to be solved today and we are surely happy to help you with those, but to better focus on the new problem and ensure the service quality, we would advise you to create another ticket on the issue.
It can also help us to get the case better recorded and let Microsoft know what you have been through clearly. Thank you so much for your understanding.
Best Regards,
Levi
This was the issue. Once i removed the double quotation mark it work. By any chance would you know how to set a default to a specific employee? Once i clear the value, it stays blank on the gallery. I want to set it back to the top of the hierarchy since this is a department org chart. Any suggestions?
Much appreciated.
Please try removing the double quotes around the column name(Employee).
Share
Report
All responses (
Answers (Filter('Org Chart',StartsWith(Employee,SearchBox.Text))
Best Regards,
Levi
Your formula looks correct. Did you repurpose a different column as the employee column?
#1
WarrenBelz
637
Most Valuable Professional
#2
stampcoin
570
Super User 2025 Season 2
#3
Power Apps 1919
473
