How to Set Default Value Blank in Power Apps Cascading Dropdown?

This Microsoft Power Apps tutorial will explain how to set default value blank in Power Apps cascading dropdown.

Let’s implement this property to our Power Apps cascading dropdown so that it will display a blank value as default.

How to Set Default Value Blank in Power Apps Cascading Dropdown

Here, we will see how to set the cascading dropdown default value to blank in Power Apps.

Example,

I have a SharePoint list [Netflix User Information] that has various columns like:

Column NameData Type
User NameTitle
Subscription TypeChoice
DeviceChoice
CountrySingle line of text

Refer to the image below:

Power Apps cascading dropdown default to blank

I created a Power Apps Canvas app and added two Dropdown controls and a Gallery control. The first dropdown control contains values from the SharePoint list choice column [Subscription Type]. The other dropdown contains all the values from another column named “Country. “

When a user selects a blank value from the first dropdown, the second dropdown’s value will also be blank. At the same time, the gallery will filter and display all the records.

Cascading dropdown default to blank in Power Apps

To achieve it, follow the below-mentioned steps:

ClearCollect(
    colBlank,'Netflix User Information',
    {Value: " "}
);

Where,

  1. colBlank = Collection name
  2. Netflix User Information = SharePoint list name
How to set Power Apps cascading dropdown default to blank
  • On the Power Apps screen, insert a first Dropdown control -> Set the below dropdown properties as:
Items = Distinct(colBlank,'Subscription Type'.Value)

AllowEmptySelection = true

Where,

  1. colBlank = Collection name
  2. Subscription Type = SharePoint list choice column name
Set a default value to blank in Power Apps cascading dropdown
  • Below the first dropdown control, insert another dropdown control -> Set the below dropdown properties as:
Items = Distinct(
    Filter(
        colBlank,
        'Subscription Type'.Value = drp_SubscriptionType.Selected.Value
    ),
    Country
)

AllowEmptySelection = true

Where,

  1. colBlank = Collection name
  2. Subscription Type = SharePoint list choice column name
  3. drp_SubscriptionType = First dropdown control name
  4. Country = SharePoint list another column name
How to set cascading dropdown default to blank in Power Apps
  • Insert a gallery control -> Set the Items property to:
Items = If(
    drp_SubscriptionType.Selected.Value = " ",
    'Netflix User Information',
    If(
        drp_Country.Selected.Value = " ",
        'Netflix User Information',
        Filter(
            'Netflix User Information',
            drp_SubscriptionType.Selected.Value = Blank() Or 'Subscription Type'.Value = drp_SubscriptionType.Selected.Value,
            drp_Country.Selected.Value = Blank() Or Country = drp_Country.Selected.Value
        )
    )
)

Where,

  1. drp_SubscriptionType = First dropdown control name
  2. Netflix User Information = SharePoint list name
  3. drp_Country = Second dropdown control name
  4. Subscription Type = SharePoint list choice column name
  5. Country = SharePoint list another column name
How to Set Default Value Blank in Power Apps Cascading Dropdown
  • Save, Publish, and Preview the app. By default, both dropdowns will be selected as an empty value, and the gallery control will be filtered and display all the records.
Power Apps cascading dropdown default value to blank

This way, we can set Power Apps cascading dropdown default value to blank.

Conclusion

In this Power Apps tutorial, I briefly explained how to set Power Apps cascading dropdown default value to blank.

Whenever the user opens the Power Apps app, the cascading dropdown controls should default to a blank value in both dropdowns.

Also, you may like some more Power Apps tutorials: