Unanswered

Datepicker not showing data before a week

(1) Share

Report

Posted on by pankaj2125

Hi All,

I am using Datepicker to filter/see data for a particular day. But when i am choosing a date before last monday(6th Dec 2021), its not showing any data.

Source of my app is sharepoint list.

Is there any limitation as such ? Please suggest.

Categories:

Building Power Apps

All responses (11)

Answers (0)

Sort by

Gerard Simpson 2,987 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @pankaj2125 - Can you provide details of the code you have used to filter your data?

Thanks
pankaj2125 24 on at

Like
a
(0)

Report
Copy link

Link copied!

This is the formula i am using while doing filter in gallery.
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @pankaj2125

To find the Start Date for the selected date week is
DateAdd( DatePicker1.SelectedDate, -(Weekday( DatePicker1.SelectedDate, StartOfWeek.MondayZero )), Days )

End date
DateAdd( DatePicker1.SelectedDate, 6 - (Weekday( DatePicker1.SelectedDate, StartOfWeek.MondayZero )), Days )

So your filter could be
Created >= DateAdd( DatePicker1.SelectedDate, -(Weekday( DatePicker1.SelectedDate, StartOfWeek.MondayZero )), Days ), Created < DateAdd( DatePicker1.SelectedDate, 6 - (Weekday( DatePicker1.SelectedDate, StartOfWeek.MondayZero )), Days )

Note: You can change the start of the day and adjust it. In this case, is Monday

Thanks,
Stalin - Learn To Illuminate
pankaj2125 24 on at

Like
a
(0)

Report
Copy link

Link copied!

My requirement is to show one datepicker which will filter rows as per date selected for my DateColumn.
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @pankaj2125

Sorry for the confusion. Your formula is perfect. DateTime is delegable with SharePoint which means no issue with the filter.

Sharepoint data limit based on your app settings. By Default, it pulls only 500 records and we can set a maximum of 2000 records. In your case, no issue when pulling the older data with the date filter.

I assume you have data with the correct date format before Monday.

I tried mine with older days and works fine

Do you have any other filter with this?

Thanks,
Stalin - Learn To Illuminate
pankaj2125 24 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your efforts to find a solution.
Answer to your questions is No, This is my first stage of testing my app.
Maximum limit is set to 2000 but still filtering with datepicker which is not helping me before 6th Dec 2021.
I am able to see every date data on and after 6th Dec 2021. I will check the Date format once more but i am that is also correct.

Please check if you find something. Thanks again.
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @pankaj2125

The created column is the system field and Datetime format. So no issue with field type. To troubleshoot further, can you check whether works with only one filter

Filter( SPList, Created >= DatePicker1.SelectedDate )

Silly thing, Can you remove the connection, re-add it, and try.
pankaj2125 24 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @StalinPonnusamy ,

This was not helpful :).
Filter( SPList, Created >= DatePicker1.SelectedDate )
My data got jumbled and showed wrong combination of rows.
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @pankaj2125

Are we getting any data between 1st Dec and 6th Dec when you select 1st Dec 2021 on the date picker with the below code?

Sort( Filter( IssueTracker, Created >= DatePicker1.SelectedDate ), Created )

We are trying to find the root cause by eliminating the less than date filter.
pankaj2125 24 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @StalinPonnusamy

Found another issue. My created date column in PowerApps is showing different dates when i am comparing it with Sharepoint list date column. How to resolve it ? Defaultdatezone parameter is local currently, if i am right it should pick my EST time automatically.