Hello Powerapps Experts,
Good day!
I would like to seek your help regarding sortbycolumns. So I used my Code below.
SortByColumns(
Filter(
colRPNViewItems,
Team = Cmb_Team.Selected.Result || Cmb_Team.Selected.Result = Blank(),
Originator = Cmb_Originator.Selected.Result || Cmb_Originator.Selected.Result = Blank(),
IncidentType = Cmb_AlertType.Selected.IncidentType || IsBlank(Cmb_AlertType),
(DateValue(NewIncidentDate) >= DatePicker_StartDate.SelectedDate && DateValue(NewIncidentDate) <= DatePicker_EndDate.SelectedDate),
IncidentModule in multiselectModule.Result || IsBlank(Cmb_Module),
PrimaryDropDown = Cmb_PrimaryCause.Selected.Result || IsBlank(Cmb_PrimaryCause),
Brand in multiselectBrand.Result || IsBlank(Cmb_Brand),
(PlantID = Dd_Plantid_2.Selected.PlantID || IsBlank(Dd_Plantid_2.Selected.PlantID)),
IncidentModule in multiselectModule.Result || IsBlank(Cmb_Module)
),
"DateEntered",
If(
locSortAscending,
Ascending,
Descending
)
)
But the result order is not in proper order. Instead it was sorting by ID column rather than DateEntered.
How to solve this issue? Thanks in advance for your help.
