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

Community site session details

Session Id :
Power Apps - Building 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,492 Super User 2025 Season 2 on at
    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'}"
    )

     

  • Station1901 Profile Picture
    209 on at
    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 ?

  • Verified answer
    BCBuizer Profile Picture
    22,492 Super User 2025 Season 2 on at
    Re: 2 Sharepoint columns in one drop down box

    Hi @Station1901 ,

     

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

     

    BCBuizer_0-1689768346870.png

     

  • Station1901 Profile Picture
    209 on at
    Re: 2 Sharepoint columns in one drop down box

    I have now !!! This works perfectly - thankyou

  • Station1901 Profile Picture
    209 on at
    Re: 2 Sharepoint columns in one drop down box

    Is there a way to sort them in Surname order?

  • Verified answer
    BCBuizer Profile Picture
    22,492 Super User 2025 Season 2 on at
    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'}"
    )

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

Coming soon: forum hierarchy changes

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 803 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 314 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 253 Super User 2025 Season 2

Last 30 days Overall leaderboard