Hello - I have an employee roster list on sharepoint that I turned into a basic app that lists the employee names and then when I select their name from the list it shows me the rest of the info on the employee roster. When I try the search field that is defaulted at the top of the app nothing can be found. The "title" in the list as it appears in the app comes from the "Name1" field and that is what I want searched. I tried it to the exact text even as capitalized but I want to be able to search for any letters, groups of letters to select the employee name, not verbatim or case sensitive. What do I need to do to make the search function work?
Hi @Anonymous,
The Search function finds records in a table that contain a string in one of their columns. The string may occur anywhere within the column; for example, searching for "rob" or "bert" would find a match in a column that contains "Robert". Searching is case-insensitive. Unlike Filter and LookUp, the Search function uses a single string to match instead of a formula.
Are u saying that with "Search" function, when you type "lized" for example, the result of capitalized won't return? If so, would you please create a new app with another connection to test?
For your reference:
https://powerapps.microsoft.com/en-us/tutorials/function-filter-lookup/
Regards,
Mona