cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jbrines
Post Prodigy
Post Prodigy

Help with two Filters

Hi All,

 

I have the following filter on a Gallery

Filter(Vistors,'Sign In Date and Time '>= Today())

 

I want to add another filter where it will also show only blank entries in the "Sign Out Date and Time " list column "Visitors"

 

Thanks

 

John.

1 ACCEPTED SOLUTION

Accepted Solutions
C-Papa
Super User
Super User

try using the below to avoid delegation

 

Filter(Vistors,'Sign In Date and Time'>= Today() && 'Sign Out Date and Time' = Blank())

View solution in original post

8 REPLIES 8
CNT
Super User
Super User

@jbrines Try this,

Filter(Vistors, IsBlank('Sign In Date and Time'))

Thanks but I want to keep the Sign Date and time as it is and add another filter for Sign Out.

C-Papa
Super User
Super User

Hi, i would add a button somewhere and change the OnSelect to: Set(var_show_Blanks,!var_show_Blanks)

 

Then for your gallery / collection items:

If(var_show_Blanks,
Filter(Vistors,IsBlank('Sign Out Date and Time ')),
Filter(Vistors,'Sign In Date and Time '>= Today()))

@jbrines Then try this,

Filter(Vistors,'Sign In Date and Time'>= Today() && IsBlank('Sign Out Date and Time'))
)

I get a delegation error with this formula.

@CNT I get a delegation error with that formula.

C-Papa
Super User
Super User

try using the below to avoid delegation

 

Filter(Vistors,'Sign In Date and Time'>= Today() && 'Sign Out Date and Time' = Blank())

@C-Papa  Many thanks.

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.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

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 (5,231)