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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Delegation Warning on ...
Power Apps
Answered

Delegation Warning on Date compare to Created date time on SharePoint List via Filter

(1) ShareShare
ReportReport
Posted on by 55
Hi All,
 
I have FROM and TO fields where I use the date picker controls on my page.  I want to use those in my filter to select from a SharePoint list records that have a created date between the FROM and TO date picker fields.  The SharePoint field is the Created date time field.
 
I keep getting this Delegation warning.  I was using the DateValue function to change the SharePoint list field "Created" to just a date so it can be compared to the date picker.  If it is left as a date time any records created for the current date will be greater than than a current date selected in the date picker field on the page.
 
Power Apps Fields:
 
 
Error Message
 
Code on Filter that receives warning
 
(DateValue(Created) >= dteFromDate.SelectedDate && DateValue(Created) <=dteToDate.SelectedDate)
 
SharePoint List delivered field
Categories:
I have the same question (0)
  • Verified answer
    Dunes Profile Picture
    55 on at
    Figured it out..set variables for these fields when they are changed:
     
    Set(varEnd, DateAdd(dteToDate.SelectedDate, 1, TimeUnit.Days) - Time(0, 0, 1))
    Set(varStart, DateAdd(Date(Year(Today()), 1, 1), 0, TimeUnit.Days))
     
     
    Then modified the filter as below:
     (Created >= varStart && Created <=varEnd)
     

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 721 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 320 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard