cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
marney
Helper II
Helper II

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
Dual Super User
Dual 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
Dual Super User
Dual 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 !

Moreshwar
Resolver II
Resolver II

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
Helper II
Helper II

Ah Gentlemen, you are indeed wonderful people!

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

 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,199)