2 Sharepoint columns in one drop down box

(0) Share

Report

Posted on by Station1901

209

Hello,

Is there a way to combine 2 Sharepoint columns into 1 dropdown box?. I have a sharepoint list which has 1 column for Forenames and 1 column for Surnames though i'd like to have a dropdown list in my powerapp that combines these as some of our staff have the same surnames

Thanks,
mick

Categories:

General Questions

I have the same question (0)

All responses (6)

Answers (3)

Verified answer

BCBuizer 22,492 Super User 2025 Season 2 on at

Like (1)

Report
Re: 2 Sharepoint columns in one drop down box

Hi @Station1901 ,

The easiest way to do this is with the AddColumns function: in the Items property:

AddColumns( SharePointListName, "FullName", $"{'First Name'} {'Last Name'}" )

Was this reply helpful? Yes No
Station1901 209 on at

Like (0)

Report

Re: 2 Sharepoint columns in one drop down box

I've just tried this and it has just listed all of the drivers surnames but not in alphabetical order ?

Was this reply helpful? Yes No
Verified answer

BCBuizer 22,492 Super User 2025 Season 2 on at

Like (1)

Report

Re: 2 Sharepoint columns in one drop down box

Hi @Station1901 ,

Did you select the FullName as the displayed value in the dropdown?

Was this reply helpful? Yes No
Station1901 209 on at

Like (0)

Report

Re: 2 Sharepoint columns in one drop down box

I have now !!! This works perfectly - thankyou

Was this reply helpful? Yes No
Station1901 209 on at

Like (0)

Report

Re: 2 Sharepoint columns in one drop down box

Is there a way to sort them in Surname order?

Was this reply helpful? Yes No
Verified answer

BCBuizer 22,492 Super User 2025 Season 2 on at

Like (0)

Report
Re: 2 Sharepoint columns in one drop down box

Hi @Station1901 ,

To do that, insert a Sort function in the Items property:

AddColumns( Sort( SharePointListName, 'Last Name' ) "FullName", $"{'First Name'} {'Last Name'}" )

Was this reply helpful? Yes No