Add a blank item to a collection that is filtered in an if statement.

(0) Share

Report

Posted on by Stuart74

116

Hello

I know there are normally several ways to tackle a problem, but this one has me mulling over what to do. I am hoping to ask your opinion/help.

I have a screen with two dropdowns. The value of these filter the items on a gallery below them.

The first dropdown defines what the second one shows. I am using a collection(s) to provide the items.

Collections;

ClearCollect(colLocationGroup,{Value:"All Locations"});
Collect(colLocationGroup,Sort(Distinct(Filter('PS - Lookups','Choice Type' = "Location"),'Location Group'),Value,SortOrder.Ascending));
RemoveIf(colLocationGroup,Value = Blank());
 
ClearCollect(colLocations,{Title:"All Locations"});
Collect(colLocations,ShowColumns(Filter('PS - Lookups','Choice Type' = "Location"),'Name (Title)','Location Group'));

First Drop Down Items: (DropDown1)

colLocationGroup

Second Drop Down Items:

If(Dropdown1.Selected.Value = "All Locations",

    colLocations,
    Filter(colLocations,field_2=Dropdown1.Selected.Value)
)
 
I want to add an item "All Locations" to that shown in DropDown2.  The specific part I want to change is Filter(colLocations,field_2=Dropdown1.Selected.Value) - ie the best way to add "All Locations" item.
 
Any Ideas?
 
Thanks
 
Stuart

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

LessCodePaths 100 on at

Like (0)

Report
Hi,

I guess, it should work the way it is.

Maybe you can use:

Filter( colLocations, Or(field_2=Dropdown1.Selected.Value, IsBlank(Dropdown1.Selected.Value)) )

L.

Was this reply helpful? Yes No
Suggested answer

Pstork1 68,707 Most Valuable Professional on at

Like (1)

Report
The easiest way to do this is to use the Table() function in the Items property of the Dropdown. Something like this

Table({Title: "All Locations", <<other fields in collection>>}, colLocations)

Was this reply helpful? Yes No
Stuart74 116 on at

Like (0)

Report

Hello

Apologies, I think I have not been accurate in my ask.

Some data

So if DropDown1 = "US" then the existing code will mean DropDown2 = Atlanta, Cheasapeake.

What I want to do is add an "All Locations" item to Dropdown2 once Dropdown1 is not All Locations.

Was this reply helpful? Yes No
Stuart74 116 on at

Like (0)

Report

Brilliant, thank you. I've not used Table much, so ill explore that more now.

My final code for items on the second drop down.

If(Dropdown1.Selected.Value = "All Locations",

colLocations,

Table({Title: "All Locations"}, Filter(colLocations,field_2=Dropdown1.Selected.Value))

)

Was this reply helpful? Yes No