Answered

How to set gallery to display all items by default

(1) Share

Report

Posted on by Vanilla

Hi all,

I want a gallery to display all of the items in the data source when the gallery launches. Right now nothing displays by default, which is not what I want. When I type characters into the textbox matching items in the gallery display. When I select an item from Gallery1, items in the table that have a matching location display correctly on Gallery2. Gallery1 is just a gallery that displays a list of locations.

Gallery1- Items:

Distinct(SortByColumns(Testing_Database,"Location"), Location)

Gallery2- Items:

Filter(Search(Testing_Database,'Textbox Search'.Text, "Artist","Title","Location","Medium","Nationality"), Location = Gallery1.Selected.Result)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Jeff_Thorpe 6,085 Super User 2024 Season 1 on at

Like (0)

Report
You can do this as long as Gallery1 doesn't have anything selected. What you can do is use an "If" statement and it would look something like this:

If(IsBlank(Gallery1.Selected), DataSource, Filter(DataSource, Gallery1.Selected.Results = Location))

If it still looks like it is being filtered then there is a good chance that something is selected in Gallery1. To test that out you would need to add a label to the screen and give the text property the formula of "Gallery1.Selected.Results" and see if it has a value.

Was this reply helpful? Yes No
Vanilla on at

Like (0)

Report

I've set the items property of gallery2 to
If(IsBlank(Gallery1.Selected),Testing_Database, Filter(Search(Testing_Database,'Textbox Search'.Text, "Artist","Title","Location","Medium","Nationality"), Gallery1.Selected.Result = Location))

The formula isn't giving any errors and I think it should work but it still isn't displaying any records unless I search for something or use gallery1 to select a location to filter by. I used a label to make sure nothing was being selected in gallery1 and if something was selected it displayed the text of the location as expected.

Was this reply helpful? Yes No
Verified answer

Vanilla on at

Like (0)

Report

What I ended up doing was duplicating the gallery and searchbar and setting the items of the duplicated gallery to:
Search(Testing_Database,'Textbox Search_1'.Text, "Artist","Title","Location","Medium","Nationality")

and the visible property to: If(IsBlank(Gallery1.Selected.Result), true, false)

So the screen always displays gallery2 and the duplicate gallery at the initial load of the screen, but only displays gallery2 if the user users gallery1 to filter by location.

Was this reply helpful? Yes No