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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / How to get two columns...
Power Apps
Unanswered

How to get two columns values in a combo box

(0) ShareShare
ReportReport
Posted on by 4

I have two columns of interest on my SharePoint list: ID and Name. I want to show the combined value of these two columns in the items of my combobox. I am using a combobox just like a drop-down (Single Select), but I am using this in order to have the ability to search through the item options.

 

What I really want is to show items in my combobox as concatenated values from those two columns separated by a dash (-).

 

So, if the records in the datasource for these two columns are like: ID: {100, 101, 102}, Name: {Joe, Doe, John}, then the resultant items in the combobox should be like items: {100 - Joe, 101 - Doe, 102 - John}

Categories:
I have the same question (0)
  • Rajkumar_M Profile Picture
    3,741 Super User 2025 Season 2 on at

    Hi @uncharted_9 

    Plz try this function formula in Combo Box item Property, 

     

    ForAll('YourDataSource', Concatenate(ID, " - ", Name))

     

    Thanks! 

    ---------------------------------------------------------------------------------------------------------------

    If I have answered your question, please mark your post as Solved & give Thumps Up to my solution.

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

Forum hierarchy changes are complete!

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 740 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 342 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard