Hi I already have a function with search and filtering that works, but im trying to add a SortByColumns on top of it
this is whats already working:
Filter(DenmarkUAI, StartsWith('Customer name', SearchDK.Text)
&& (CBProdInvDK.Selected.Value in 'Products involved'.Value || CBProdInvDK.Selected.Value = Blank())
&& (CBReasonUAIDK.Selected.Value in 'Reason for UAI'.Value || CBReasonUAIDK.Selected.Value = Blank())
&& (CBStatusDK.Selected.Value in 'Investigation Status'.Value || CBStatusDK.Selected.Value = Blank()))
And this is what im trying to add on top of it
SortByColumns(Filter(DenmarkUAI, StartsWith('Customer name', SearchDK.Text)
&& (CBProdInvDK.Selected.Value in 'Products involved'.Value || CBProdInvDK.Selected.Value = Blank())
&& (CBReasonUAIDK.Selected.Value in 'Reason for UAI'.Value || CBReasonUAIDK.Selected.Value = Blank())
&& (CBStatusDK.Selected.Value in 'Investigation Status'.Value || CBStatusDK.Selected.Value = Blank())),
"InvestigationStatus", Descending)
So im trying to sort the column 'Investigation Status' with Descending order. thanks
