web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / 2 Sharepoint columns i...
Power Apps
Answered

2 Sharepoint columns in one drop down box

(0) ShareShare
ReportReport
Posted on by 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:
I have the same question (0)
  • Verified answer
    BCBuizer Profile Picture
    22,535 Super User 2026 Season 1 on at

    Hi @Station1901 ,

     

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

     

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

     

  • Station1901 Profile Picture
    209 on at

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

  • Verified answer
    BCBuizer Profile Picture
    22,535 Super User 2026 Season 1 on at

    Hi @Station1901 ,

     

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

     

    BCBuizer_0-1689768346870.png

     

  • Station1901 Profile Picture
    209 on at

    I have now !!! This works perfectly - thankyou

  • Station1901 Profile Picture
    209 on at

    Is there a way to sort them in Surname order?

  • Verified answer
    BCBuizer Profile Picture
    22,535 Super User 2026 Season 1 on at

    Hi @Station1901 ,

     

    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.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 101 Most Valuable Professional

#2
Haque Profile Picture

Haque 81

#3
VASANTH KUMAR BALMADI Profile Picture

VASANTH KUMAR BALMADI 70

Last 30 days Overall leaderboard