How to Check if Power Apps Combo Box is Empty?

When working with combo box control in Power Apps, you may encounter a situation where you want to check whether the combo box has values based on certain conditions.

I have used a variable to check if the combo box is empty.

In this Power Apps, I will show you how to check if Power Apps Combo box is empty or not with various scenarios.

How to Check if Power Apps Combo Box is Empty

Let’s take an example.

I have two SharePoint lists, namely:

  1. Vendor [SharePoint list 1]
  2. Product List [SharePoint list 2]

Vendor:

This SharePoint list has a column like:

Column NameData Type
VendorsTitle
Power Apps combo box empty value

Products:

This SharePoint list has columns like:

Column NameData Type
ProductTitle
VendorLookup [The column retrieved from Parent Table “Vendor”]
Power Apps check if Combo box is empty

Now, I have added a Dropdown control and a Combo box control on my Power Apps screen. The dropdown control is connected to the above SharePoint list 1 title column [Vendors], and the combo box control is connected to the SharePoint list 2 title column [Product].

When a user selects a value from the dropdown control [Vendor], if the selected vendor doesn’t have the products, the combo box will have empty values and provide the error message “Currently products are not available.”

Power Apps check Combo box empty value

And if the selected vendor has the products, the combo box will display the product names based on the selected vendor.

Check Power Apps if combo box is empty

To achieve it, follow the below steps:

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

Where,

  1. Vendor = SharePoint list name
  2. Title = SharePoint list title column
How to check if Power Apps combo box is empty
  • Select the Dropdown control -> Set its OnChange property as:
Set(
    CountValue,
    CountRows(
        Filter(
            'Product List',
            Vendors.Value = drp_Vendors.Selected.Title
        )
    )
)

Where,

  1. CountValue = Variable name
  2. Product List = Child SharePoint list name
  3. Vendors = Child SharePoint list column name
  4. drp_Vendors = Dropdown control name
  5. Title = Child SharePoint list title column
PowerApps check if the Combo box is empty
  • Insert a Combo box control -> Set its Items property to:
Filter(
    'Product List',
    Vendors.Value = drp_Vendors.Selected.Title
).Title

Where,

  1. Product List = Child SharePoint list name
  2. Vendors = Child SharePoint list column name
  3. drp_Vendors = Dropdown control name
  4. Title = Child SharePoint list title column
check if Combo box is empty power apps
  • Under Combo box control, insert another Text label control and set its Text property:
If(
    CountValue = 0,
    "Currently Products are not available",
    ""
)

Where,

  1. CountValue = Label control name
check if Combo box is empty powerapps
  • SavePublish, and Preview the app. Upon a user selecting a value from the dropdown control, if the combo box is empty, the text label will display as “Currently Products are not available“.
Power Apps check if the Combo box is empty

This is how we can handle the empty Power Apps Combo box.

I hope this Power Apps tutorial has helped check whether the Power Apps Combo box is empty using different examples.

Also, you may like some more Power Apps articles: