Trying to Descend with an already working Filter

[OracleMicky]

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())))) 

[Mattheus · Accepted 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

[iAm_ManCat · Accepted solution]

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
)