Answered

Created Column Sharepoint

(0) Share

Report

Posted on by PCesarRT26

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

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

DJ_Jamba 2,837 Moderator on at

Like (0)

Report
Copy link

Link copied!
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:00

So 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 ) ) )

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No