Filter or Sort won't work

[arigl]

I use a 4 column Sharepoint list h0_1, in which a user can input data. Patch operation (1st  screen) works fine, however sort function won't work. This is a very small list (<<500).

ClearCollect(Aent, {Date:DatePicker2.SelectedDate,Title:TextInput1.Text, Ar:Value(1),Dep:Value(1)});TextInput1.Text=Text("Date");
Patch(h0_1,Defaults(h0_1),Last(Aent));
SortByColumns(h0_1,"Date")

In Screen2 I  use a Gallery. I want to filter its data by seleced date from DatePicker1.

Filter(h0_1, Text(Label1.Text)=Text(DatePicker1.SelectedDate,"[$-en-US]dd-mm-yyyy" ))

This does not work.

[CarlosFigueira · Accepted solution]

The Filter and SortByColumns functions do not change the collection/list to which they are applied. Instead, they return a new table that is filtered / sorted based on the arguments instead.

You should update the Items property of your gallery to use the Filter / Sort functions there. For example, in the Gallery1, on Screen2, you can have this expression for the Items property:

Filter(h0_1, Label1.Text = Text(DatePicker1.SelectedDate,"[$-en-US]dd-mm-yyyy" ))

Likewise for the sort operation - you use that function in the place where you want the data sorted.

[arigl]

Thanks