Filter the gallery by the latest date, or by DatePicker

(0) Share

Report

Posted on by Livearus

126

Hello everybody,

can someone tell me what I am doing wrong with the following example?

If(
 DatePicker3.SelectedDate >= 1;
 Sort(
 Filter(
 'Reports';
 DatePicker3.SelectedDate = 'ReportTime'
 ); 
 Descending
 );
 'Reports'
)

There is a SharePoint list with a "ReportTime" column. New reports are created every day so that the bottom entry in the SharePoint list is the most current.

In Power Apps I want to query the SharePoint list and filter the returned result by the latest date.

So far it looks like the entries are being displayed to me, but the filtering doesn't really work. In the gallery, the oldest entry is at the top, as well as from SharePoint.

As if that wasn't enough. There is a DatePicker in the APP. If the user selects a specific date, only the reports with the selected date should be queried or, if no date is selected, then preferably only the last 30 entries from the list (filtered according to the latest "ReportTime").

It works, but unfortunately without filtering.

regards

Livearus

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Livearus date picker returns something of type Date Value. Do you cannot compare it with a number. You have to compare it with another DateValue like,
If(date picker. SelectedDate=Today()....

Was this reply helpful? Yes No
Livearus 126 on at

Like
a
(0)

Report
Copy link

Link copied!
Okay, I think the following features are needed to achieve my goal. But how is the query compared. I have to admit that I have a bit of a problem with the "IF condition", which will probably apply here.

LastN(Reports;30) Filter(Reports;DatePicker3.SelectedDate = 'ReportTime') Sort(Reports;'ReportTime';Descending)

First, if the DatePicker3 is not selected, the "Sort" function is executed. The reports are loaded in the desired order.

But only the last 30 may be displayed, instead the "LastN" function.

But if DatePicker3 is selected, the "Fiter" function is carried out.

Can you help me with this?

The functions on their own already lead to the desired result, just not in combination with one another.

regards
Livearus

Was this reply helpful? Yes No
Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Livearus Try this,
If(IsBlank(DatePicker3.SelectedDate), Sort(LastN(Reports;30);'ReportTime';Descending), Filter(Reports;DatePicker3.SelectedDate = 'ReportTime') )

Was this reply helpful? Yes No
Livearus 126 on at

Like
a
(0)

Report
Copy link

Link copied!
Hey

sorry about the late reply. Except for one small thing, your suggested solution was correct. Before the "isBlank" function a "!" Had to be added. Guess to check whether the return value is "not empty" instead of checking that it is "empty"?

If(!IsBlank(DatePicker3.SelectedDate), Sort(LastN(Reports;30);'ReportTime';Descending), Filter(Reports;DatePicker3.SelectedDate = 'ReportTime') )

regards
Livearus

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Livearus Glad you got it right!

Was this reply helpful? Yes No
Livearus 126 on at

Like
a
(0)

Report
Copy link

Link copied!

Hmm

I guess I wasn't right after all. "Kneeling and Confusion". I should have tested whether everything works even after selecting a date. Unfortunately not.

The "!" then, contrary to my assumption, does not have the logic to check whether "not empty" instead of "empty". Rather, it simply removes the function of "IsBlank".

Do you or anyone else have another approach to the problem?

regards
Livearus

Was this reply helpful? Yes No