Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Convert a Dropdown to Combo box control

(0) ShareShare
ReportReport
Posted on by 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.

 

  • DGS Profile Picture
    DGS 114 on at
    Re: Convert a Dropdown to Combo box control

    Link is broken

  • YatinMumbai Profile Picture
    YatinMumbai 123 on at
    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.

  • v-monli-msft Profile Picture
    v-monli-msft on at
    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

  • Drrickryp Profile Picture
    Drrickryp on at

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,475

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,767

Leaderboard