Power Apps Combo Box Control [How to Use]

If you are new to Power Apps, it’s essential to understand the various Power Apps controls available. The Power Apps Combo Box control is among the most important controls.

Users can select from a provided list of choices, and it supports single or multiple selection capabilities.

In this Power Apps tutorial, we will discuss what Power Apps combo box control is and its key properties in detail.

Moreover, by this tutorial, you will learn how to use a Power Apps combo box control with a simple scenario and many more:

  1. Power Apps Combo Box OnChange
  2. What are the limitations of the Power Apps combo box
  3. Power Apps Combo box tooltips
  4. How to remove Power Apps Combo box selected item

Power Apps Combo Box Control

Power Apps Combo box control helps users select from a provided list of choices. The choices in a combo box are usually displayed in a drop-down list format.

Using the combo box control, the user can type directly into the box to search for a specific option. Power Apps combo box control supports single or multiple selection capabilities.

If the user needs to search for an item containing any numbers, we can use the Text() function to convert numbers into text. For example, Text(6789).

We can utilize the combo box control as a people picker.

Note,

The combo box helps to display a single data value, a picture, and a person value for each item by modifying the layout settings in the data pane.

Power Apps Combo Box Control Properties

Here, I will explain all the properties of the Power Apps Combo box control:

Property NameDescription
Border ColorA user can specify the color for a border.
Border StyleThis property specifies the type of border that the control should have [“Solid,” “Dashed,” “Dotted,” “None”].
ChevronHoverBackgroundUsers can specify the background color for a chevron.
DefaultSelectedItemsWhen the user opens the app, by default the item should be selected. For this, we can specify single or multiple items to the combo box DefaultSelectedItems property.
DisplayFieldsThis property helps to display the list of fields for a search result.
DisplayModeThis property allows user input to edit, display data [view], or disable.
InputTextPlaceholderDisplay the instructional text to users when the items are not selected in a combo box control.
ItemsTo represent the values in a combo box, we can specify the data source along with the column name, else we can provide it manually.
OnChangeWhen the user changes a selection, it specifies what action to perform.
OnSelectWhen the user clicks on a control, it specifies what action to perform.
SearchFieldsSpecify the field or column within the combo box control you wish to search.
SelectMultipleUsing this property, we can provide the authority to the user, whether they can select single or multiple items.
TabIndexThis refers to the keyboard navigation sequence that is related to other controls.
VisibleHere, we can specify whether the combo box control can be visible.

Now, let’s check how to work with a combo box control in Power Apps.

How to use a Power Apps Combo box control

We can work with a combo box control in different scenarios, like:

  1. Power Apps combo box add items manually.
  2. Power Apps combo box items from the SharePoint list.

Power Apps combo box add items manually

Let’s see how to add items manually in the Power Apps combo box control.

  • Sign in to your Power Apps with your valid Microsoft 365 credentials.
  • Create a Blank canvas app -> On the Power Apps screen, insert a Combo box control [Click on +Insert -> Expand Input -> Select Combo box].
Power Apps combo box control
  • By default, the combo box control name will be “ComboBox1“; based on your requirement, you can Rename it.
Combo box control in Power Apps
  • Select a Combo box control -> Set its Items property to:
["Basic", "Standard", "Premium"]
Power Apps combo box add items manually
  • SavePublish, and Preview the app. Now, the combo box control contains the items that we added manually.
Combo box add items manually in Power Apps

Now you know how to add the combo box items in Power Apps manually, let’s check how to add the combo box items using a SharePoint list column in Power Apps.

Power Apps combo box items from the SharePoint list

I will show you how to insert items to the Power Apps combo box control using a SharePoint list as a data source.

Example,

I have a SharePoint list [Employee Details], which has various columns like:

Column NameDate Type
Issue IDTitle
IssueSingle line of text
Issue TypeChoice [“Laptop,” “Smart Phone,” “Desktop”]
TimelineChoice [“2 Days”, “3 Days”, “4 Days”]
Issue Assigned ToLookup
How to use combo box control in a Power Apps

In Power Apps, a Combo box control is connected to the above SharePoint list choice column [Timeline].

Power Apps combo box items from a SharePoint list

To achieve this, follow the below steps:

Power Apps combo box with SharePoint Online list
  • On the Power Apps screen, insert a Combo box control -> Set its Items property to:
'IT Support Ticket'

Where,

  1. IT Support Ticket = SharePoint list name
Power Apps combo box using a SharePoint list
  • On the Combo box properties pane, Click on Edit Fields -> Select the particular field in both “Primary text” and “Search fields” that you want to display in the combo box.
Power Apps combo box add items from SharePoint list
  • SavePublish, and Preview the app. The combo box control now contains the values from the above SharePoint list column [Timeline].
Power Apps combo box SharePoint online list

This is how we can work with a Power Apps combo box with different scenarios. Now, let’s check the limitations of this Combo box control.

Power Apps Combo Box OnChange

Let’s see how the application responds when users change the Power Apps combo box selected value.

Example 1:

I have a SharePoint Online list [User Details] that has various columns like:

Column NameData Type
User IDTitle
User Join DateDate and time
User Subscription TypeChoice [“Premium,” “Standard,” “Basic”]
User DeviceChoice [“Premium,” “Standard”, “Basic”]
Power Apps Combo Box OnChange

I created a Power Apps Canvas app and added an Edit form. The form contains the Combo box control connected to the above SharePoint list choice column [User Subscription Type]. The Power Apps combo box will display its default value as “Basic.”

When a user changes the selected value in the combo box to “Premium,” the text label will display as shown below:

Power Apps OnChange property of the Combo box

Follow the below-mentioned steps to achieve it:

1. Sign in to your Power Apps with your valid Microsoft 365 credentials.

2. Create a Blank canvas app -> 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,

  • User Details = Datasource name
How to use the Combo box OnChange property in Power Apps

3. Select the Combo box -> Set its OnChange property to:

Set(
    varSubscription,
    DataCardValue2.Selected.Value = "Premium"
)

Where,

  • varSubscription = Provide the variable name
  • DataCardValue2 = Combo box control name
  • Premium = Combo box value
Combo box OnChange property in Power Apps

4. The text label should display when a user changes the combo box selected value. For that, Select the User Subscription Type DataCard -> Insert the Text label -> Set its Text property as:

"20% Offer"
Power Apps combobox onchange issue

5. Select the Text label -> Set its Visiblity property to:

varSubscription 

Where,

  • varSubscription = Variable name
Power Apps Combo box multiselect OnChange

6. Once your app is ready, Save, Publish, and Preview the app. When a user changes the selected value in the combo box to “Premium,” the text label will display a “20% Offer”.

OnChange property of the Power Apps Combo box

This is how we can work with the Power Apps Combo box OnChange property.

Example 2:

I have a SharePoint Online list [Loan Approval] that has various columns like:

User NameTitle
Loan TypeChoice [“Home Loan,” “Car Loan,” “Gold Loan”]
Loan Application DateDate and time
Loan Handled ByPerson or group
How to work with Power Apps Combo box OnChange

I created a Power Apps Canvas app and added a Combo box and Gallery control. The combo box is connected to the SharePoint list person column [Loan Handled By].

When a user changes the values from the Combo box control, the gallery will filter and display the user name based on the selected combo box value, as shown below:

How to use a OnChange property of a Power Apps Combo box

To achieve it, follow the below steps:

1. On the Power Apps screen, insert a Combo box control -> Set its Items property to:

Distinct(
    'Loan Approval',
    'Loan Handled By'
)

Where,

  • Loan Approval = SharePoint list name
  • Loan Handled By = SharePoint list person column name
Combo box OnChange in Power Apps

2. Select the Combo box -> Set its OnChange property to:

Set(
    varLoanApproval,
    cmb_LoanHandledBy.Selected.Value
)

Where,

  • varLoanApproval = Provide the variable name
  • cmb_LoanHandledBy = Combo box control name
Use a OnChange property of a Combo box

3. The gallery will display when a user changes the combo box selected value. For that, insert a Gallery control -> Set its Items property to:

Filter(
    'Loan Approval',
    IsBlank(cmb_LoanHandledBy.SelectedItems.Value) || IsEmpty(cmb_LoanHandledBy.SelectedItems.Value) || 'Loan Handled By' = varLoanApproval
)

Where,

  • Loan Approval = SharePoint list name
  • Loan Handled By = SharePoint list person column name
  • varLoanApproval = Variable name
  • cmb_LoanHandledBy = Combo box control name
Power Apps Combo box OnChange is not working

4. Once your app is ready, Save, Publish, and Preview it. When a user changes the selected value in the combo box, the gallery will display the user names based on that value.

Combo box multiselect OnChange in Power Apps

Set Combo Box Value On Button Click in Power Apps

Here, I will explain how to change a combo box value based on a button click.

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”]
Issue Handled ByPerson or group
Power Apps set combo box value on button click

Now let’s see how to achieve it:

How to set s Power Apps combo box value on button click

Step 1: [Insert a Dropdown control and connect to an above SharePoint list column]

  • Insert a Dropdown control -> Set its Items property to:
Choices('IT Service Request'.Issue)

Where,

  1. IT Service Request = SharePoint list name
  2. Issue = SharePoint list choice column name
Change a Power Apps combo box value by clicking a button control

Step 2: [Insert a Combo box control and connect to an Office365Users]

  • On the +Add data -> Connect the Data source to an Office365Users.
Power Apps change combo box value on button click
  • Insert a Combo box control -> Set its Items property to:
Office365Users.SearchUser({searchTerm: cmb_IssueHandledBy.SearchText})
Change Power Apps combo box value by clicking a button

Step 3: [Insert a button control and create a variable to set a combo box value]

  • Insert a Button control -> Set its OnSelect property to:
Set(
    varIssue,
    If(
        DrpIssue.Selected.Value = "Laptop",
        "Henrietta Mueller",
        If(
            DrpIssue.Selected.Value = "Outlook",
            "Lynne Robbins",
            If(
                DrpIssue.Selected.Value = "Network",
                "Lidia Holloway",
                "Megan Bowen"
            )
        )
    )
)

Where,

  1. varIssue = Provide the variable name
  2. DrpIssue = Dropdown control name
  3. Laptop, Outlook, Network = SharePoint list choice column values
How to change a Power Apps combo box value by clicking a button

Step 4: [On the combo box control, assign a variable to set a combo box value]

  • Select a Combo box control -> Set its DefaultSelectedItems to:
[varIssue]

Where,

  1. varIssue = Assign the variable name here
Set Power Apps combo box value with button control
  • SavePublish, and Preview the app when a user selects a value from the dropdown control [Issue] and clicks on a button control. The combo box will automatically select a user who is responsible for that specific issue.
How to set a combo box value on button click in Power Apps

This is how to change a combo box value based on a button a click in Power Apps.

Power Apps Combo Box Limitation

This section will explain about Power Apps combo box limitations:

  • Power Apps Combo box can only deal with 2000 records, but By default, the Data row limit is set to 500.

The main question is: How much data can I show in the Power Apps combo box control?

Answer = The maximum number of items the Combo box can contain depends on the app limit.

Note,

Further, if you are getting a “Power Apps delegation warning” while working with combo box control. To overcome it, just check out the complete article: “Delegation Warning in Power Apps Combo box [How to Overcome]

This is the limitation of the Power Apps Combo box control.

Power Apps Combo box tooltips

The Power Apps combo box has a property called “tooltips.” let me explain this.

A tooltip is a succinct, informative message designed to appear when users interact with a combo box. For example, we might provide the tooltip “Select preferred Power Platform Course.”

Power Apps Combo box control Tooltip

To achieve it, follow the below steps:

  • Click on the Properties panel of the combo box control -> Under the Tooltip option -> You can insert a succinct message to display on the tooltip.
Tooltip on a Power Apps combo box control
  • Save, Publish, and Preview the app. Now, hover over the Combo box control, and the tooltip will display a message as “Select preferred Power Platform Course,” as shown below:
Combo box control Tooltip in Power Apps

This is how the Power Apps Combo box tooltip property works.

Power Apps Combo Box Select All

In this section, I will show you how to select all values in the Combo box using the “Check Box” labeled “Select All.

Example,

I have a SharePoint Online list [Loan Approval] that has various columns like:

Column NameData Type
User NameTitle
Loan Applied DateSingle line of text
Loan TypeChoice [“Home Loan,” “Car Loan,” “Gold Loan”]
Loan Handled ByPerson or group

I created a Power Apps Canvas app and added an Edit form connected to the above SharePoint list.

In the form, I added a Check box control labeled “Select All.” Upon checking the “Select All” Check box, the Combo box control will automatically select all values present in the Combo box, as shown below:

Power Apps Combo Box Select All

Follow the below steps to achieve it:

  • 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:
DataSource = 'Loan Approval'

Where,

  • Loan Approval = SharePoint list name
Combo box Select All in Power Apps
  • Select the Loan Type DataCard -> Insert a Check box -> Set its Text property to:
"Select All"
Select All for a Multi-select combobox field in Power Apps
  • Select the Check box -> Set its OnCheck property to:
If(
    chk_LoanType.Value,
    Set(
        varSelectAll,
        [
            "Home Loan",
            "Gold Loan",
            "Car Loan",
        ]
    ),
    Set(
        varSelectAll,
        []
    )
)

Where,

  1. chk_LoanType = Check box control name
  2. varSelectAll = Provide the variable name
Select All for a Multi-select Power Apps combobox
  • Select the Power Apps Combo box control [Loan Type] -> Set its DefaultSelectedItems to:
varSelectAll

Where,

  1. varSelectAll = Varible name
Power Apps Select All for a Combo Box
  • Once your app is ready, Save, Publish, and Preview the app. When the user selects the check box “Select All.” the combo box control will automatically select all the values from the Combo box.
How to select All for a Multi-select Power Apps combobox
  • Now, if we want to save the multiple selected values to the SharePoint list, insert a Button control -> Set its OnSelect property to:
Patch(
    'Loan Approval',
    Defaults('Loan Approval'),
    {
        Title: DataCardValue6.Text,
        'Loan Type': DataCardValue7.SelectedItems,
        'Loan Applied Date': DataCardValue10.SelectedDate,
        'Loan Handled By': txt_LoanHandledBy.Text
    }
)

Where,

  1. Loan Approval = SharePoint list name
  2. Loan Type = SharePoint list choice column name
  3. DataCardValue7 = Combo box control name
How to select All for a Multi-select combobox field in Power Apps
  • Save, Publish, and Preview the app. When the “Select All” checkbox is selected, the combo box control will automatically choose all values in the Combo box. When the user clicks the submit button, all of the user’s choices are stored in the SharePoint list choice column, as illustrated below:
Select All values of Power Apps Combo box

This is how to work with Power Apps Combo Box Select All.

Remove Power Apps Combo box selected item

In this section, I will explain how we can remove the selected item from the combo box, including its corresponding items, gallery, and a SharePoint list.

Example,

I have a SharePoint list [Vendors], which has a column as shown below:

Column NameData Type
VendorsTitle
Power Apps Combo box remove selected item

I have created a Power Apps Canvas app and then added a Combo box control and a Gallery control. Both controls are connected to the above SharePoint list title column.

Remove the Power Apps Combo box selected item

Also on my Power Apps screen, there is a Button control. Whenever the user selects a value from the Combo box control and clicks on a button control. That selected value will be removed from its corresponding items, the gallery control.

And also the selected item will also be removed from a SharePoint list.

Power Apps remove Combo box selected item

Let’s see how to achieve this:

  • On the Power Apps screen, insert a Combo box control -> Set its Items property to:
Vendors.Title

Where,

  1. Vendors = SharePoint list name
  2. Title = SharePoint list title column
Power Apps remove a single selected item from a Combo Box
  • Insert a Gallery control -> Set its Items property to:
Vendors

Where,

  1. Vendors = SharePoint list name
How to remove the Combo box selected value in Power Apps
  • Insert a Button control -> Set its OnSelect property to:
RemoveIf(
    Vendors,
    Title = cmb_Vendors.Selected.Title
);
Reset(cmb_Vendors);

Where,

  1. Vendors = SharePoint list name
  2. Title = SharePoint list title column
  3. cmb_Vendors = Combo box control name
Remove already selected item from Power Apps combo-box choices
  • Once your app is ready, just SavePublish, and Preview the app. When the user selects any value from the combo box and clicks on button control. The selected value will be removed from its corresponding items, the gallery control.
  • Also, the selected item will also be removed from a SharePoint list.
Remove Combo box selected item in Power Apps

This is how we can remove the Power Apps combo box selected item.

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 that this Power Apps tutorial provides you with a clear picture of the “Power Apps Combo box control.” This control allows you to display a list of items in a drop-down list format and select multiple items from it.

Moreover, you have learned about the Power Apps Combo box control key properties and how to work with a combo box control in different scenarios by adding the items manually and using a SharePoint list.

Lastly, we discussed the limitation of the Power Apps combo box control, Power Apps Combo box onchange, and how to display the informative message when the user interacts with a combo box using a tooltip property of a Power Apps Combo box control.

Also, you may like some more Power Apps tutorials: