Answered

The commands for the search bar

(0) Share

Report

Posted on by WatermelonCat

I connected my excel to a list screen. Is there a function for the search icon or search bar that will allow the user to search through the list?

Screen Shot 2019-11-10 at 9.12.06 PM.png

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

PowerAddict 7,316 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Click or select your gallery and you should see a search function in the Items property of the gallery. It will.be something like this:

Search(List, TextSearchBox1.Text, "Column" )

List will be your datasource/excel name
Replace Column with the column name against which you want your users to be able to search.

---
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
WatermelonCat 39 on at

Like (0)

Report
Copy link

Link copied!

Do I put it under the OnSelect function of the icon?

Was this reply helpful? Yes No
Verified answer

PowerAddict 7,316 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

No, the search icon is just for visual purposes to tell a user to a enter their search criteria next to the icon in the search bar.

This formula will be your gallery's item property. Click on the gallery and it should default to showing the Items property of the gallery. It might be something like
ExcelFileName

Change it to what I shared in my previous reply. Let me know if that doesn't work. If you are unsure, send me a screenshot of the Items property of the Gallery and I will write down the formula for you.

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