Display Items in Gallery

(0) Share

Report

Posted on by 3cdoug

153

Filter('Example List Name',StartsWith(Title,SearchInput1.Text))

This is the expression that I am using to sort through my sharepoint list. I am using this expression as the data that I will have is larger than 500 entries. The problem that I am running into is it displays all of the items but then filter after I search by my title function. Is there anyway to hide the gallery display until I enter the data in which I want to filter by?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

BCBuizer 22,654 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @3cdoug ,

Adding an extra condition where SearhcInput1.Text can't be blank should do the trick:

Filter('Example List Name',StartsWith(Title,SearchInput1.Text) && !IsBlank(SearchInput1.Text))

Was this reply helpful? Yes No
Ash13 576 on at

Like (1)

Report
Copy link

Link copied!

You could add a condition to the items of the gallery so there are no items when the text field is blank

If(!IsBlank(SearchInput1.Text),Filter('Example List Name',StartsWith(Title,SearchInput1.Text)))

You can also set the DelayOutput property of the text input which will generally delay the filtering until after you finish typing, rather than immediately filtering the gallery after the first keystroke.

Was this reply helpful? Yes No
WarrenBelz 154,930 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @3cdoug ,

Adding to the ideas here - the simplest way when using StartsWith is to set the Default of SearchInput1 to "" (empty string) and it will display all items until you enter a value.

Was this reply helpful? Yes No
3cdoug 153 on at

Like (1)

Report
Copy link

Link copied!

You Sir are an angel sent from above 😎

Was this reply helpful? Yes No
3cdoug 153 on at

Like (0)

Report
Copy link

Link copied!

Thank you as well

Was this reply helpful? Yes No