Announcements
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
Hi @Station1901 ,
The easiest way to do this is with the AddColumns function: in the Items property:
AddColumns( SharePointListName, "FullName", $"{'First Name'} {'Last Name'}" )
I've just tried this and it has just listed all of the drivers surnames but not in alphabetical order ?
Did you select the FullName as the displayed value in the dropdown?
I have now !!! This works perfectly - thankyou
Is there a way to sort them in Surname order?
To do that, insert a Sort function in the Items property:
AddColumns( Sort( SharePointListName, 'Last Name' ) "FullName", $"{'First Name'} {'Last Name'}" )
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 345 Super User 2026 Season 2
M Bilal Khan 312
Mohsin Ali 252
