web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Missing records when f...
Power Apps
Unanswered

Missing records when filtered using DateTime Columns in SharePoint

(0) ShareShare
ReportReport
Posted on by 1,113

My Gallery is connected to SharePoint list and am filtering my gallery using 2 date picker controls. I am using Created column of SharePoint list to match the range of 2 date picker controls. Here is my gallery items formula.

Filter(
 'Safety Audit Without Manifold Form',
 Created >= datFrom.SelectedDate && Created <= datTo.SelectedDate
)

The problem is for example, when I have a record created at 13-08-2021 10:30 PM and when my date filters are 12-08-2021 to 13-08-2021, this particular record is missing in the gallery. I observed the date picker is defaulting to 12AM when I compare it with date time column. As my record is  created at 10:30 PM which is post 12 AM, it is missing in my gallery. So I changed my formula to below to only compare dates but it is resulting in delegation issues. My future list is going to have more than 2000 records and do want to see any delegation warnings. How can I filter my gallery with only dates in datetime columns without delegation warnings. Please help.

Filter(
 'Safety Audit Without Manifold Form',
 Created >= datFrom.SelectedDate && Date(
 Year(Created),
 Month(Created),
 Day(Created)
 ) <= Date(
 Year(datTo.SelectedDate),
 Month(datTo.SelectedDate),
 Day(datTo.SelectedDate)
 )
)

 

Categories:
I have the same question (0)
  • Verified answer
    rameshmukka Profile Picture
    1,113 on at
    Re: Missing records when filtered using DateTime Columns in SharePoint

    Figured out. Changed my filter to below and it worked.

    datFrom.SelectedDate && Created <= (datTo.SelectedDate + Time(23, 59, 59))

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 757 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 322 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 209 Super User 2025 Season 2

Last 30 days Overall leaderboard