Sort Name & Date with search bar and filter

[Anonymous]

Hi

I have a formula which goes like this:

SortByColumns(Filter('Qatar Rail', StartsWith(Name, TextSearchBox1.Text)), "Name", If(SortDescending1, Ascending, Descending))

I am using your basic 3-screen App, and my colleagues will enter their name & Date upon making an entry into the App.

On the front page (BrowseScreen) I have all my entries listed.
I have a search bar and I have a Sort button.

Sort Button formula is:

UpdateContext({SortDescending1: !SortDescending1})

Everything is working fine, however all I need it to do is Sort correctly.
I can get it to sort by name but then it does not sort by date. I have not managed to sort it by date at all.
I would like it to sort according to the Date. However then when a colleague types a Name into the search bar, only the entries with that name must appear, STILL sorted according to date. Latest to earliest.

I have gotten to the point where I will sell my soul to anyone that assists. Please.

Regards
Lorcan

[FelixCuadrilla]

Hello and thank you for reaching to us.

If you want to sort by date only try the following:

SortByColumns(Filter('Qatar Rail', StartsWith(Name, TextSearchBox1.Text)), "Date", If(SortDescending1, Ascending, Descending))

That would sort it by date instead of name.

If you want it to sort by name and then by date, try the following:

SortByColumns(Filter('Qatar Rail', StartsWith(Name, TextSearchBox1.Text)), "Name", If(SortDescending1, Ascending, Descending), "Date", Another_Sort_Order_Variable)

You can add as many sort conditions as you need.

Hope this helps.

[Anonymous]

Hi Felix


Yes that did help a little Thank you so much!

However, it is sorting according to the date and my dates are 'mm/dd/year' format.
Because I am using ios and there are known problems with ios and datepickers I have decided to NOT go along with the datepicker. Instead, I added three drop down menus, Day, Month & Year on the second (EditScreen). They all fall under one card.
So when my colleagues select their Day, Month & Year it immidiately appears in a textbox in the same card on the second (EditScreen).

I have then added another textbox on the FirstScreen (BrowseGallery) with the text property set to my date textbox on the second(EditScreen). In order to display the date on the front as well.

So my problem now is because its sorting according to date, my date is coming from three seperate drop down menues.
Is there a formula I can set for it to sort Year, Month and then Day. But coming from 3 separate drop downs.

Here is my formula for my Date textbox coming from the three dropdowns:
Text(Date(Value(Year.Selected.Value), Value(Month.Selected.Value), Value(Day.Selected.Value)), DateTimeFormat.ShortDate)
(I have tried switching year, month and day around but it does not help)

AND then also If I type a colleagues name into the search bar provided I want ONLY that colleagues meetings to appear but still sorted by Year, Month, and then Day.

(This is an App to record client meetings so my colleagues will open it up and scroll down a list of dates with names of other colleagues and client personel.)

I hope you're able to assist me with this.

Regards
Lorcan