Unanswered

condition to filter in gallery

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello I have a problem I want to filter a gallery only if it meets a condition which is if the column "Status" = "Participant" where the "Event" = "lblTextoHome.Text" column if this is met then the following filter will be made

FirstN (
        Filter (
            Awards_1,
            Event.Value = lblTextoHome.Text && Raffle = "No"
        ),
        one
    )

the formula does not give error but it does not show me anything check in the list and the status column if it is in "Participant" where the column "Event" = "lblTextoHome.Text"

download (7).png

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

PowerAddict 7,316 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

If I understood you right, you want to filter a gallery only when condition1 and condition2 are met? And what do you want to do if the conditions are not met? Do you then not want to filter at all?

If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!
Hardit(Haman)

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Exactly do not filter anything if it is not met
the problem is that if it is met and still does not filter anything

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

So without getting into details and using generic examples, your gallery should look something like this:

Filter(Source, If(Condition1 && Condition2, Filter1 && Filter2, true))

Does this help?

If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!
Hardit(Haman)

Was this reply helpful? Yes No