Search function & gallery display

(1) Share

Report

Posted on by penguinrescuenz

Hello,

I have a gallery that uses a search function and search box to find records in the gallery.

It works perfectly fine in design mode, where all the items in the gallery are viewable before using the search box.

But when viewing as a published app either on the web or on the phone, all items are not displayed in the gallery.

I would like the items to be viewable before using the search box.

Is there something in the coding as below that I need to include so that all items are viewable?

Images are provided as a point of reference.

SortByColumns(Search(Filter('Nests Databases',Filter=Dropdown1.SelectedText.Value),PenguinID_Search.Value,C1ID,C2ID,AFID,AMID,Location_ID),"crf58_seasondate",SortOrder.Descending,"crf58_sequencenumber",SortOrder.Ascending)

Thankyou!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

anandm08 1,936 Super User 2024 Season 2 on at

Like (1)

Report
Copy link

Link copied!
hi @penguinrescuenz ,

Check the Default Values: Ensure the search box (PenguinID_Search) and dropdown (Dropdown1) have default values that won't restrict the gallery items.
Adjust the Formula: Modify your formula to handle cases where the search box is empty or the dropdown has a default value indicating no filter.

SortByColumns( Search( Filter( 'Nests Databases', IsBlank(Dropdown1.SelectedText.Value) || Filter = Dropdown1.SelectedText.Value ), PenguinID_Search.Value, "C1ID", "C2ID", "AFID", "AMID", "Location_ID" ), "crf58_seasondate", SortOrder.Descending, "crf58_sequencenumber", SortOrder.Ascending )

Was this reply helpful? Yes No
BCBuizer 22,654 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @penguinrescuenz ,

In cases where there's a mismatch between the app in Power Apps studio and when playing the app, usually the cause is that the changes you made in Power Apps studio were not published.

Other possible causes may be related to using multiple environments, so if the above doesn't solve your issue, please share if are you using multiple environments.

Was this reply helpful? Yes No
BoboLee 33 on at

Like (1)

Report
Copy link

Link copied!

Have you used the same Share Point connection when playing published app? Open the published app with monitor and check what will happen

Was this reply helpful? Yes No
BCBuizer 22,654 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @penguinrescuenz ,

I also just noticed you are using the DropDown.SelectedText property which has been deprecated. Instead use Selected:

SortByColumns( Search( Filter( 'Nests Databases', IsBlank(Dropdown1.Selected.Value) || Filter = Dropdown1.Selected.Value ), PenguinID_Search.Value, "C1ID", "C2ID", "AFID", "AMID", "Location_ID" ), "crf58_seasondate", SortOrder.Descending, "crf58_sequencenumber", SortOrder.Ascending )

Was this reply helpful? Yes No
penguinrescuenz 17 on at

Like (1)

Report
Copy link

Link copied!

Awesome. Thanks @BCBuizer .
I will try this out and see how I get on.
Thanks for your help and helping penguins!

Was this reply helpful? Yes No
penguinrescuenz 17 on at

Like (1)

Report
Copy link

Link copied!

Awesome. Thanks @anandm08
I'll try this and see how I get on.
Thanks for helping out and helping penguins!

Was this reply helpful? Yes No