Sort gallery by custom column with filter

(0) Share

Report

Posted on by sudosaurus

1,599 Super User 2024 Season 1

Hello,

I am using this filter for my gallery however I wish to sort this Descending with the newest items at the top.

Filter(Register,
 (IsBlank(Search_textinput.Text) || Search_textinput.Text in 'Contract Ref' & 'External Party' & 'Contract Name' & 'Contract Description' & 'Contract tracking details' & 'Contract tracking date' & 'Contract Category'.Value
 ) &&
 (Directorate_dd.Selected.Result = "Directorate" || Directorate.Value = Directorate_dd.Selected.Result) &&
 (ContractStatus_dd.Selected.Result = "Contract Status" || 'Contract Status'.Value = ContractStatus_dd.Selected.Result
 ) &&
 (ContractCategory_dd.Selected.Result="Category" || 'Contract Category'.Value = ContractCategory_dd.Selected.Result)
) 


SortByColumns([DataSource], "Contract Ref", If(SortDescending1, Descending, Ascending))

I am figuring out how to sort this by the column 'Contract Ref' (Descending).

Thanks,

Chris

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

KvB1 1,596 on at

Like
a
(0)

Report
Copy link

Link copied!

Your Filter function should be inside the SortByColumns function, eg the filtered datasource is the datasource for your Sort function.
Verified answer

sudosaurus 1,599 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
I managed to sort (no pun intended :D) it this way...

Sort( Filter(Register, (IsBlank(Search_textinput.Text) || Search_textinput.Text in 'Contract Ref' & 'External Party' & 'Contract Name' & 'Contract Description' & 'Contract tracking details' & 'Contract tracking date' & 'Contract Category'.Value ) && (Directorate_dd.Selected.Result = "Directorate" || Directorate.Value = Directorate_dd.Selected.Result) && (ContractStatus_dd.Selected.Result = "Contract Status" || 'Contract Status'.Value = ContractStatus_dd.Selected.Result ) && (ContractCategory_dd.Selected.Result="Category" || 'Contract Category'.Value = ContractCategory_dd.Selected.Result) ), ID, Descending )