web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Pages / Problems with filterin...
Power Pages
Suggested Answer

Problems with filtering view with a Date field.

(0) ShareShare
ReportReport
Posted on by
Hi!
I have a list in my Power Pages site, whose data that comes from a SharePoint list. One of the column is a DateTime type column. I have a view in which I want to offer the upcoming appoinments slots. I need to filter out the old ones. The problem is that the filter by date field gives the next error: "Data preview not availableThere was an error retrieving your data. Please check your filters and try again."



This is my out of the box view:
 

and here you have one of the filter modes that I have tested: 
As you can see, there are one appoinment slot for the next month, so it should be a row in the filttered view.
I have the same proble with other option like the next 7 days or this month.
 
I created also another column of the type only date, to test if the problem was in DateTime/ Only Date, but I had the same error with it.

I have filttered by other colums and it works fine. I have the problem only with the date filter.

Thank you in advance for all the ideas you can give me!
Categories:
I have the same question (0)
  • Suggested answer
    SaiRT14 Profile Picture
    1,992 Super User 2025 Season 1 on at
    o filter out past appointments, you can compare the appointment date against the current date using the Now() or Today() function, depending on whether you care about the time as well:
    Filter(YourDataSource, AppointmentDate >= Today())
    Filter(YourDataSource, AppointmentDate >= Now())
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Pages

#1
11manish Profile Picture

11manish 56

#2
Valantis Profile Picture

Valantis 46

#3
rezarizvii Profile Picture

rezarizvii 25

Last 30 days Overall leaderboard