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 Platform Community / Forums / Power Apps / Can a comboBox that's ...
Power Apps
Unanswered

Can a comboBox that's used for filtering get its data from a field that isn't choices?

(0) ShareShare
ReportReport
Posted on by 302

I have a comboBox that I want to use to filter a gallery. I need it to grab the record number from the gallery table. The number is an autonumber. Can a combo box grab choices that is in an autonumber field? Is there another way to do this with a comboBox? Thanks for any help.

Categories:
  • Rajkumar_M Profile Picture
    3,747 Moderator on at

    Hi @el5 

     

    Yes, a ComboBox in PowerApps can certainly display and select values from an autonumber field. The key is to set the Items property of the ComboBox to the autonumber field from your data source.

     

    For example, if your data source is named YourDataSource and the autonumber field is named AutoNumberField, you would set the Items property of the ComboBox like this:

     

    ComboBox.Items: YourDataSource.AutoNumberField


    This will populate the ComboBox with the values from the AutoNumberField in your data source.

    Then, to filter the gallery based on the selected value in the ComboBox, you would set the Items property of the gallery like this:

     

    Gallery.Items: Filter(YourDataSource, AutoNumberField = ComboBox.Selected.Value)

     

    Thanks!

     

    If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

     

  • el5 Profile Picture
    302 on at

    I'm getting an error:

    Filter(Notifiers, 'Project Number' = 'Payment_Dropdown'.Selected.Value)
    The equal sign says: incompatible comparison and value isn't recognized.
  • Rajkumar_M Profile Picture
    3,747 Moderator on at

    No It's only for your identification.

    You should just put data source and field name only: 

     

    YourDataSource.AutoNumberField

     

  • CU-18081211-6 Profile Picture
    9,272 Moderator on at

    @el5 ,

    Hope that your datasource is Dataverse.

    Just use in combobox items:

    Filter(YourTable,Self.SearchText in AutoNumberColumn)

    and don't forget to allow search on combobox. 

     

     

  • el5 Profile Picture
    302 on at

    yes it's dataverse. the search text is getting a not recognized error

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 409 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 328

#3
WarrenBelz Profile Picture

WarrenBelz 252 Most Valuable Professional

Last 30 days Overall leaderboard