Convert a Dropdown to Combo box control

[YatinMumbai]

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.

[Drrickryp]

@YatinMumbai 

Check my post in the Community blog https://powerusers.microsoft.com/t5/PowerApps-Community-Blog/A-quot-Type-Ahead-quot-or-quot-Searchin...

[v-monli-msft]

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. 

Regards,

Mona

[YatinMumbai]

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.