Answered

Datepicker not showing data before a week

(0) 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

I have the same question (0)

All responses (3)

Answers (1)

PowerAddict 7,316 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @pankaj2125 ,

What is your formula to show records based on the date selected in the date picker? Are you sure there is data that should be visible when an older date is selected?

---
If you like this reply, please give kudos (Thumbs Up). And if this solves your problem, please mark this reply as a solution by selecting Accept as Solution. This makes it easier for others to find answers to similar questions.

Thanks!

Hardit Bhatia

Microsoft Business Applications MVP

Microsoft Certified Trainer MCT

Blog | Twitter | LinkedIn | Facebook | YouTube | Email

Was this reply helpful? Yes No
pankaj2125 24 on at

Like (0)

Report
Copy link

Link copied!

This is the formula i am using while doing filter in gallery.

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @pankaj2125 :

This may be caused by time zone issues.The point is that your device and SharePoint Site are not in the same time zone.

There are two solutions:

Solution1:Set your SharePoint time zone to the time zone of your current device

Solution2:Add a date offset to the search criteria

For example:

Created >= DateAdd( DatePicker1.SelectedDate,X,Hours)

&&

Created <DateAdd( DateAdd(DatePicker1.SelectedDate,1,Days),X,Hours)

Best Regards,

Bof

Was this reply helpful? Yes No