Unanswered

Convert a Dropdown to Combo box control

(0) Share

Report

Posted on by YatinMumbai

123

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@YatinMumbai

Check my post in the Community blog https://powerusers.microsoft.com/t5/PowerApps-Community-Blog/A-quot-Type-Ahead-quot-or-quot-Searching-quot-Dropdown-control/ba-p/248712

Was this reply helpful? Yes No
v-monli-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
YatinMumbai 123 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
DGS 122 on at

Like (0)

Report
Copy link

Link copied!

Link is broken

Was this reply helpful? Yes No