web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Filter by date based o...

Power Apps

Answered

Filter by date based on Sharepoint date and time column

(0) Share

Report

Report

Posted on by mseliot

89

Hi all,

I am trying to filter a gallery by date from a date picker based on the sharepoint "date and time" column. The column has both date and time info. (e.g. 1/1/2022 8:15 pm). But it seems the filter doesn't recognize the date only info from the date and time column.

This is my current formula.

Filter (Datasource, SPDateTimeColumn = datepicker.SelectedDate)

Anyway to achieve it?

Thank you for your help and support!

Eliot

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

EddieE 4,641 Moderator on at

Like (1)

Report
Copy link

Link copied!
@mseliot

Date/Time values are decimals and Date values are integers and this would be why your filter isn't working correctly.

You could try this

// Set date variables to workaround delegation Set( vToday, datepicker.SelectedDate); Set( vTomorrow, DateAdd(datepicker.SelectedDate, 1, Days) // Filter Filter(Datasource, SPDateTimeColumn >= vToday && SPDateTimeColumn < vTomorrow)

Or, you could just add a Date only column and save all the fuss.

Was this reply helpful? Yes No
mseliot 89 on at

Like (0)

Report
Copy link

Link copied!

Thank you Eddie! I simply made the Date only column and date/Time column separately to save all the fuss 🙂

Was this reply helpful? Yes No

Join the conversation