Unanswered

adding a sort by to a gallery with search and filter

(0) Share

Report

Posted on by ScablandsKing

201

I would like to add a couple sort by columns for a name column and a date column but am struggling with where to insert it. This is the items property of my gallery and is working at the moment. Before or after filter then where to add my fields in this. Any help is appreciated!

Filter(
 Search(
 Search(
 Search(
 AddColumns(
 'NDT Cert Tracker',
 DisplayName,
 Name.DisplayName,
 ExaminerDisplayName,
 Examiner.DisplayName,
 SupervisorDisplayName,
 Supervisor.DisplayName
 ),
 txtName.Text,
 DisplayName
 ),
 txtExaminer.Text,
 ExaminerDisplayName
 ),
 txtSupervisor.Text,
 SupervisorDisplayName
 ),
 (cbxMethod.Selected.Value = Method.Value || IsBlank(cbxMethod.Selected.Value)),
 (cbxLevel.Selected.Value = Level.Value || IsBlank(cbxLevel.Selected.Value)),
 (cbxLocation.Selected.Value = Location.Value || IsBlank(cbxLocation.Selected.Value))
)

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

kelseytran 292 on at

Like (1)

Report
Hi @ScablandsKing ,
The exact formula will change depending on what you want to sort by, but lets say for example you have a 'SortBy' dropdown ('ddSortBy') with values like name and date, and a toggle for ascending/descending order ('tglSortOrder'):
SortByColumns( Filter( Search( Search( Search( AddColumns( 'NDT Cert Tracker', "DisplayName", Name.DisplayName, "ExaminerDisplayName", Examiner.DisplayName, "SupervisorDisplayName", Supervisor.DisplayName ), txtName.Text, "DisplayName" ), txtExaminer.Text, "ExaminerDisplayName" ), txtSupervisor.Text, "SupervisorDisplayName" ), (cbxMethod.Selected.Value = Method.Value || IsBlank(cbxMethod.Selected.Value)) && (cbxLevel.Selected.Value = Level.Value || IsBlank(cbxLevel.Selected.Value)) && (cbxLocation.Selected.Value = Location.Value || IsBlank(cbxLocation.Selected.Value)) ), If(ddSortBy.Selected.Value = "Name", "DisplayName", If(ddSortBy.Selected.Value = "Date", "DateColumn", "DisplayName")), If(tglSortOrder.Value, SortOrder.Ascending, SortOrder.Descending) )
------------------------------------------------------------------------------------------------------------------------------
If I answered your question, please accept my post as a solution and if you liked my response, please give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
ScablandsKing 201 on at

Like (0)

Report

@kelseytran Thanks! Super helpful!

Was this reply helpful? Yes No