cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
YatinMumbai
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.

 

3 REPLIES 3
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. 

 

Regards,

Mona

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.
YatinMumbai
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

Announcements
thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

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