2 dropdowns and search bar

[sahim]

Hello Community,

I have a problem with filtering on the dataset. It is in sharepoint.

My requirement is to have 2 dropdown filters and then a search feature to narrow down the result from dataset. 

1)My first dropdown has duplicate values that I want to remove. 

It seems that the dropdown is looking at individual values from dataset and not grouping them. 

2) My 2nd dropdown has full list- i want it to filter based on selection of 1st dropdown.

3) The search is working on material description:

SortByColumns(Filter([@'List of Top Ducab Materials'], StartsWith('Material Description',TextSearchBox1.Text)||StartsWith(Text(Material),TextSearchBox1.Text) || StartsWith('Material Description',TextSearchBox1.Text)),"Material",If(SortDescending1,Ascending,Descending))

I need both dropdowns and search for material

Please help. 

Thanks.

[eka24]

Use these steps:

Dropdown1 Items:

Distinct(SPList1,ColumnName)

Dropdown2 Items:

Filter(Datasource,ColumnName=Dropdown1.Selected.Result)

The Search Formula:

SortByColumns(Filter([@'List of Top Ducab Materials'], StartsWith('Material Description',TextSearchBox1.Text)||StartsWith(Text(Material),TextSearchBox1.Text) || StartsWith('Material Description',TextSearchBox1.Text)&&Dropdown2.Selected.ColumnName),"Material",If(SortDescending1,Ascending,Descending))

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[sahim]

Thank you so much @eka24 

The dropdown are functioning correctly.

But the search and list is not correct. 

My requirement is for the list gallery to be all the items that are selected in the 1st dropdown. 

But the gallery is still showing all the items. 

SortByColumns(Filter([@'List of Top Ducab Materials'], StartsWith('Material Description',TextSearchBox1.Text)||StartsWith(Text(Material),TextSearchBox1.Text) || StartsWith('Material Description',TextSearchBox1.Text)&& Dropdown2.Selected.'Group Description'),"Material",If(SortDescending1,Ascending,Descending))

I want the gallery to be showing only the list of the dropdown1: each distict has 10 rows of data. 

Thanks.

[eka24]

Try
SortByColumns(Filter([@'List of Top Ducab Materials'], StartsWith(Text(Material),TextSearchBox1.Text) || StartsWith('Material Description',TextSearchBox1.Text),'Group Description' = Dropdown2.Selected.'Group Description'),"Material",If(SortDescending1,Ascending,Descending))

or

SortByColumns(Filter([@'List of Top Ducab Materials'], StartsWith(Text(Material),TextSearchBox1.Text) || StartsWith('Material Description',TextSearchBox1.Text)&&'Group Description' = Dropdown2.Selected.'Group Description'),"Material",If(SortDescending1,Ascending,Descending))

I realized a repetition of StartsWith('Material Description'

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[sahim]

I have now modified it to have only one drop down menu. 

When I enter the below. 

SortByColumns(Filter([@'List of Top Ducab Materials'], StartsWith('Group Description',TextSearchBox1.Text)||StartsWith(Text(Material),TextSearchBox1.Text) || StartsWith('Group Description',TextSearchBox1.Text)&& Dropdown1.Selected.Result),"Material",If(SortDescending1,Ascending,Descending))

I have selected group description but the gallery is showing the complete list. 

My requirement is to show only the values based on the "group description" selected

And then the search feature must work on the gallery values. 

I hope this is clear. 

Sorry I am a very new at this hence the changes.

Thanks.