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.
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.
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.
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
Learn how to build the business apps that you need.