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 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 101 Most Valuable Professional
Haque 81
VASANTH KUMAR BALMADI 70
