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

Notifications

Announcements

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,990 Super User 2025 Season 2 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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Pages

#1
Fubar Profile Picture

Fubar 78 Super User 2025 Season 2

#2
Jerry-IN Profile Picture

Jerry-IN 75

#3
sannavajjala87 Profile Picture

sannavajjala87 31

Last 30 days Overall leaderboard