Multiple dropdown combination to filter gallery

[Ashok2]

how can we filter gallery with multiple dropdown combination , suppose user have four dropdown he may select two and get combination of result from two dropdown he may select all four or only one .  data may filter in gallery with  any combination ,

[yashag2255]

Hi @Ashok2 

In case of such a scenario, you can use the expression as:

Filter(DataSourceName, If(IsBlank(Dropdown1.Selected.ColumnName),true, ColumnOne = Dropdown1.Selected.ColumnName) && If(IsBlank(Dropdown2.Selected.ColumnName),true, ColumnTwo = Dropdown2.Selected.ColumnName) && If(IsBlank(Dropdown3.Selected.ColumnName),true, ColumnThree = Dropdown3.Selected.ColumnName) && If(IsBlank(Dropdown4.Selected.ColumnName),true, ColumnFour = Dropdown4.Selected.ColumnName)) 

Here, You need to replace ColumnOne, ColumnTwo, ColumnThree & ColumnFour with the name of columns in the DataSource and DropdownX.Selected.ColumnName with the name of column you want to pick from dropdown. If you added a static array you can use DropdownX.Selected.Value.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[mdevaney]

@Ashok2 

Your question is quite general.  Here's an example of mine.  If you need a more specific code example please let me know. 

Filter(
    FPARequests,
    IsBlank(tbYear.Text)=true Or Year = tbYear.Text,
    IsEmpty(cbxRegion.Selected)=true Or Region = cbxRegion.Selected,
    IsBlank(tbCustomer.Text)=true Or Customer tbCustomer.Text,
    IsBlank(tbKeyword.Text)=true Or Keyword = tbKeyword.Text
)

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up." 

[Ashok2]

yes if you can give specific code it will help,i have four dropdown DDL1 ,DDL2,DDL3,DDL4  user can use any number of dropdown to filter gallery any number of combination from1 to four , once he select the combination he will click on button to get records in gallery''

[Ashok2]

I tried this but it only work if all dropdown have values 

Filter(
    Scopes,
    IsBlank(Dropdown1_7.Selected.Result)=true Or Event = Dropdown1_7.Selected.Result,
    IsEmpty(Dropdown1_6.Selected.Result)=true Or Discipline = Dropdown1_6.Selected.Result,
    IsBlank(Dropdown1_5.Selected.Result)=true Or Block= Dropdown1_5.Selected.Result,
    IsBlank(Dropdown1_4.Selected.Result)=true Or 'Request Status'.Value = Dropdown1_4.Selected.Result
)

[mdevaney · Accepted solution]

@Ashok2 

Put this code in the OnChange property of each dropdown.

Set(varDDL1, DDL1.Selected.Value);

Set(varDDL2, DDL2.Selected.Value);

Set(varDDL3, DDL3.Selected.Value);

Set(varDDL4, DDL4.Selected.Value);

Then put this code in the Items property of your gallery.

Filter(
    your_datasource_name,
    Field1 = varDDL1,
    Field2 = varDDL2,
    Field3 = varDDL3,
    Field4 = varDDL4,
)

To clear the gallery when you leave the screen put this code in the OnHidden property of the screen.

Set(varDDL1, Blank());
Set(varDDL2, Blank());
Set(varDDL3, Blank());
Set(varDDL4, Blank());

Please note: and dropdowns that were created using the DISTINCT formula should target .Result instead of .Value.

Set(varDDL1, DDL1.Selected.Result);

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[Ashok2]

I tried but it is not showing any data , 😞

[mdevaney]

@Ashok2 

Two possibilities exist:

#1  No data actually meets the criteria you set

Please prove this is not the case.  Show me how your dropdowns are set and also a screenshot of information in your datasource matching the criteria.

#2 Variables are not properly loading
Show me what the value of each variable is by putting them into a label

#3  The Filter statement is not correct.

Depending on your SharePoint list column types my method might not work.  Once again, you have only supplied GENERAL information and nothing SPECIFIC.  You will need to give all details regarding the column types we are filtering on to get a proper response.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[Ashok2]

I am using below fitler in my item

Filter(Scopes,
    Event = varDDL1,
    Discipline = varDDL2,
    Block = varDDL3,'Request Status'.Value=varDDL4
)

here event is single line text, Discipline is single line text, Block is single line text and Request Status is choice column 

I put all label and they are getting variable values , and filter criteria is ok I have only three items with three different Request Status , please let me know 

[mdevaney]

@Ashok2 

Where did you put this code?

Set(varDDL1, DDL1.Selected.Value);

Set(varDDL2, DDL2.Selected.Value);

Set(varDDL3, DDL3.Selected.Value);

Set(varDDL4, DDL4.Selected.Value);