Gallery Filter

[rishimarde]

Hi I am trying to filter the Gallery with 

Filter(
Beschaffungen;
'Created By'.Email = User().Email;
If(
FilterbyApproved = true;
Status.Value = "Abgeschlossen";
Status.Value <> ""
);
If(
FilterbyOffen = true;
Status.Value = "in Klärung mit EK" Or "in Klärung mit WL" Or "in Klärung mit AL";
Status.Value <> ""
)
)

but app check is showing warning that "filter" might not work with big datasets.

How can I improve this?

[RandyHayes · Accepted solution]

@rishimarde 

First, you cannot "Or" conditions like that in a formula.  And second, you also cannot delegate a filter for not blank - <> ""

Based on your formula, I am not sure that you actually need the Status.Value <> "", 

so, Please consider changing your Formula to the following:

Filter(Beschaffungen;
    'Created By'.Email = User().Email;
    !FilterbyApproved || Status.Value = "Abgeschlossen";
    !FilterbyOffen || (Status.Value = "in Klärung mit EK" || Status.Value = "in Klärung mit WL" || Status.Value = "in Klärung mit AL")
)

I hope this is helpful for you.

[rishimarde]

Thank you so much!! That worked👍