Share
Report
195Hello 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.
Categories:
All responses (
Answers (
