Answered

Combo Box filters from Dropdown selection

(1) Share

Report

Posted on by Bonniedog2

I can see other questions that seem to be similar but can't figure out the answer. I have an initial dropdown field titled 'Broad Themes' and below a Combo Box titled 'Sub Themes'. This Combo Box has a large list of items. I want this list of items to filter when a selection is made in the dropdown e.g. I select 'Right to Information' from the dropdown and the combo box only shows the items relevant to 'Right to Information'. This seems simple but I'm missing something. Thanks for any help!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

poweractivate 11,078 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
@Bonniedog2

You can achieve this by using the Filter function in Power Apps.

The idea is to apply a filter to the Items property of your 'Sub Themes' ComboBox based on the selected value of the 'Broad Themes' dropdown.

Here's how you can do this:

Assume you have the following:

1. 'Broad Themes' dropdown has the name Dropdown1
2. 'Sub Themes' combo box has the name ComboBox1
3. 'Sub Themes' data is stored in a data source called SubThemesDataSource, which has a column named 'BroadTheme' that matches the selected value from Dropdown1.

You can filter the 'Sub Themes' ComboBox using a formula like (in the Items property of ComboBox1😞

Filter(SubThemesDataSource, BroadTheme = Dropdown1.Selected.Value)

The formula is applying a filter to SubThemesDataSource, where the BroadTheme of each record is equal to the currently selected value of Dropdown1.

This should make sure that just the related sub-themes are displayed in the ComboBox based on the selected broad theme.

See if this helps @Bonniedog2

Was this reply helpful? Yes No
Bonniedog2 on at

Like (0)

Report
Copy link

Link copied!

Thanks - this works really well, but I can't select multiple options from the Combobox when it populates from the first dropdown box. I can only select one option. Would you know if this is possible? Thanks

Was this reply helpful? Yes No
Bonniedog2 on at

Like (0)

Report
Copy link

Link copied!

Sorry - also had another question. I want to use the 'Broad Themes' and 'Sub Themes' fields in another form and have these responses go to that SP list - is that possible? Thanks

Was this reply helpful? Yes No