I have a SharePoint list look-up field which is working and listing people but it is only showing the results using their surname. How can I change it to show results using their first name as well?
For example, if I type "DOE"
it will only show
I want to show all of them in the option.
Can you share your code and other details that may be relevant, like if you are referring to a gallery and doing searches on it? Anything that will help to get a better sense of what is going on.
You might be using Startswith for filter,
try using Search() function instead
There are no code changes in this look-up field. All functionalities are out of the box. I created the lookup field in Sharepoint. Before "opening" the form in Power App , it is possible to search by typing DOE then the options will list people with Doe as last name AND first name.
After publishing the form from Power App, the search is not listing people with first name DOE.
It is an employee lookup field, type Person or Group. Try creating a SharePoint list with a lookup field, test it then once you open the form in Power Apps then publish it, it breaks the functionality.
I think it is a bug,
when searching for Joseph or David, it will show everyone in the company with Joseph as first and last name but when searching for Joshua or Norman, it will show only people with last name Joshua or Norman
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.