cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Filter or Sort won't work

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.f1.pngf0.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Power Apps
Power Apps

Re: Filter or Sort won't work

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.

View solution in original post

2 REPLIES 2
Highlighted
Power Apps
Power Apps

Re: Filter or Sort won't work

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.

View solution in original post

Highlighted
Helper I
Helper I

Re: Filter or Sort won't work

Thanks

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,093)