cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
marney
Frequent Visitor

Another Filter question :)

Hello All!

I've trawled the forums trying to work this out but no luck so far.

Basically, I have a gallery connected to a SP List and there is a Choice column with 3 choices.

All I'm looking to achieve is that the gallery only shows 2 out of 3 of those choices; the choices are "Approved for Payment", "Pending Approval" and "Request Rejected".

If an item has Status of "Approved for Payment", it should not be shown in the Gallery.

I have this for my Items and am using varUser so that it only shows items based on the logged in user (which works fine):

Sort(Filter(' Request to pay Supplier with Credit Card',ApproverEmail=varUser.Email),Created,Ascending)

 

Please could someone help with this Filter so that it only shows items with "Pending Approval" and "Request Rejected".

 

Thank you!

 

1 ACCEPTED SOLUTION

Accepted Solutions
gabibalaban
Super User
Super User

@marney ,

 

Sort(
   Filter(' Request to pay Supplier with Credit Card',
           ApproverEmail=varUser.Email,
           ChoiceColumn.Value="Pending Approval" || ChoiceColumn.Value="Request Rejected"),
   Created,
   Ascending
)

 

where ChoiceColumn is your column.

 

Hope it helps !

View solution in original post

4 REPLIES 4
gabibalaban
Super User
Super User

@marney ,

 

Sort(
   Filter(' Request to pay Supplier with Credit Card',
           ApproverEmail=varUser.Email,
           ChoiceColumn.Value="Pending Approval" || ChoiceColumn.Value="Request Rejected"),
   Created,
   Ascending
)

 

where ChoiceColumn is your column.

 

Hope it helps !

View solution in original post

Moreshwar
Resolver I
Resolver I

Hello,

Just edit your Items property to include filter && condition for the other column too. Something like:

Sort(Filter(' Request to pay Supplier with Credit Card',ApproverEmail=varUser.Email && 'Choice Column'.Value != 'Approved for Payment'),Created,Ascending)

@Moreshwar ,

Please be aware that ! operator is not delegable in Sharepoint.

marney
Frequent Visitor

Ah Gentlemen, you are indeed wonderful people!

It was the repeat of ChoiceColumn.Value="" that I was missing...indebted to you!!

 

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,890)