Announcements
I a creating a powerapp that uses a Sharepoint list as Datasource in the poweapp i have a gallery with some of the columns as the fields one of them being the SharePoint Created column. i am trying to Filter only items that where created Today() but am having issues with the Created field. I am using this formula but it is not working Filter('Data Source',Created = Today()) looking at how the created field is showing information its including the Time an item was created wich is why i think im having issues, i have tried converting Created field to text in powerapps but then i get delegation issues i have also tried switching Created column in sharepoint to Friendly but no success. below is the Created Field text box that uses Thisitem.Created and below that is a Text Box that uses Today().
Hi @PCesarRT26 The Created column in SharePoint is a Date/Time column dd/mm/yyy hh:mm:ss where as Today() = dd/mm/yyyy 00:00:00So comparing to Today() means find records that were created at midnight today.Instead use this:
Filter( 'Data Source', And( Created >= Today(), Created < Today() + 1 ) )
Or if you get a delegation warning use this:
With( { _today: Today(), _tomorrow: Today() + 1 }, Filter( 'Data Source', And( Created >= _today, Created < _tomorrow ) ) )
Hi @PCesarRT26,
Here is the thing, to compare the created date with today, which does cause delegation issue.
Filter(SampleList,Text(Created,DateTimeFormat.ShortDate) = Text(Today(),DateTimeFormat.ShortDate))
For now, it could not be solved even though the With() function, which is used to avoid the delegation warning message, not to solve the delegation issue.
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 549 Most Valuable Professional
Kalathiya 225 Super User 2026 Season 1
Haque 224