Answered

FILTER COLLECTION(GALLERY) + 7 DAYS (WHEN THE USER SELECT A DATE)

(0) Share

Report

Posted on by Gorilla_8

Hey

 If(
 drpFilter.Selected.Value = "Data início";
 Filter(
 collTaskListForGallery;
 DateValue(DatadeIníciodaTarefa) = DateAdd(Today();7;Days)
 );

guys, There is possible to filter a gallery by selected a date on "date picker" + 7 days and show the data?

There is my code: (he is not filtering)

Categories:

Building Power Apps

I have the same question (0)

All responses (13)

Answers (1)

Sort by

Pstork1 69,485 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Dates in Power Apps will always include Dates and Times, so using an '=' almost never works. Try either '<=' or '>=' instead depending on whether you are checking for something within 7 days or beyond 7 days.

Was this reply helpful? Yes No
Gorilla_8 on at

Like (0)

Report
Copy link

Link copied!

Hi @Pstork1 , thanks for the reply! Keep the same result, showing nothing on my gallery...

Was this reply helpful? Yes No
Pstork1 69,485 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Did you try both >= and <=? One of them should work unless the filter isn't being applied based on the dropdown.

How big is the list? Filters that involve dates are not delegable.

Are you sure that DatadeIníciodaTarefa is a variable that contains a valid date as text

Does it work if you remove the If() around the outside? Could the check on the dropdown choice be misfiring?

Was this reply helpful? Yes No
Gorilla_8 on at

Like (0)

Report
Copy link

Link copied!
Hi @Pstork1 . Yes, I try both '>=' and '<=' and the '<=' shows all the collection instead of filtering.

Like this:

the code:

If( drpFilter.Selected.Value = "Data início"; Filter( collTaskListForGallery; DateValue(DatadeIníciodaTarefa) <= DateAdd( Today(); 7; Days ) ); collTaskListForGallery )

The result:

How big is the list? Filters that involve dates are not delegable.
This one has 300 items, but gonna be more than 3000 sometimes...

Are you sure that DatadeIníciodaTarefa is a variable that contains a valid date as text
Yes, its valid text, I test putting a label on my gallery to show the date, and there is a date

Does it work if you remove the If() around the outside? Could the check on the dropdown choice be misfiring?
No, he shows all the same way

See on this code:

Filter( collTaskListForGallery; DateValue(DatadeIníciodaTarefa) <= DateAdd( Today(); 7; Days ) )

The result:
The label I mentioned: "27/03/2020" and the result is showing all the gallery.

Was this reply helpful? Yes No
Gorilla_8 on at

Like (0)

Report
Copy link

Link copied!

Sorry for my last answer ... See the error...

It's not filtering...

Was this reply helpful? Yes No
Verified answer

Pstork1 69,485 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

First, if you expect the data source to grow larger than 500-2,000 records then filtering by date won't ever work since it is non-delegable. So it may be a waste of time and you'll need to look for a different solution.

But it looks like the filter is working as expected when using <=. It shows all the records because all the dates are less than 7 days out. If you want to filter the records then the filter needs to be a comparison of some field in the record with the date or date +7 days. If you do the comparison to a value you type in its always going to be either true or false for all the records. If you want to filter the records where the date in the record is less than or greater than 7 days of the date you type in then use that date, not Today.

Was this reply helpful? Yes No
Gorilla_8 on at

Like (0)

Report
Copy link

Link copied!

Hi @Pstork1 , yes the filter by '<=' is filtering, correct, thanks for the help.

But my necessity is when the user selects a date + 7 days to show the records...

Its gonna be the same?

Was this reply helpful? Yes No
Gorilla_8 on at

Like (0)

Report
Copy link

Link copied!
Like this I mean:

Filter( collTaskListForGallery; DatePicker1.SelectedDate >= DateAdd( Today(); 7; Days ) )

Was this reply helpful? Yes No
Pstork1 69,485 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

But that formula doesn't compare against anything on the record itself, so it will always be either true or false for every record. To filter you need to compare the date to a date that is specific to each record.

Was this reply helpful? Yes No
Gorilla_8 on at

Like (0)

Report
Copy link

Link copied!
Hi @Pstork1 , yes, I try to filter by another way and work it, but I need to filter by "today" + 7 days like this code:

Filter( collTaskListForGallery; DatePicker1.SelectedDate >= DateAdd(DateValue(DatadeIníciodaTarefa);7;Days) ); collTaskListForGallery );

And you help me a lot to solve this problem, if you wanna I make a new post here:
https://powerusers.microsoft.com/t5/Building-Power-Apps/FILTER-A-GALLERY-TODAY-7-DAYS/m-p/512296

Thanks for your time and explaining @Pstork1

Was this reply helpful? Yes No