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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Apps
Unanswered

Combobox items

(0) ShareShare
ReportReport
Posted on by 159

Hi Team.

 

I have a Combobox in power apps, and I have information loaded in SP list and in one of the columns I have empty information, I do not want that data to be shown in the items of the Combobox drop-down list

jaimeMtz07_0-1637169769012.png

 

Categories:
I have the same question (0)
  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @jaimeMtz07 

    This would be done in the Items property of your Combobox.

    Without knowing your fields and data for the Items, it would be something such as this:

    Filter(yourData, !IsBlank(visibleColumnName))

     

    I hope this is helpful for you.

  • jaimeMtz07 Profile Picture
    159 on at

    Great, now I need solve the delegation warning 😛

  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @jaimeMtz07 

    Well, it's just a warning - not an error.

    So the question is, is your data now or going to be more than the record limit you have set in the app?

  • jaimeMtz07 Profile Picture
    159 on at

    Maybe in the future (near time) currently I have 850 items...

  • RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @jaimeMtz07 

    So the maximum record limit in the app can be set to up to 2000.  If there is more than that, then you'll really be dealing with this in a different way as I am assuming you only have a small amount of records with that column being blank.  In which case you will be more restrained by the record limit in general.

    For example, if you have 2010 records in your datasource and 5 of them are blank, you still would not get 2005 back, you'd only get 2000.  So, in summary, you'd really need to evaluate the future of the data and how you will deal with the real delegation issue when/if that time comes.

     

    If the warning message is annoying, then you can alter the formula to:

    With({_items: yourData},
     Filter(_items, !IsBlank(visibleColumnName))
    )

    That will get rid of the warning, but not resolve any delegation in such a time as you actually have more than the record limit.

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

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 April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 742

#2
Valantis Profile Picture

Valantis 474

#3
Haque Profile Picture

Haque 358

Last 30 days Overall leaderboard