Unanswered

How to load SQL table field values into a Drop down control

(0) Share

Report

Posted on by Community Power Pla...

Hi,

I am working on developing a mobile app containing about 4 fields. The data source is sql table (on prem), connected with gateway connection and added as data source in my app. See screenshot below for the dd control properties.

With this config, it loads all values from field 'personnelfirstname' into the dd. However, I would like to load 'PersonnelFirstName PersonnelLastName' into the dd as concatenated value with space. Can someone help me with the expression to set for items property, this should be simple enough but I am unable to figure it out. Also, once this is configured, I would like to display 'PersonnelID' in a label based on the selection in dd, any help on this would be greatly appreciated, thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (0)

Report

Hello @Anonymous,

You can try using

Choices(SqlTableName.FieldName) in the items of DD

Please mark as Answer if it is helpful and provide Kudos
Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thanks @rampprakash , however it does not work.

Was this reply helpful? Yes No
Verified answer

timl 36,383 Super User 2025 Season 2 on at

Like (1)

Report
@Anonymous

You can do this by setting the Items property of your dropdown to the following:

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

To show the PersonnelID in a label, you would set the Text property to the following:

Dropdown1.Selected.PersonnelID

Note that if the label shows up blank, you may need to explicitly specify the column names by amending the Items property of your dropdown like so:

ShowColumns(AddColumns(tblPersonnel, "Fullname", PersonnelFirstName & " " & PersonnelLastName ), "Fullname", "PersonnelID" )

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

thanks @timl , I tried your approach for the items property of dd. However its not loading full name. Please see below. Also, what is 'Fullname' represent here?

Was this reply helpful? Yes No
timl 36,383 Super User 2025 Season 2 on at

Like (1)

Report

Hi @Anonymous

Fullname is the field that would return the concatinated value of PersonnelFirstname and PersonnelLastName.

Could you confirm that you've set the Value property of the dropdown control to Fullname?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

Excellent @timl , thanks so much for your help, it worked.

Was this reply helpful? Yes No