drop down list - need to display all

[Quilley]

Hi,

Can anyone help me out with a drop down issue? I've manually added the drop down items in a list as the choices/distinct function wouldn't work or would show lots of duplicates. The way I have it works well but just wondering if there is a way to also show all items by default instead of the one that is displayed?

Current formula:

["Africa","Asia Pacific", "Europe","Global","Middle East","North America","South America"]

[BCBuizer]

Hi @Quilley ,

Not sure if you mean to show or select all items by default. If it is really to show, perhaps you need to use a different control. Depending on whether this is a single or multi select column, you can go either for a Radio control or a gallery with a CheckBox control:

[Quilley]

@BCBuizer  Thanks for getting back to me. I can see how this would work but was hoping to use a drop down to maximise space and make it look clean!

[BCBuizer]

Hi @Quilley ,

So you want the dropdown to be expanded by default, looking like below?

[Quilley]

@BCBuizer Sorry, i've not explained myself very well! At the moment when it loads the gallery view it loads what every is selected as the initial load I want it to load all items in the list until the user selects otherwise. For example if they search in another search box I still want to display all regions until the select Europe as an example.

Is that possible?

[BCBuizer]

@Quilley ,

In that case I would use a combobox since that gives the option to not select an item. I have a similar setup working that allow multiple choices with the below settings:

DefaultSelectedItems = 
NoSelectionText = "All"
SelectMultiple = true

The only thing left is to amend the filter to include the option of having nothing selected:

If(IsBlank(ComboBox1.Selected),true, Area.Value in ComboBox1.SelectedItems.Value)

[Quilley]

Thanks - sounds like this is what I need but can't get it working - sorry I have very limited knowledge of Power apps!

I have added a combo box then added the settings you suggested - is this correct? I get an error, please see below:

I'm also not sure where to apply the IF statement, would this be in the gallery function under items? This is my current function statement, I've tried adding it to this but can't get it working without getting errors:

Filter(colTest,('VRI Region' = DropDown_region.Selected.Value) && (StartsWith(Ownership,StoreOwnership.Text)) && (StartsWith(Location,StoreSearch_location.Text)) && (StartsWith(Retailer,StoreSearch_retailer.Text)))

[BCBuizer]

Hi @Quilley ,

Those are three different properties. So DefaultSelectedItems should be left blank, the NoSelectionText should be set for "All", etc.

An easy way to set multiple properties is by going to the Advance tab on the right side of the screen:

[Quilley]

Thanks looks like its working and showing no errors but the data isn't loading until I select an item. I haven't added this statement anywhere, I've tried adding it to the item in the Gallery view but I just get errors. Sorry to keep bugging you but any idea where I'm going wrong?

If(IsBlank(ComboBox1.Selected),true, Area.Value in ComboBox1.SelectedItems.Value)

[BCBuizer]

Hi Quiley,

Can you please share what you currently have as the Items property of your gallery? The statement should be added in there.