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)

[TheRobRush]

Wrap your filter in a sort, and where it says to put ascending or descending put aomething like sortdirVar then make your icon onSelect 

Switch(

sortdirVar,

"Ascending", Set(sortdirVar, "Descending"),

Set(sortdirVar,"Ascending"))

On my cell so it might have some syntax or typing errors but you should be able to figure it out i think

[TheRobRush]

Sort portion will.be

Sort(

Your current filter code,

Column name to sort by,

sortdirVar)

[Phineas]

This is what I have; Power Apps doesn't like it.

Sort(Filter(StartsWith(HDProofOfConceptList, MainTopic = TextInput1.Text),MainTopic,sortdirVar)

I'd like the user to be able to user the any words typed into the search box or the date ranger date pickers.

[TheRobRush]

What Error are you getting, and did you set the onselect that switches sortdirVar? in onvisible for that page you will also need to set initial value of sortdirVar

[Phineas]

This work to search by the text search box.

Filter( HDProofOfConceptList, StartsWith( MainTopic, TextInput1.Text) )

This works to search by data range of Date Pickers.

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

I've got this in the sort icon for the Gallery.

Switch(sortdirVar,"Ascending",
Set(sortdirVar, "Descending"),
Set(sortdirVar,"Ascending"))

How do update the formula to default to all List items and then allow for the user to either filter the existing data by the search textinput, date pickers, and sort either A-Z/Z-A with the sort icon?

[TheRobRush]

I will type this out for you tomorrow if noone beats me to it, but on my cellphone right now and rest of that you added is a bit too much to just type out without testing it first

[TheRobRush · Accepted solution]

Ok here we go, it is all done on my own example, but just switch in what doesn't match your column names source names etc because it is all working as intended.

Start with placing in the OnVisible of page with your gallery

Set(sortdirVar,"Ascending")

I have a text input box with default left blank

I then have my two DatePicker Controls, nothing special about them.

Nearby those I place a checkbox and just call it whatever you want, in my images i have it include a label that says Date Range. Checking this box will filter the gallery based on a date range, not checking it will filter your gallery only if you type in the text input box. checking it will filter the gallery on date range AND text input

Our gallery items, again for my specific source you will need to tweak, are as follows

If(Checkbox10,
Sort(
    Search(
    Filter(
        datesArray,
        Date>DateAdd(DatePicker9.SelectedDate,-1,Days) 
        && 
        Date<DateAdd(DatePicker10.SelectedDate,1,Days)
        ), 
        TextInput8.Text,
        "Day Name"),Date,sortdirVar),
Sort(
    Search(datesArray, TextInput8.Text,"Day Name"),Date,sortdirVar)
    )

Near this gallery I have a sorting Icon and its onselect is

Switch(

sortdirVar,

"Ascending", Set(sortdirVar, "Descending"),

Set(sortdirVar,"Ascending"))

Below are pictures to demonstrate it working

No Date Range Selected (Unchecked box), And No Text Limiter AddedDate Range Selected, But No Text LimiterDate Range Selected, No Text Limiter, Sort Direction ReversedBoth a Date Range, And A Text Limiter Have Been Selected

[Phineas]

Added all as and where instructed.

I got the following errors in the Gallery Items formula.

     The function 'Search' has some invalid arguments.
     The function 'Sort' has some invalid arguments.
     The function 'Filter' has some invalid arguments.
     Name isn't valid. This identifier isn't recognized.
     The specified column 'Topic' doesn't exist. - There is a SPList column titled 'Topic'.

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

[TheRobRush]

Change Topic to MainTopic and see if it helps, otherwise maybe remove the list from your data sources, then readd it. might just be glitching on you