Answered

Gallery Filter Syntax

(0) Share

Report

Posted on by JR-BejeweledOne

5,836 Moderator

I have an If statment filtering a gallery. The items displayed in the gallery are based on the values in 2 dropdowns and works nicely.

If(
 !IsBlank(DropdownRegion2), Sort(Filter(Holidays, CountryNoRegion = DropdownCountry2.Selected.Result && Region = DropdownRegion2.Selected.Result), Date, Ascending),
 Sort(Filter(Holidays, CountryNoRegion = DropdownCountry2.Selected.Result), Date, Ascending)
)

I need to add a new condition. If the condition is met I want the gallery to not display anything at all. But I don't know how to do the last part of the syntax. I need to add this as the first condition of the If statement. I have validated that the first part works.

If(
 CountRows(Distinct(Filter(Holidays, CountryNoRegion = DropdownCountry2.Selected.Result && !(Region = CountryNoRegion)), Region)) >0 && IsBlank(DropdownRegion), Not sure what to put here for displaying nothing

)

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

zmorek 3,272 on at

Like
a
(0)

Report
Copy link

Link copied!

Can you put that on the Visible property of the gallery?

Was this reply helpful? Yes No
Verified answer

JR-BejeweledOne 5,836 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
I made the age old error of assuming that the dropdown would be blank if nothing was selected and I was wrong.

I did take your suggestion, but I modified the formula. I set a context variable on select of the region and set it back to false on select of a different country. So my visible formula is this:

If(CountRows(Distinct(Filter(Holidays, CountryNoRegion = DropdownCountry2.Selected.Result && !(Region = CountryNoRegion)), Region)) >0 && !ShowGallery,false, true)

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

Like
a
(0)

Report
Copy link

Link copied!

Is it possible if the column condition is a variable?
Example below:
Filter(EXTRA_EMP_FIELD, LookupExtra = LookUpValue)
where EXTRA_EMP_FIELD is the source
and LookUpExtra & LookUpValue are variables

Was this reply helpful? Yes No