cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
learningflow
Helper II
Helper II

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"?

learningflow
Helper II
Helper II

@timl Thanks a lot, that worked. 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (3,833)