cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
learningflow
Frequent Visitor

Combo Box to display values from a SQL on prem table

Hi,

 

I am replacing my drop down control with a combo box to achieve the searching capability. I have below expression for items property on drop down control which works great and loads the values into a drop down control. 

Sort(AddColumns(tblPersonnel,  
           "Fullname",
           PersonnelFirstName & " " & PersonnelLastName 
),Fullname,Ascending)

When I use the same formula mentioned above for items property of a combobox, I get to see below. 

learningflow_0-1632756658322.png

Can someone please help me modify the formula, thanks in advance. 

1 ACCEPTED SOLUTION

Accepted Solutions
timl
Super User
Super User

Hi @learningflow 

In the properties of your combobox, have you clicked the Fields > Edit link and selected "Fullname"?

View solution in original post

2 REPLIES 2
timl
Super User
Super User

Hi @learningflow 

In the properties of your combobox, have you clicked the Fields > Edit link and selected "Fullname"?

View solution in original post

learningflow
Frequent Visitor

@timl Thanks a lot, that worked. 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,379)