Power Apps Combo Box Select All

Did you know that by using the “Select All” Check box, the Combo box control will select all values in the Combo box? If not, don’t worry!!

This Power Apps tutorial will explain how to work with Power Apps Combo Box Select All.

Moreover, I will show you how to filter the Power Apps gallery using the Combo box ‘Select All” option.

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

Power Apps filter gallery based on Power Apps Combo box “Select All” option

In this scenario, I will explain how to filter the Power Apps gallery using the Combo box ‘Select All” option.

For Example,

I created a Power Apps Canvas app and added a Combo box and Gallery control. The combo box is connected to the above SharePoint list choice column.

Within the Combo box, we have manually added the “Select All” option to be included as a possible selection. Whenever the user selects a value as “Select all” from the combo box, the gallery will display all records associated with the values in the Combo box.

Add option to select All for Power Apps combo box

Let me show you how to achieve this:

  • On the Power Apps screen, insert a Combo box control -> Set its Items property to:
Filter(
    Split(
        "Select All;" & Concat(
            'Loan Approval',
            'Loan Type'.Value & ";"
        ),
        ";"
    ),
    !IsBlank(Value)
)

Where,

  1. Loan Approval = SharePoint list name
  2. Loan Type = SharePoint list choice column name
Add a Select ALL option in multi select dropdown in PowerApps
  • Insert a Gallery control -> Set its Items property to:
Filter(
    'Loan Approval',
    If(
        IsBlank(cmb_LoanType.Selected.Value) || cmb_LoanType.Selected.Value = "Select All",
        true,
        'Loan Type'.Value = cmb_LoanType.Selected.Value
    )
)

Where,

  1. Loan Approval = SharePoint list name
  2. Loan Type = SharePoint list choice column name
  3. cmb_LoanType = Combo box control name
Selecting all the items in combo box using powerapps
  • Once your app is ready, Save, Publish, and Preview the app. When the user selects a “Select All” value from the Combo box control. Then, the gallery will filter and display all records associated with the values in the Combo box.
Selecting all the items in Power Apps combo box

We can achieve this by filtering the Power Apps gallery using the Combo box ‘Select All” option.

Conclusion

In this Power Apps tutorial, I have explained by checking the “Select All” Check box, the Combo bo control will automatically select all values present in the Combo box

Lastly, I have covered how to filter the Power Apps gallery using the Combo box ‘Select All” option.

Additionally, you may like some more Power Apps tutorials: