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 / Search Functionality o...
Power Apps
Unanswered

Search Functionality on Form Field w/ Allowed Values Dropdown

(0) ShareShare
ReportReport
Posted on by 163

I have a form that is connected to a SQL dB table. I have several of the fields in the the form set to an Allowed Values dropdown.

 

Using one of the fields as an example-- Job Title

 

The Job Title card's allowed values are set to: DataSourceInfo([@'[Employee].[Employee]'], DataSourceInfo.AllowedValues, "JobId")

 

The Job Title card's items are set to a related table with the following formula: Sort('[Employee].[JobTitle]',JobTitle,Ascending)

Anyway, the field works fine, but there are a hundred or so values in the drop down list. Is there a way to add a search functionality so the user can type in the drop down and filter the list?

 

I've seen some other posts saying that the combo box has this functionality, but in my case I'm using a form with allowed values drop downs and I haven't found a way to do this.

 

 

 

 

 

 

Categories:
I have the same question (0)
  • eka24 Profile Picture
    20,925 on at

    As you cannot search  woin Onea dropdown , the workaround us to insert a Combobox on your screen and set it Items same as the dropdown 

    Sort('[Employee].[JobTitle]',JobTitle,Ascending)

     

    So users will search in the Combobox.

     

    Then set the Default of the dropdown to:

    ComboboxName.Selected

     

    Or replace the dropdown with a Textbox and set it Default to;

    ComboboxName.Selected.Value

    ------------

    If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

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
WarrenBelz Profile Picture

WarrenBelz 358 Most Valuable Professional

#2
11manish Profile Picture

11manish 214 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 185

Last 30 days Overall leaderboard