Power Platform Community Forum Thread Details

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:

General Questions

Using Apps Using Formulas

Connecting to Data