How to display only search results within a gallery

[tobiasjmichl]

Dear all, 

I`ve just started to try Building my really first power app 🙂 Actually it seems to be so simple but I´m getting really desperate About the following: 

My User Story: 

The User opens the App and simply find one search box. He´s able to enter text and get either a result or the message "This entry doesn`t exist". If the user clears the search box he sees a blank Display again. It´s possible that the end user never see all entries of the Gallery/list behind.

Details:

I`ve got a Gallery depending on a SharePoint List with simply three columns (Name, Name2, Birthdate). I have inserted a TextBox, search Icon and the Gallery on Screen1. I set up a search-Function on the Gallery, connected to the entries in the textfield. Everything works fine so far. My Problems: 

- After the user delets the entry in the textfield, the Gallery turns back to Show all items. But the user should never see all items!

- How do I insert a text message showing "No entry" when no match is found.

Looking Forward to your support! Many thanks!!!! 🙂

[v-bofeng-msft · Accepted solution]

Hi @tobiasjmichl :

Could you tell me:

Do the folleowing scenarios meet your needs——

• When the search bar is empty or the specified record cannot be found "This entry doesn`t exist"
• Otherwise, display the records found through the gallery.

I suggest you can display "This entry doesn`t exist" by adding a label control. Then control the conditions under which they appear by setting the visible attributes of the gallery and label.For example:

1\Add a label control and set it's Text property to:

"This entry doesn`t exist"

set it's visible property to:

IsBlank(SearchBox.Text)||IsBlank(LookUp(YourDataSource,Column1=SearchBox.Tex))

2\Set the Gallery's visible property to

!(IsBlank(SearchBox.Text)||IsBlank(LookUp(YourDataSource,Column1=SearchBox.Tex)))

Best Regards,

Bof

[tobiasjmichl]

Hi Bof,

thanks for your answer and sorry for my late Reply!

I had to Forward this internal request to my colleagues in our IT Department and shared the link to this post to them 🙂 Maybe they can fnish this Project. But your tips seem to be very helpful. I´ll ask them to give you detailed Feedback when finished the Task.

Thanks and Kind regards

Tobias

[AkshaySolanki]

Hi Bof,

Thanks for this solution as it helped me a lot.

A quick question, If I need to search within two columns, lets say I have "First Name" and "Last Name" and I want user to search with either names, how do I add that into the search formula above?

[AkshaySolanki]

Using above link's solution I am able to hide the list but when I try to search using First or Last name, I get all the list results which is the opposite.

I need the user results only what the user types as first name or last name