I am looking for a simple way to exclude a certain text string from a gallery search results box.
I am currently using
Which works as intended to return results based on what the user types into the search field.
However i have some users that are added to the data source temporarily that i do not want showing up in the search. These users all have the same "FullName" as TEMP.
Is there a way to search the data source by what the user types in but exclude any results that match the string "Temp"?
Solved! Go to Solution.
Thanks @PowerAddict I had to modify your code just a little but it works great thank you. Nothing to major just had to add a extra parenthesis after "Temp".
Search(Filter(datasource, !('Full Name' = "Temp"),SearchInput.Text,"FullName")
Search(Filter(datasource, !('FullName' = "Temp")),SearchInput.Text,"FullName")
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
Learn how to build the business apps that you need.