Hi everyone,
Fairly new to Powerapps and have been working on a Project recently. Had some feedback which is great, however what I thought was simple, doesn't seem to work!
I am trying to get the Holiday Start date to descend by date alongside the filter. Any help would be greatly appreciated!
This is the code I have: Filter('Requests', 'Manager Email' = _CurrentUser.Email && (AllData.SelectedText.Value = "All" Or Title= AllData.SelectedText.Value) && Approved = "Approved" &&('Holiday Start Date' >= Today()|| ('Holiday Start Date' > Today() && ('Holiday End Date' >= Today()))))
Solved! Go to Solution.
Hey, have you tried using Sort function?
That would be:
Sort (FILTER FUNCTION GOES HERE, 'Holiday Start Date', Descending)
Here's some more info about it:
https://docs.microsoft.com/en-us/power-apps/maker/canvas-apps/functions/function-sort
SortByColumns(
Filter(
'Requests',
'Manager Email' = _CurrentUser.Email
&&
( AllData.SelectedText.Value = "All"
||
Title= AllData.SelectedText.Value )
&&
Approved = "Approved"
&&
('Holiday Start Date' >= Today()
||
( 'Holiday Start Date' > Today()
&&
'Holiday End Date' >= Today()
)
)
),
'Holiday Start Date',
Descending
)
@iAm_ManCat |
Please 'Mark as Solution' if someone's post answered your question and always 'Thumbs Up' the posts you like or that helped you! |
Thanks! |
Hey, have you tried using Sort function?
That would be:
Sort (FILTER FUNCTION GOES HERE, 'Holiday Start Date', Descending)
Here's some more info about it:
https://docs.microsoft.com/en-us/power-apps/maker/canvas-apps/functions/function-sort
SortByColumns(
Filter(
'Requests',
'Manager Email' = _CurrentUser.Email
&&
( AllData.SelectedText.Value = "All"
||
Title= AllData.SelectedText.Value )
&&
Approved = "Approved"
&&
('Holiday Start Date' >= Today()
||
( 'Holiday Start Date' > Today()
&&
'Holiday End Date' >= Today()
)
)
),
'Holiday Start Date',
Descending
)
@iAm_ManCat |
Please 'Mark as Solution' if someone's post answered your question and always 'Thumbs Up' the posts you like or that helped you! |
Thanks! |