Answered

Gallery Filter

(0) Share

Report

Posted on by 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?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@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.

Was this reply helpful? Yes No
rishimarde 46 on at

Like (0)

Report
Copy link

Link copied!

Thank you so much!! That worked👍

Was this reply helpful? Yes No