web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / drop down list - need ...
Power Apps
Answered

drop down list - need to display all

(0) ShareShare
ReportReport
Posted on by Quilley 38

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"]

Categories:
Building Power Apps
I have the same question (0)
  • BCBuizer Profile Picture
    BCBuizer 22,563 Super User 2026 Season 1 on at

    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:

     

    BCBuizer_0-1656060795782.png

     

  • Quilley Profile Picture
    Quilley 38 on at

    @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 Profile Picture
    BCBuizer 22,563 Super User 2026 Season 1 on at

    Hi @Quilley ,

     

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

    BCBuizer_0-1656061790104.png

     

  • Quilley Profile Picture
    Quilley 38 on at

    @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 Profile Picture
    BCBuizer 22,563 Super User 2026 Season 1 on at

    @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 Profile Picture
    Quilley 38 on at

    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:

    Quilley_0-1656067137601.png

    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 Profile Picture
    BCBuizer 22,563 Super User 2026 Season 1 on at

    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:

     

    BCBuizer_0-1656075131037.png

     

  • Quilley Profile Picture
    Quilley 38 on at

    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 Profile Picture
    BCBuizer 22,563 Super User 2026 Season 1 on at

    Hi Quiley,

     

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

  • Quilley Profile Picture
    Quilley 38 on at

    Thanks so much. Its:

     

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the February Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 85

#2
WarrenBelz Profile Picture

WarrenBelz 76 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 38 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans