Applying filters to buttons

(1) Share

Report

Posted on by heycanyouhelpme

Hello Community,

2 questions:

I'll keep this simple.

Question 1: I'm building an app in PowerApps. I have a gallery that lists items in various statuses.

I have 4 buttons and I want them the function as follows:

Button 1 - "All" - View all records in the Gallery

Button 2 - "Pending Approval" - View all records that are pending approval

Button 3 - "Approved" - View all records that have been approved

Button 4 - "Assigned" - View all records that have been assigned to a specialist.

Question 2: I have an Edit icon on in the same gallery. I want users to be able to edit records while in Draft status. Once the status changes to "pending approval, approval and assigned" status, I want to change the visibility of the Edit Icon to off.

Can you help me?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@heycanyouhelpme

You have not mentioned the column that you use for the status. Is it a choice column or text?

I will assume choice for the rest of this response.

In the OnSelect of your buttons, set the formula to: UpdateContext({lclFilter: "All"})

Do the same for the others except change the "All" to the other values.

In your Gallery, use the following formula for the Items property:

Filter(yourDataSource, (Coalesce(lclFilter, "All") = "All") || yourStatusColumn.Value = lclFilter )

For the Icon, set the DisplayMode property to:

If(ThisItem.Status = "Draft", Edit, Disabled )

I hope this is helpful for you.

Was this reply helpful? Yes No
WarrenBelz 156,378 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @heycanyouhelpme ,

Assuming some field names here and also that only 1 button can be selected at a time.

Filter( ListName, Button1.Value || (Button2.Value && Status = "Pending Approval") || (Button3.Value && Status = "Approved") || (Button4.Value && AssignedColumn = "Specialist") )

The Visible of your edit icon would be

ThisItem.Status <> "pending approval && ThisItem.Status <> "approval" && ThisItem.Status <> "assigned"

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
heycanyouhelpme 67 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes Can I apply multiple filters to one button from my choice column using the lcl filter? if so, how?

Was this reply helpful? Yes No
WendeReisss 253 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz @RandyHayes

Very nice explanation in your answers above. I have another question: the formula that you explained above filter the column "Status", for example. It's ok, but is it possible do I include others 3 button to filter the colunm "Type" that has 3 specific types (A, B, C types for example)?

So, a filter that filter Approvals in the colunm "Status", but just to the type A in the colunm "Type". Is it possible to mix button filter?

Was this reply helpful? Yes No