Hello, all -
I'm having some difficulty getting a gallery to sort in the specified order - PowerApps for Teams & Dataverse for Teams.
Here's some code that works:
Sort(
Filter(
Caseloads,
clPatient.ptCampus = intCampus &&
clDiscipline = intDiscipline &&
Status = 'Status (Caseloads)'.Active &&
Or(
clTherapist.Therapist = guidFilterTherapists,
IsBlank(guidFilterTherapists)
) &&
Or(
clStudent.Therapist = guidFilterStudents,
IsBlank(guidFilterStudents)
) &&
Or(
clPatient.ptWard = strFilterWard,
IsBlank(strFilterWard)
) &&
Or(
clPatient.ptService = strFilterService,
IsBlank(strFilterService)
) &&
Or(
!blnFilterPickup,
clPickup = 1
)
),
clPtName,
SortOrder.Descending
)
However, if I use a WITH statement, it does not work - it does not error, it just doesn't sort descending:
With(
{
recTest:
Filter(
Caseloads,
clPatient.ptCampus = intCampus &&
clDiscipline = intDiscipline &&
Status = 'Status (Caseloads)'.Active &&
Or(
clTherapist.Therapist = guidFilterTherapists,
IsBlank(guidFilterTherapists)
) &&
Or(
clStudent.Therapist = guidFilterStudents,
IsBlank(guidFilterStudents)
) &&
Or(
clPatient.ptWard = strFilterWard,
IsBlank(strFilterWard)
) &&
Or(
clPatient.ptService = strFilterService,
IsBlank(strFilterService)
) &&
Or(
!blnFilterPickup,
clPickup = 1
)
)
},
Sort(recTest, clPtName, SortOrder.Descending)
)
Do you have any thoughts? (Also, I've read other questions where people have said that you don't need to use SortOrder.Descending, you can just use Descending, but I get an error if I try this.)
