Filtering by Sharepoint Created Date Not Working in One App but Does Another

(0) Share

Report

Posted on by bcanale

App 1 (works properly)

App 2 (comes back with 0):

Note the data source (Sockets, Sockets_1) in the app is the same SharePoint list and the date pickers are pointing to the correct and identically configured fields). In the app where it is not working similar counts are being done on other SharePoint lists with created fields.

Have tried using CountIf (shown above), as well as Countrows(Filter(... with the same results. Attempting to filter a gallery using the Sharepoint "created" column also does not work as expected.

Any suggestions would be greatly appreciated.

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

WarrenBelz 156,748 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @bcanale ,

Technically it should work as Created is a Date/Time field and DateValue() should convert it - try this and you can also get rid of the Delegation warning (it only hides it though)

With( { _Data: Filter( AddColumns( Sockets, "CreateDate", DateValue(Created) ), CreateDate = DatePicker1.SelectedDate ) }, CountRows(_Data) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
bcanale 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks a lot for the reply! Unfortunately, that also is not working and results in 0 when it should have records to count..
WarrenBelz 156,748 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@bcanale ,

OK - getting a bit more specific

With( { _Data: Filter( AddColumns( Sockets, "CreateDate", DateValue( Text(Created, "mm/dd/yyyy") ) ), CreateDate = DatePicker1.SelectedDate ) }, CountRows(_Data) )

Also I just ran it here on the text list and received the expected result

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
bcanale 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks so much for all your help. I found the issue and felt a little silly. I hadn't adjusted therow limit from the default 500 and all dates I was testing with were after tyhe 500th record.