Showing results for 
Search instead for 
Did you mean: 
New Member

Date Range Filtering Issue

Hi Team

I have the bellow filtering on my Gallery. All Filters are working fine with no error but when i choose filtering date range is not showing anything.. any help will be appreciated.


This is the part that is not working




Super User
Super User

Hi @DemosPapa ,

Please replace Value() function with DateValue() function, as we are talking about dates. Also I guess that LPO_x0020_Created is a date type column and in this case you don't need a conversion (so no DateValue() function).

I guess that colPurchaseOrder is a collection, right ? 


Hope it helps !

New Member

Hi @gabibalaban 
Yes colPurchaseOrder is a collection.
LPO_x0020_Created is a formula value to convert Date Format (Screenshot)

I change the formula as you advise No error again but still not working (Screenshot2)


attached also photo of the collection


Thank you

@DemosPapa ,

In this case, use datevalue() all over. I thought that is a datetype there.


Hi @gabibalaban 


Still not working. That's very strange.

All the filtering is working fine this part no. Any other way to achieve it? 





Helpful resources

PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.


Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,617)