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!
Solved! Go to 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
|
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
|