Unanswered

Gallery Items do not show up until something is typed in text search box

(0) Share

Report

Posted on by Community Power Pla...

When I log into my app, the gallery is blank. After typing something in the search box, the items appear and will stay visible even if I delete the text from the search box. In the 'Items' section of my gallery, I have: Search(SortByColumns(Entity, "Username", If(SortDescending1, Descending, Ascending)),TextSearchBox1.Text, "Username")

The gallery will display correctly if I only put 'Entity' in the Items section, but then the search box would have no functionality. How do I make the gallery display automatically when I log into the app while still keeping functionality for my search box?

Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

nickduxfield 497 on at

Like (0)

Report
You could possible use an If statement to get you going, then you can use other more complex methods later.
Think of your default filter for the gallery without the textinput, then setup an if IsBlank.
If(IsBlank(TextInput.Text),SortByColumns(Search(Entity, TextSearchBox1.Text, "Username"),"Column", If(SortDescending1, Descending, Ascending)),SortByColumns(Search(Entity, TextSearchBox1.Text, "Username"),"Column", If(SortDescending1, Descending, Ascending)))

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @nickduxfield,

I tried out your suggestion but am still having the same issue of not being able to see gallery items until after I type something into the search box.

Was this reply helpful? Yes No
Verified answer

nickduxfield 497 on at

Like (2)

Report
Thanks,
Reference:https://powerapps.microsoft.com/en-us/tutorials/function-filter-lookup/
Hey please keep in mind the concept is the IF statement, we still need to get the details right for everything else.
Also, we can try different syntax found in the above.

Some observations from the code below:
You can't include the searchinput.text on the first if statemement because we want this to be the default criteria if the textinput is empty. To give this a proper default filter withou input from the TextInput control you may need to change the Search() function to possibly a Filter() function and settle on what a default filter looks llike. Example below.
If(IsBlank(TextInput.Text),SortByColumns(Filter(Entity, Column=true,Column=false),"Column", If(SortDescending1, Descending, Ascending)),SortByColumns(Search(Entity, TextSearchBox1.Text, "Username"),"Column", If(SortDescending1, Descending, Ascending)))
I trust you understand the concept,
If textinput is empty, ignore textinput and Fliter like this. If it is populated, Search using the textinput like this.

Was this reply helpful? Yes No