Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

Convert a Dropdown to Combo box control

I have a text column called Project in a SharePoint custom which should get a value from Project Master list. I  have a customized form in Power Apps where the Items property is set to Sort(Distinct('Project Master',Title),Result) IIn the Form Properties -> Edit Fields -> I set the field control property to dropdown. I could not find Combo Box option. This is working.


The problem is that when projects increase in numbers, dorpdown will be difficult to use. I need a searchable Combo Box control.


The reason I am not using SharePoint standard lookup column is because I have next drop down which has a cascading value filter based on the above field. Location based on project selected.


Thanks in advance for any help.


Super User
Super User

Re: Convert a Dropdown to Combo box control

Community Support Team
Community Support Team

Re: Convert a Dropdown to Combo box control

Hi @YatinMumbai ,


You can use a combo box to replace the default text control to update this text column. Just unlock the data card, delete the old text control and insert a combo box. Use the same formula in the Items property for the combo box. Then you could to convert combo box selected items into a string in the Update property of this data card. Use below formula to achieve this:

Concat(RptGrpDropDown.SelectedItems, ColumnName & "; ")

Note: The ColumnName represents the column you used as a display value within your Combo Box control. 




Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Level: Powered On

Re: Convert a Dropdown to Combo box control

Thanks for your response.

The Combo Box is working as desired. However, I am getting error in the Update property of the data card. I have used the formlua you have suggested and replaced controls to those in my project.

Helpful resources


Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,071)