Announcements
I have a sharepoint list that contains a date field. Using a data table, what would be the best filter formula to only show all dates that are less or equal to Today? I want to make sure the dates displays are only present and future dates.
You can use the Today function in a Filter to display just the dates you want. Since you are working with a date field the query will not be delegable (blue dot).
Present and Pasts Dates: Filter('SP List Name', DateField <= Today()) Present and Future Dates: Filter('SP List Name', DateField >= Today())
If your list is under 2,000 items then you can still use the non-delegated functions. The default row limit for non-delegated queries is 500 but there is a feature that allows you to increase that limit up to 2,000.
PowerApps data row limit for non-delegable queries
Thanks Jeff, but unfortunately, I did get the blue did saying that the highlighted operation is not supported by column "EventDate". The datatable retrieves data from a SharePoint calendar.
The blue dot means that the filter will be executed locally after the first 500 items are returned from the data source. You can increase that limt to 2,000. If your list is less than 2,000 then you can use the non-delegable query and get the expected results even if you have the blue dot.
How do I increase it to 2000?
This arctcle explains how to increase it to 2,000
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 394 Super User 2026 Season 2
Mohsin Ali 328
WarrenBelz 324 Most Valuable Professional
