Filter Not Hiding Dates Correctly

[Applications]

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!

[AhmedSalih · Accepted solution]

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