Another Filter question :)

[marney]

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!

[gabibalaban · Accepted solution]

@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]

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)

[gabibalaban]

@Moreshwar ,

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

[marney]

Ah Gentlemen, you are indeed wonderful people!

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