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

(0) Share

Report

Posted on by Stuart74

112

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:

General Questions

All responses (4)

Answers (0)

Stuart74 112 on at

Like (0)

Report

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

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))

)
Stuart74 112 on at

Like (0)

Report

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

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.
Suggested answer

Pstork1 67,060 Most Valuable Professional on at

Like (1)

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

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)
Suggested answer

LessCodePaths 100 on at

Like (0)

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

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.