ComboBox depending dynamically on selection of various comboboxes

[QH_PBA]

Hi There

I have been trying to create a table which can be filtered (similar to excel) by several fields

My Data is as follows

ID	Name Header	Item Header	Description Header	Type Header	Approach Header	Comment Header	Record Header	Data Header	Report Header	Source Header
1	Name 4	Item 4	Description 3	Type 4	Approach 7	Comment 7	Record 10	Data 8	Report 10	Source 2
2	Name 1	Item 4	Description 8	Type 4	Approach 9	Comment 10	Record 1	Data 4	Report 7	Source 10
3	Name 6	Item 8	Description 10	Type 7	Approach 7	Comment 8	Record 3	Data 4	Report 5	Source 3
4	Name 7	Item 10	Description 9	Type 5	Approach 7	Comment 6	Record 8	Data 5	Report 5	Source 10
5	Name 2	Item 9	Description 3	Type 8	Approach 5	Comment 3	Record 7	Data 7	Report 2	Source 1
6	Name 2	Item 6	Description 1	Type 2	Approach 6	Comment 1	Record 5	Data 4	Report 1	Source 10
7	Name 6	Item 4	Description 9	Type 2	Approach 10	Comment 10	Record 6	Data 5	Report 9	Source 7
8	Name 1	Item 7	Description 1	Type 9	Approach 3	Comment 4	Record 2	Data 3	Report 1	Source 3
9	Name 6	Item 5	Description 3	Type 6	Approach 10	Comment 5	Record 9	Data 8	Report 2	Source 1
10	Name 8	Item 4	Description 6	Type 2	Approach 3	Comment 10	Record 5	Data 3	Report 2	Source 6
11	Name 10	Item 1	Description 7	Type 1	Approach 7	Comment 5	Record 7	Data 1	Report 2	Source 1
12	Name 4	Item 1	Description 1	Type 8	Approach 6	Comment 2	Record 6	Data 9	Report 7	Source 2
13	Name 10	Item 7	Description 8	Type 3	Approach 10	Comment 7	Record 2	Data 10	Report 10	Source 3
14	Name 5	Item 6	Description 7	Type 5	Approach 7	Comment 9	Record 4	Data 1	Report 6	Source 3
15	Name 5	Item 6	Description 5	Type 4	Approach 2	Comment 5	Record 2	Data 1	Report 3	Source 3
16	Name 10	Item 7	Description 6	Type 1	Approach 6	Comment 1	Record 9	Data 8	Report 1	Source 3
17	Name 7	Item 1	Description 6	Type 3	Approach 10	Comment 10	Record 5	Data 5	Report 1	Source 6
18	Name 2	Item 6	Description 6	Type 6	Approach 5	Comment 8	Record 6	Data 5	Report 7	Source 4
19	Name 6	Item 5	Description 3	Type 4	Approach 2	Comment 8	Record 4	Data 2	Report 7	Source 3
20	Name 7	Item 5	Description 4	Type 4	Approach 7	Comment 1	Record 9	Data 4	Report 1	Source 1
21	Name 5	Item 5	Description 4	Type 1	Approach 2	Comment 9	Record 1	Data 6	Report 6	Source 8
22	Name 10	Item 6	Description 1	Type 6	Approach 7	Comment 2	Record 3	Data 6	Report 3	Source 3
23	Name 8	Item 1	Description 9	Type 2	Approach 6	Comment 1	Record 7	Data 6	Report 3	Source 7
24	Name 10	Item 8	Description 2	Type 4	Approach 7	Comment 3	Record 3	Data 10	Report 2	Source 2
25	Name 1	Item 6	Description 4	Type 2	Approach 10	Comment 3	Record 10	Data 3	Report 5	Source 4
26	Name 6	Item 5	Description 2	Type 10	Approach 8	Comment 7	Record 5	Data 8	Report 9	Source 4
27	Name 10	Item 6	Description 10	Type 5	Approach 10	Comment 10	Record 3	Data 2	Report 10	Source 9
28	Name 10	Item 8	Description 5	Type 7	Approach 10	Comment 5	Record 5	Data 2	Report 4	Source 6
29	Name 7	Item 9	Description 6	Type 7	Approach 6	Comment 4	Record 2	Data 10	Report 9	Source 2
30	Name 9	Item 10	Description 4	Type 4	Approach 5	Comment 3	Record 6	Data 5	Report 4	Source 6
31	Name 8	Item 8	Description 10	Type 4	Approach 9	Comment 5	Record 6	Data 2	Report 7	Source 8
32	Name 5	Item 2	Description 8	Type 1	Approach 8	Comment 4	Record 7	Data 7	Report 10	Source 2
33	Name 6	Item 10	Description 7	Type 7	Approach 3	Comment 9	Record 3	Data 4	Report 2	Source 5
34	Name 2	Item 5	Description 5	Type 2	Approach 1	Comment 5	Record 3	Data 9	Report 5	Source 2

Ideally I would like something like this

However, given the number columns, this Data Table has to scroll to the right to view all fields and I have not found a way to create filters like this, therefore my other option is to create a series of filters using comboboxes. However, I am struggling in making the comboboxes dependant on more than 1 combobox.

For instance, there is not "Name 4" or "Description 3" for "Item 8".

The selection of these comboboxes will filter the datatable. So my goal is to create these filters to provide the users the possibility filtering the table by several field, so they can find the data the are looking for (Similar to the filters in excel)

I hope this makes sense and really appreciate your assistance on this

Kind Regards

[cha_cha]

Hello @QH_PBA 

You can use Filter function and add filter conditions. 

Example Items code for your database:

Filter(SPListName
	,If(IsBlank(NameHeaderComboBox.Selected.Value), true, 'Name Header'=NameHeaderComboBox.Selected.Value)
	,If(IsBlank(DescriptionComboBox.Selected.Value), true, 'Description Header'=DescriptionComboBox.Selected.Value)
	,If(IsBlank(ItemComboBox.Selected.Value), true, 'Item Header'=ItemComboBox.Selected.Value)
  )

Above Uses true which means they will return all items if there is no selection being made.

I'm just not sure if you wanted a drill down function for the comboboxes themselves as that could pose more complication.

[FLMike]

Hi,

Can you clarify this please:  However, I am struggling in making the comboboxes dependant on more than 1 combobox.

I don't know what you mean by this statement and want to help.

Also, I have an unorthodox solution for you once you answer that is.. I dunno I feel lol cool 🙂

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[QH_PBA]

Hi @FLMike 

Thanks for the reply

I meant, making comboboxes dependant on several comboboxes. For instance, I have the option to make one combobox dependant on another combobox (Below image). 

However, I need the "Item Filter Combobox" to show only those items that are not filtered out in any combo box.

For instance, in dataset above,

First Step: if I filter out, from the "Name Filter ComboBox": "Name 4"; "Name 5", "Name 6"; "Name 7"; "Name 8"; "Name 9"; and "Name 10". The "Item Filter ComboBox" should show only "Item 4"; "Item 5"; "Item 6"; "Item 7"; and "Item 9" (I can obtain this result from the "Depends on..." in from PowerApps).

Second Step: Now, if ( without removing any filter/selection in the "Name Filter ComboBox") I want to include another filter in the "Description Filter ComboBox", to select only "Description 1", the "Item Filter ComboBox" should now show only "Item 6"; and "Item 7", but because I do not know how to link all these, the "Item Filter ComboBox" is still showing "Item 4"; "Item 5"; "Item 6"; "Item 7"; and "Item 9".

As a comparison, the table in excel will look like this:

First Step:

Second Step:

I hope this makes sense

Regards,

[QH_PBA]

Hi @cha_cha 

Thanks for your reply

This will apply to the table correct? Will this work for the interdependency across the filters? If so, Would you mind providing further details?

Regards 

[FLMike]

Yeah I wasnt sure, it sounds like drill down Funneling.