Filter in a Gallery

(0) Share

Report

Posted on by Bergh

88 Season of Giving Solutions 2025

I have a Sharepoint list with 800 rows. I have four galleries and I want to filter like this:

If(

LookUp(

Filter(colToha; ID >= 1 && ID <= 280);

Status = "Loading"

);

true;

false

)

So if the word Loading is in status between row 1 to row 280 then show the gallery.
If should be nice if I can have on gallery and the gallery was filtred like:

If(

LookUp(

Filter(colToha; ID >= 1 && ID <= 280);

Status = "Loading"

);

Filter(colToha; ID >= 1 && ID <= 280);

If(

LookUp(

Filter(colToha; ID >= 281 && ID <= 560);

Status = "Loading"

);

Filter(colToha; ID >= 281 && ID <= 560);

false

)

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

BCBuizer 22,854 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Bergh ,

I'm not sure if I understood what you are trying to achieve, but please try the below formula for the Items property of the gallery to show all items where the Status value is "Loading":

Filter(colToha; Status = "Loading")
Bergh 88 Season of Giving Solutions 2025 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, It is not that simple. I want the gallery to be visible on true, so if the blue spot is "Loading" I want that gallery 2 to be visible and not the other three.
Verified answer

BCBuizer 22,854 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Bergh ,

Understood what you mean now.

For this, please set the Visible property of all galleries to:

"Loading" in Self.AllItems.Status.Value