Exclude a string from gallery search

(0) Share

Report

Posted on by stephenJames

286

Hello

I am looking for a simple way to exclude a certain text string from a gallery search results box.

I am currently using

Search(datasource,SearchInput.Text,"FullName")

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"?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

PowerAddict 7,316 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

You can combine Filter and Search with something like this:

Search(Filter(datasource, !('Full Name' = "TEMP"),SearchInput.Text,"FullName")

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit(Haman)

Was this reply helpful? Yes No
stephenJames 286 on at

Like
a
(1)

Report
Copy link

Link copied!
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".

Original
Search(Filter(datasource, !('Full Name' = "Temp"),SearchInput.Text,"FullName")
Modified
Search(Filter(datasource, !('FullName' = "Temp")),SearchInput.Text,"FullName")

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Yea my bad. Glad it worked!

Was this reply helpful? Yes No