Use And/Or together to filter a gallery

[Sanranaji]

Hi experts, Can you help me to figure out what am I doing wrong in below: I am stuck on this for last 3 days and can't seem to get this working:

I have a gallery and I want to filter it on basis of few drop downs & a checkbox (if the value is true). I have the following formula which works fine:

Filter('Gallery', If(Not(Dropdown1.Selected.Result = "- Select -"), Dropdown1.Selected.Result = Country, Not(Dropdown2.Selected.Result = "- Select -"), Dropdown2.Selected.Result = Region, Not(Dropdown3.Selected.Result = "- Select -"), Dropdown3.Selected.Result = Area) || If(Checkbox1.Value = true, Dropdown2.Selected.Result = 'Geo-Region'))

I am trying to add one && condition (in red below) so that if the chkboxpendingreview is ticked then the gallery only shows me the items where dropdown.value = pending review.

But it doesn't work. When I check the chkboxpendingreview then the gallery doesn't show anything even if I have items in it where the dropdown values are pending reviews. Can someone help me to figure out what am I doing wrong?

Filter('Gallery', If(Not(Dropdown1.Selected.Result = "- Select -"), Dropdown1.Selected.Result = Country, Not(Dropdown2.Selected.Result = "- Select -"), Dropdown2.Selected.Result = Region, Not(Dropdown3.Selected.Result = "- Select -"), Dropdown3.Selected.Result = Area) && If(ChkBoxPendingReview.Value = true, dropdown.Value = "Pending Review") || If(Checkbox1.Value = true, Dropdown2.Selected.Result = 'Geo-Region'))

[v-siky-msft]

Hi @Sanranaji 

Could you try this?

Filter(If(ChkBoxPendingReview.Value = true, Filter('Gallery', dropdown.Value = "Pending Review"),'Gallery'),
If(
Not(Dropdown1.Selected.Result = "- Select -"), Dropdown1.Selected.Result = Country,
Not(Dropdown2.Selected.Result = "- Select -"), Dropdown2.Selected.Result = Region,
Not(Dropdown3.Selected.Result = "- Select -"), Dropdown3.Selected.Result = Area
) &&
If(Not(Dropdown4.Selected.Result = "- Select -"), Dropdown4.Selected.Result = SSL.Value)
||
If(Checkbox1.Value = true, Dropdown2.Selected.Result = 'Geo-Region')
)

The logic is much clearer this time, but I still have a little confusion with this sentence. What is SSL check?

- Same for SSL check. If the SSL check doesn't match then I should get the results where DropDown4.selected.result = SSL.Value.

Sik

[Sanranaji]

Thank you @WarrenBelz. It doesn't work. I am not sure if the syntax is correct. I don't want the && condition for all the dropdowns. It's more of a cascade for the first half of the If statement.

If(condition A is correct, Filter X, condition B is correct, Filter Y, condition C is correct, Filter Z) && if(condition D is correct, Filter M as well in addition to what is already filtered in the first If statement) && if(condition E is correct, Filter O as well in addition to what is already filtered in first If statement and second if statement)

The answer provided by Sik yesterday was able to give me the results for first two If statements . I am trying to add third if but it doesn't work.

[WarrenBelz]

Hi @Sanranaji ,

To make this easier, can you type in plain text what you want

So

1. Condition xxxx and xxxx - filter by xxxx
2. Condition (xxxx and xxxx) or (xxxx and xxxx) - filter by xxxx
3. Condition xxxx or xxxx - filter by xxxx

and so on.

[Sanranaji]

Thank you @v-siky-msft. For the SSL, that was a typo :)I  meant to say if the SSL condition matches then it should filter the results as per logic.

I am providing more clear code (well I need to think about company privacy guidelines 🙂 )

Filter(If(ChkBoxPendingReview.Value = true, Filter('Gallery', 'IT Sponsor decision'.Value = "Pending Review"), 'Gallery'), 
If(
DrpDownCountry.Selected.Result <> "- Select -", DrpDownCountry.Selected.Result = Country,
DrpDownRegion.Selected.Result <> "- Select -", DrpDownRegion.Selected.Result = Region,
DrpDownArea.Selected.Result <> "- Select -", DrpDownArea.Selected.Result = Area
)&&
If(DrpDownSSL.Selected.Value <> "--Select--", DrpDownSSL.Selected.Value = SSL.Value)
|| If(Checkbox1.Value = true, DrpDownRegion.Selected.Result = 'Geo-Region')
)

here are the results:

1. If I choose values in any of the country, region & area dropdowns, it doesn't show anything. I think it is because of the && condition. If I remove the SSL.selected.value condition in the above code then these dropdowns are working fine.

2. If I check the Checkbox1 then it shows me items as per the condition in it. I think this checkbox1 condition is with an or (||) function so in most of the condition this works fine.

3. If I choose anything on the SSL dropdown, it doesn't do anything.

Is there a way to put DrpDownSSL.Selected.Value also on the top layer like we have put ChkBoxPendingReview.Value. I tried doing that myself but with no success.

[v-siky-msft]

Hi  @Sanranaji ,

Could you please try this:

Filter(
If(
ChkBoxPendingReview.Value = true && DrpDownSSL.Selected.Value <> "--Select--", Filter('Gallery', 'IT Sponsor decision'.Value = "Pending Review"&& SSL.Value =DrpDownSSL.Selected.Value),
ChkBoxPendingReview.Value = false && DrpDownSSL.Selected.Value <> "--Select--", Filter('Gallery', SSL.Value =DrpDownSSL.Selected.Value),
ChkBoxPendingReview.Value = true && DrpDownSSL.Selected.Value = "--Select--", Filter('Gallery', 'IT Sponsor decision'.Value = "Pending Review"),
'Gallery'), 
If(
DrpDownCountry.Selected.Result <> "- Select -", DrpDownCountry.Selected.Result = Country,
DrpDownRegion.Selected.Result <> "- Select -", DrpDownRegion.Selected.Result = Region,
DrpDownArea.Selected.Result <> "- Select -", DrpDownArea.Selected.Result = Area
)
||
If(Checkbox1.Value = true, DrpDownRegion.Selected.Result = 'Geo-Region')
)

 Hope this helps.

Sik

[v-siky-msft]

Hi @Sanranaji ,

Has your issue been resolved?

Feel free to post back if there are any problems.

Sik