cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bruce
Level: Powered On

Search Bar Help

Hi All,

Trying to create a search bar that will allow a user to search for the name of a product within a sharepoint list, cant seem to get it to work though.

The column of interest is called Title

Thanks in advance 🙂

5 REPLIES 5
Power Apps Staff CarlosFigueira
Power Apps Staff

Re: Search Bar Help

You can use any control that displays multiple items (e.g., gallery, dropdown, listbox), and in its Items property use the Search function that searches within that list for the value in a text input control. For example:

Search(SharePointListName, TextInput1.Text, "Title")

As the user types the name of the product in the text input control, the list of products that is displayed will be filtered to only those whose title contain the name. At that point, the user can select one of the items, after which you can take some action based on the selection.

bruce
Level: Powered On

Re: Search Bar Help

Hi Carlos,

I have already used the "items" section of my gallery to filter and sort my share point list based on other criteria, is there a way I can add the search funcction in as well ?

This is what it looks like currently
Powerapps.png

Highlighted
ShanP
Level: Powered On

Re: Search Bar Help

You can seperate different functions with semi colon ;

 

Ex.

 

Filter(x,x); Navigate (x,x)

Power Apps Staff CarlosFigueira
Power Apps Staff

Re: Search Bar Help

You can combine the Search and Filter functions - the result of one of them can be passed as the parameter to the other. In your case, this could work:

SearchByColumns(
    Filter(
        Search('Analytical Lab Inventory', SearchTextBox1.Text, "Title"),
        OData__x006e_213 = "1"),
    "Title",
    If(SortDescending1, Ascending, Descending))
bruce
Level: Powered On

Re: Search Bar Help

Unfortunately it doesnt seem to like this either.


Powerapps.png

 

Thanks again though.

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

New Badges

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors
Users online (5,035)