Power Apps Combo Box Concatenate Display Fields

Do you want to concatenate SharePoint list fields in Power Apps combobox control? In this Power Apps tutorial, I will explain how to concatenate display fields in a Power Apps combo box.

Moreover, I will show you how to concatenate the Power Apps Combo box selected value with a text input value to a SharePoint list choice field.

Power Apps Concatenate Columns in Combo Box

In this section, I will show you how to concatenate the SharePoint list columns (2 columns) in a Power Apps combo box control.

For example, I have a SharePoint Online list [Employee Details] that has various columns like:

Column NameData Type
Employee IDTitle
Employee First NameSingle line of text
Employee Last NameSingle line of text
powerapps combobox concatenate display fields

I created a Power Apps Canvas app and added a Combo box control. The combo box control should concatenate the SharePoint list columns of:

  • Employee First Name
  • Employee Last Name
Power Apps Combo box concatenate display fields

Let me show you how to achieve this:

powerapps combobox display multiple fields
  • On the Power Apps screen, insert a Combo box control -> Set its Items property to:
SortByColumns(
    AddColumns(
        'Employee Details',
        "BOTHNAMES",
        Concatenate(
            EmployeeFirstName,
            " ",
            EmployeeLastName
        )
    ),
    "BOTHNAMES",
    SortOrder.Descending
)

Where,

  1. Employee Details = SharePoint list name
  2. EmployeeFirstName = SharePoint list column name
  3. EmployeeLastName = SharePoint list column name
Power Apps Combo box concatenate two fields
  • Once your app is ready, SavePublish, and Preview the app. When the user expands the Combo box control, it displays the values that concatenate the employee’s first and last names.
power apps combobox display multiple fields

I concatenated the columns to the Power Apps combo box control.

Power Apps Concatenate Combo box selected value with text input to a SharePoint list choice field

Here is another interesting example of how to display multiple fields in a Power Apps combo box.

Here, I will explain how to concatenate a Power Apps combobox selected value with a text input value and update it to a SharePoint list.

For Example, I have a SharePoint Online list [IT Service Request] that has various columns like:

Column NameData Type
Employee IDTitle
Employee NameSingle line of text
IssueChoice [“Laptop,” “Network,” “Outlook”, “Other”]
Power Apps Combo box concatenate

I created a Power Apps Canvas app and added an Edit form. In the form, a combo box control is connected to the above SharePoint list choice column.

Whenever the user selects an “Other” option from the combo box value, the Text-input control will be visible.

powerapps combobox concatenate two fields

Later, when the user provides the text-input value and clicks on a button control. The combo box selected value with text input value will be saved in the SharePoint list choice column.

Concatenate column in Power Apps combo box

You must first enable the “Can add values manually” option for the SharePoint list choice column.

To do this, open the SharePoint list, select the choice column > Column Settings > Edit > Check “On” the Can add values manually > Save like the screenshot below.

powerapps combobox concatenate two values

Now, create a blank canvas app by using the SharePoint list and follow the below steps:

  • On the Power Apps screen, insert an Edit form. Then, add a new data source for the above SharePoint list and set the Edit form’s Data source property.

Where,

  • IT Service Request = Datasource name
Power Apps concat combobox selecteditems
  • Select the Issue DataCard1 ->Insert the Text-input control -> Set its Visible property to:
If(
    DataCardValue6.Selected.Value = "Other",
    true,
    false
)

Where,

  • DataCardValue6 = Combo box control name
Concatenating Selected Items from a Power Apps ComboBox
  • Create a Power Apps Collection on the App’s OnStart property:
ClearCollect(
    colConcatenate,
    If(
        DataCardValue6.Selected.Value = "Other",
        txt_OtherConcatenate.Text,
        ""
    )
);

Where,

  1. colConcatenate = Provide the collection name
  2. DataCardValue6 = Combo box control name
  3. txt_OtherConcatenate = Text-input control name
Power Apps Combo box concatenate columns
  • Now select the Issue DataCard1 -> Set its Update property to:
Concatenate(
    DataCardValue6.Selected.Value,
    ":",
    colConcatenate
)

Where,

  1. DataCardValue6 = Combo box control name
  2. colConcatenate = Collection name
Power Apps Concatenate combo box selected items with textinput value
  • On the Power Apps form, insert a Button control -> Set its OnSelect property to:
SubmitForm(Form2);NewForm(Form2);
How to concatenate Power Apps combo box control
  • Once your app is ready, Save, Publish, and Preview the app when the user selects an “Other” option from the combo box control and provides the text in the text input control.
Power Apps concat combobox selecteditems with text-input value
  • Once the user clicks on the submit button. The combo box selected value with the text-input value will be saved to the SharePoint list choice column.
Concat combo box Selected Items with the text input

This is how to concatenate the Power Apps Combo box selected value with text input to the SharePoint list choice field.

Conclusion

I hope this Power Apps tutorial helped you to implement the “Power Apps Combo box concatenate display fields” with the two scenarios:

  • How to concatenate the SharePoint list columns in a Power Apps combo box control.
  • Power Apps concatenate the Combo box selected value with text input to the SharePoint list choice field.

You may also like: