cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
aadilg
Level: Powered On

Multiple filter on gallery with blank value

Hi everyone, 

Was hoping someone could assist with a formula issue. I have a gallery that is being filtered at the moment except I need to add another filter for a column that has blank value. i only need data where processquote2="2" and team2<>"" (Where process quote 2 is equal to "2" and team2 is not equal to "<blank>".

 

This is what I have at the moment, but it doesnt seem to work:

1. Sort(Filter('Request For Quote',ProcessQuote2="1",Team2<>""),Title, Descending) - Doesnt work at all

2. Sort(Filter('Request For Quote',(IsBlank(Team2)&&ProcessQuote2="1")),Title, Descending)  - Works the opposite way, brings them in team2 is blank whereas needs to be hidden

 

Sort of a IsNotBlank option i guess.

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

Re: Multiple filter on gallery with blank value

Hi @aadilg

 

You can add ! to make it NOT

 

So if your 2 option works just add ! in front of IsBlank:

 

Sort(
  Filter(
    'Request For Quote',
    (!IsBlank(Team2)&&ProcessQuote2="1")
  ),
Title,
Descending
)

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Re: Multiple filter on gallery with blank value

Hi @aadilg

 

You can add ! to make it NOT

 

So if your 2 option works just add ! in front of IsBlank:

 

Sort(
  Filter(
    'Request For Quote',
    (!IsBlank(Team2)&&ProcessQuote2="1")
  ),
Title,
Descending
)

View solution in original post

aadilg
Level: Powered On

Re: Multiple filter on gallery with blank value

Thank you buddy, that worked!

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (4,533)