Solved! Go to Solution.
Hi @AKB_2K ,
Do you want if the dropdown1 select May,drop down2 select Month, the gallery will display items only in May;
if the dropdown1 select May,drop down2 select All, the gallery will display all items?
I suggest you use if statement.
Could you tell me what's the field's data type that you want to filter according to?
I've made a similar test for yoyr reference:
I use the field named created to filter data and its data type is date.
1)Set drop down1's Items: Distinct(fruit,Month(Created))
2)Set drop down2's Items: ["all","month"]
3)Set the gallery's Items:
If(Dropdown2.Selected.Value="all",tablename,
Dropdown2.Selected.Value="month",Filter(tablename,Month(Created)=Dropdown1.Selected.Result)
)
Best regards,
Community Support Team _ Phoebe Liu
Shows us teh gallery filter to look at.
I do some gallery filters based on mutiple selections but it depends on the fields to be found
Hi @AKB_2K ,
Do you want if the dropdown1 select May,drop down2 select Month, the gallery will display items only in May;
if the dropdown1 select May,drop down2 select All, the gallery will display all items?
I suggest you use if statement.
Could you tell me what's the field's data type that you want to filter according to?
I've made a similar test for yoyr reference:
I use the field named created to filter data and its data type is date.
1)Set drop down1's Items: Distinct(fruit,Month(Created))
2)Set drop down2's Items: ["all","month"]
3)Set the gallery's Items:
If(Dropdown2.Selected.Value="all",tablename,
Dropdown2.Selected.Value="month",Filter(tablename,Month(Created)=Dropdown1.Selected.Result)
)
Best regards,
Community Support Team _ Phoebe Liu