How to Concatenate Columns in Power Apps Combo Box?

A few weeks ago, I created a Power Apps form for event registrations that allows users to register for available events. I was required to concatenate the event title and date in a Power Apps combo box to select events in the form.

This lets users see two field details quickly within this single combo box control.

In this article, I will explain how to concatenate columns in Power Apps combo box using a collection and a SharePoint list.

Concatenate Columns in Power Apps Combo Box

I will explain how to concatenate SharePoint list columns into Power Apps combo box control here.

I have a SharePoint list named Events Complete Details. Now, we will concatenate the Title and Event Date columns into the Power Apps combo box control.

Look at the example below: the Power Apps combo box contains the combination of Title and Event Date columns.

To achieve this, follow the steps below!

1. Connect the SharePoint list with Power Apps from the Data section. Then, add a combo box control from the +Insert tab.

2. To concatenate the SharePoint list columns, provide the formula below in the Items property of the Power Apps combo box control.

SortByColumns(AddColumns('Events Complete Details' ,EventDetails ,Concatenate (Title,"-",'Event Date')),"EventDetails",SortOrder.Ascending)

Here, EventDetails stores the Title and Event Date column values in the Power Apps combo box control.

3. To insert the concatenated column values into the Power Apps combo box control. Open the combo box’s Properties->Click Fields-> select Layout, and Select EventDetails for the Primary text.

Now, save the changes and preview the app once. The title and event date values are combined in the Power Apps combo box control.

Concatenate Collection Columns into Power Apps Combo Box

Let’s see how to concatenate Power Apps collection columns into combo box control. Refer to the example below; the combo box contains the combination of three columns.

Look at the Power Apps collection with the columns once.

Follow the steps below to concatenate collection columns into the Power Apps combo box.

1. To create a Power Apps collection, provide the below formula in the OnStart property of the App object.

ClearCollect(
    colEmployeeDetails,
    {
        FirstName: "Patti",
        LastName: "Fernanz",
        Department: "Information Technology"
    },
    {
        FirstName: "Lidia",
        LastName: "Holloway",
        Department: "Human Resource"
    },
    {
        FirstName: "Johana",
        LastName: "Lorenz",
        Department: "Marketing"
    },
    {
        FirstName: "John",
        LastName: "Fernanz",
        Department: "Information Technology"
    },
    {
        FirstName: "Grady",
        LastName: "Archey",
        Department: "Sales"
    },
    {
        FirstName: "Henrita",
        LastName: "Mrunal",
        Department: "Human Resources"
    },
    {
        FirstName: "Micheal",
        LastName: "lorenz",
        Department: "Marketing"
    },
    {
        FirstName: "John",
        LastName: "Lorem",
        Department: "Research"
    }
)

2. Add a combo box control and provide the below formula in its Items property.

Sort(AddColumns(colEmployeeDetails,EmpDetails,Concatenate(FirstName," ",LastName ,"-",Department)),EmpDetails)

EmpDetails will store the combination of first and last names and department details.

This formula will combine the Power Apps collection columns into a combo box control.

3. To fetch the values, open the combo box Properties -> Click Fields -> Select Layout -> Single -> Select EmpDetails for Primary text.

Now, save the changes and preview the app once. The combination of collection column values will appear in the Power Apps combo box control.

Concatenate Combo Box Selected Items in Power Apps

We have seen columns concatenated into the Power Apps combo box control. Let’s see how to concatenate the selected items in the combo box.

The example below shows that the selected combo box items are concatenated.

I have a SharePoint list named Expense Reports Form for the above Power Apps form. This list includes the following fields.

1. In Power Apps, add Edit Form control. Then, connect with the SharePoint list.

Note: Allow multiple selection for combo box control [Expense category] in the Power Apps form.

2. Add a Text label control from the +Insert tab. Provide the formula below for the Text property of the text label.

Concat(DataCardValue4.SelectedItems,Value,",")

The Concat() function will concatenate the selected items in the combo box with a comma separator.

3. Save the changes and preview the app once. The selected items are concatenated and displayed on the text label.

This way, we can concatenate the SharePoint list and collection columns into the Power Apps combo box control.

I hope you understand how to concatenate SharePoint list and collection columns into Power Apps combo box control. You can follow this article while trying to concatenate columns into the Power Apps combo box control.

Also, you may like:

• Power Apps Combo Box Search Office365Users
• Populate Distinct Values in Power Apps Combo Box
• Power Apps combo box default value
• Power Apps combo box filter

Preeti Sahu

Preeti Sahu is an expert in Power Apps and has over six years of experience working with SharePoint Online and the Power Platform. She is the co-author of Microsoft Power Platform: A Deep Dive book. As a Power Platform developer, she has worked on developing various tools using Power Apps and Power Automate. She also makes Microsoft 365 videos and shares them on YouTube.