cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Applications
Helper IV
Helper IV

Filter Not Hiding Dates Correctly

Hello all,

 

My filter isn't hiding dates correctly - I'm trying to get it to hide items in the past. Where am I going wrong?

 

SortByColumns(
Filter('Visit Requests',
'Approval Status'.Value = "Approved Internal and External" ||
'Approval Status'.Value = "Approved Internal Only" && 'Visit Start Date'>=Today()
),
"Visit_x0020_Start_x0020_Date", Ascending)

 

With this it's still showing past events. Thoughts on what to change? Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
AhmedSalih
Super User
Super User

Hello, @Applications  try this:

SortByColumns(
Filter('Visit Requests',
('Approval Status'.Value = "Approved Internal and External" ||
'Approval Status'.Value = "Approved Internal Only") && 'Visit Start Date'>=Today()
),
"Visit_x0020_Start_x0020_Date", Ascending)

 Just added brackets for the OR conditions.

 

 

 

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.


I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.


Visit my Blog: www.powerplatformplace.com


 

 

View solution in original post

1 REPLY 1
AhmedSalih
Super User
Super User

Hello, @Applications  try this:

SortByColumns(
Filter('Visit Requests',
('Approval Status'.Value = "Approved Internal and External" ||
'Approval Status'.Value = "Approved Internal Only") && 'Visit Start Date'>=Today()
),
"Visit_x0020_Start_x0020_Date", Ascending)

 Just added brackets for the OR conditions.

 

 

 

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.


I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.


Visit my Blog: www.powerplatformplace.com


 

 

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