Power Platform Community Forum Thread Details

I have the following for the 'Items' properties of a gallery. When the app is originally opened no records are displayed. If one of the sort options is selected, then records appear. How do I default to all records when the App opens?

Switch(varSortColumn,"BldgAptRm",SortByColumns(Filter([@RZMaintInspection],StartsWith(AptNo,TextSearchBox1.Text) && (CreatedbyDN = Dropdown3_1.Selected.Value || Dropdown3_1.Selected.Value = Blank()) && (ZoneLU = Radio2.Selected.Value || Radio2.Selected.Value = Blank()) && (Building = Dropdown3.Selected.Bldg || Dropdown3.Selected.Bldg = Blank())),
"BldgAptRm",If(varSortColumn = SortOrder.Ascending,SortOrder.Ascending,SortOrder.Descending)),
"Created",SortByColumns(Filter([@RZMaintInspection],StartsWith(AptNo,TextSearchBox1.Text) && (CreatedbyDN = Dropdown3_1.Selected.Value || Dropdown3_1.Selected.Value = Blank()) && (ZoneLU = Radio2.Selected.Value || Radio2.Selected.Value = Blank()) && (Building = Dropdown3.Selected.Bldg || Dropdown3.Selected.Bldg = Blank())),"Created",If(varSortColumn = SortOrder.Ascending,SortOrder.Ascending,SortOrder.Descending)),
"Points",SortByColumns(Filter([@RZMaintInspection],StartsWith(AptNo,TextSearchBox1.Text) && (CreatedbyDN = Dropdown3_1.Selected.Value || Dropdown3_1.Selected.Value = Blank()) && (ZoneLU = Radio2.Selected.Value || Radio2.Selected.Value = Blank()) && (Building = Dropdown3.Selected.Bldg || Dropdown3.Selected.Bldg = Blank())),"Points",If(varSortColumn = SortOrder.Ascending,SortOrder.Ascending,SortOrder.Descending))

Categories:

Building Power Apps

Hi @RJF61,

You currently do not have a Default case within the switch, only ones for bldgAptRm, Created & Points. When opening the app, varSortColumn will most likely not have a value - meaning the Switch returns nothing because it does not have a case value that matches.

I am a bit confused about the use of varSortColumn both for a text value (see first Switch parameter) and as a SortOrder value. Could it be that these should refer to 2 different variables?

We could rewrite the code slightly to avoid some code duplication and increase readability. For the example below I used varSortColumn for both cases as well and the default switch will sort via the ID:

SortByColumns(
 Filter(
 [@RZMaintInspection],
 StartsWith(AptNo,TextSearchBox1.Text), 
 (CreatedbyDN = Dropdown3_1.Selected.Value || Dropdown3_1.Selected.Value = Blank()), 
 (ZoneLU = Radio2.Selected.Value || Radio2.Selected.Value = Blank()), 
 (Building = Dropdown3.Selected.Bldg || Dropdown3.Selected.Bldg = Blank())
 ),
 Switch(
 varSortColumn, 
 "BldgAptRm",
 "BldgAptRm",
 "Created",
 "Created",
 "Points",
 "Points",
 //By default use Id (you might have to rewrite "Id" to the exact, correct column name
 "Id"
 ),
 //Make sure the variable below is filled during the OnStart with e.g. SortOrder.Ascending otherwise this will throw an error
 If(varSortColumn = SortOrder.Ascending,SortOrder.Ascending,SortOrder.Descending)
)

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!