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
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 !
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
Check out the News & Announcements to learn more.
Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.