Manually Program Ascending / Descending Icon Search on Gallery

[Phineas]

I have a Gallery that I'd like to filter and sort.

I'd like to be able to filter based on StartDatePicker and EndDatePicker (I've got that working).

I'd also like to use the sort icon to switch the Gallery view from A - Z to Z - A based on the 'Main Topic' in the Gallery.

I currently have the following in the Items property of the Gallery.

Filter(HDProofOfConceptList, DateOfRequest>=SupportRequestStartDatePicker.SelectedDate && DateOfRequest<=SupportRequestEndDatePicker.SelectedDate)

[Phineas]

(Edited Section: I did delete and reload the data source)

Tried that name switch while I was awaiting your response; it delivered the same set of errors.

     The function 'Search' has some invalid arguments.
     The function 'Sort' has some invalid arguments.
     The function 'Filter' has some invalid arguments.
     The specified column 'Topic' doesn't exist. - There is a SPList column titled 'Topic'.

Where in the formula does it reference the SPList?

If(ExistingRequestFilterbyDateRangeCheckbox,
Sort(
Search(
Filter(
datesArray,
Date>DateAdd(ExistingRequestStartDatePicker.SelectedDate,-1,Days)
&&
Date<DateAdd(ExistingRequestEndDatePicker.SelectedDate,1,Days)
),
ExistingRequestsSearchFld.Text,
"MainTopic"),Date,sortdirVar),
Sort(
Search(datesArray, ExistingRequestsSearchFld.Text, "MainTopic"),Date,sortdirVar)
)

[TheRobRush]

oooooo haha Ok I see, you didnt change

Filter(
datesArray,

Search(datesArray

datesArray is my collection I was using, change it to your collection

[Phineas]

Getting there.

Topic is now accepted.

I am using an SPList and not a collection; I know that can required different formula configurations sometimes.

Two errors remaining. PA still doesn't like the 'sort', and now is flying a delegation warning on the bottom search command.
     The function 'Sort' has some invalid arguments.

     Delegation warning. The "Search" part of this formula might not work correctly on large data sets.

[TheRobRush]

The Date in sort needs to be changed to column name of your date.

Delegation warning is normal and will only be seen in the editor not by regular users. Just don't let the number of items in your splist go over the max of 2000 that powerapps can pull

[Phineas · Accepted solution]

Got it!

Had to update the fields referenced in the list 'Date' had to be changed to 'DateofRequest', and so on.

What are your thoughts on the delegation error issue? Should I use a collection instead?

[TheRobRush · Accepted solution]

FIrst Line: If you won't ever have over 2,000 items then don't worry about it.

Second Line: Program a flow that checks for old non relevant records every night and moves them to an identical, archived list then removes it from active list to keep splist nice and organized.

Third Line If you will definitely have over 2k items and cannot do housekeeping to keep them organized on smaller  active lists: Super Warren Scroll down to over 2k items, and make a collection to work from. It is much more tidy and fast performance wise to not have to do this though

[TheRobRush]

Make sure to mark the main post with all the formulas as part of solution so that people searching for same issue can find the answer quickly as well