Combo Box to display values from a SQL on prem table

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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.

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

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

timl 37,287 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous

In the properties of your combobox, have you clicked the Fields > Edit link and selected "Fullname"?
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@timl Thanks a lot, that worked.