Unanswered

Filtering with choice column powerapps gallery

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi guys,

Below is a photo of my powerapp. i'm trying to be able to filter so that when pressed, the gallery will only show items that have the choice "approved" or "Pending" when the appropriate button is pressed.

my button currently has this code:

UpdateContext({FilterByApproved:!FilterByApproved})

and my gallery currently has this code:

SortByColumns(
 Filter(
 'Expense List',
 (If(FilterByApproved = true, Text(Approval.Value) = "Approved", Approval.Value <> "") || (Approval.Value = "Pending" Or Approval.Value = "Approved" Or Approval.Value = "Rejected")) && Text(Submitter) = User().FullName
 ),
 "Date",
 If(SortDescending, SortOrder.Descending, SortOrder.Ascending)
)

I've also in the approved button above tried the following code but to no avail:

ClearCollect(
 FilteredItems,
 Filter(
 'Expense List',
 (
 Approval.Value = "Approved" 
 )
 ))

Note: Id want to do this for all buttons i.e. not just approved but also pending and all. The choice column in SP is named 'Approval'

Let me know if you can help!

Thanks,
Cormac

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

developerAJ 4,763 on at

Like
a
(1)

Report
Copy link

Link copied!
on button select you can use UpdateContext({btnFilterSelection:"Approved"}) ; UpdateContext({btnFilterSelection:"Pending"});UpdateContext({btnFilterSelection:"All"})

SortByColumns( Filter( 'Expense List', IsBlank(btnFilterSelection)|| btnFilterSelection="All" || If(btnFilterSelection="Pending",Approved.Value="Pending",Approved.Value="Approved") ,Text(Submitter) = User().FullName ), "Date", If(SortDescending, SortOrder.Descending, SortOrder.Ascending) )

Please click Accept as solution and Thumbs Up. 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.
You can connect with me on LinkedIn
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

hi @developerAJ ,

I've added the code into the gallery and put the update context in one of the buttons eg. pending button code is UpdateContext({btnFilterSelection:"Pending"}) however the gallery comes out empty. do you know what causes this?