Answered

Filter gallery by date

(0) Share

Report

Posted on by laani

Hi All,

I have a gallery that connected to sharepoint list. One column from this list is a date time column. It is appears as a date field in the power app. I want to filter my gallery by this date but face a problem.
If there is something special between Filter function and dates ?
Filter (dataSource, 'Date Time Column' = Date(2020,3,18)) does not return any record to my gallery, but they are there. I took Date(2020,3,18) exactly to troubleshoot this case. In the same time I put a label on gallery template with this formula
Text( ThisItem.'Date Time Column:' = Date(2020,3,18))
and get true every where it was expected

thank you in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

Showing a sample from the date Column in your table Will help. Meanwhile try

Filter (dataSource, 'Date Time Column' = "2020,3,18")

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
laani 13 on at

Like (0)

Report
Copy link

Link copied!

Hi @eka24 The next screenshot is a drill down into column with a date, interesting that sharepoint list set to keep "Date only", but in app there is "time" part too
The next screen is drill to composed Date value, I think my problem that I do not see difference but Filter() function does.

Was this reply helpful? Yes No
Verified answer

eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

Try

Filter (dataSource, Text('Date Time Column',"dd-mm-yy") = "18-03-20")

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No