Filter gallery with buttons

(0) Share

Report

Posted on by redaelaouane

Dears,

Does anyone know how can I make filtering of the gallery with these buttons?

Thank you

Categories:

Building Power Apps

All responses (18)

Answers (4)

Sort by

Verified answer

theapurva 970 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hello @redaelaouane :

you can use if condition in Items:
Steps:

1. On each Button set VarStatus variable to the status: E.g. For

All button OnSelect property should be: Set(varStatus,"All")

In Progress: Set(varStatus,"In Progress")

Completed: Set(varStatus, "Completed")

2. Items Formula should be

If(varStatus="All",YourListName, //Display all items (without any filter) Filter(YourListName,Status=varStatus)) // Display items fitered by Selected Status
redaelaouane 59 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @theapurva ,

Is it normal that I cant find "items" to put the formula?
VJR 7,635 on at

Like
a
(2)

Report
Copy link

Link copied!

theapurva's solution is perfect. No, its not normal that you can't see Items. 🙂 Make sure to click the Gallery control on the left hand side list of controls (and not any data card or any other control).
redaelaouane 59 on at

Like
a
(0)

Report
Copy link

Link copied!

Alright,

Thank you @VJR
Found! but still few issues,

The "All" thing doesnt work
VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

It is some other part of the Formula that has an error and is not visible in the screenshot.
redaelaouane 59 on at

Like
a
(0)

Report
Copy link

Link copied!

@VJR The problem is located in the gallery, when i put the formula on Items 😞
VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

Please share your complete formula
redaelaouane 59 on at

Like
a
(0)

Report
Copy link

Link copied!
followed all these steps that shared by @theapurva

Steps:
1. On each Button set VarStatus variable to the status: E.g. For
All button OnSelect property should be: Set(varStatus,"All")
In Progress: Set(varStatus,"In Progress")
Completed: Set(varStatus, "Completed")
2. Items Formula should be
If(varStatus="All",YourListName, //Display all items (without any filter) Filter(YourListName,Status=varStatus)) // Display items fitered by Selected Status

@VJR Thank you so much for your help
VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

Filter(YourListName,Status=varStatus))

In this line, what is Status, where is it coming from?
redaelaouane 59 on at

Like
a
(0)

Report
Copy link

Link copied!

@VJR Status is one of the items on the list on Sharepoint. it shows the status of the request; new, in progress or Completed