Announcements
Hi @All
I would like to filter a SharePoint list, in a gallery only with today's sales, What formula can I use?
You just need to compare the sales date to today's date.
Filter('SP List', SalesDate = Today())
FYI: Date fields aren't delegable in SharePoint, so if you have a large list it may not return all the list items.
It does not return the values
How large is your SharePoint list and is your Sales Date field a date field?
It has around 2,000 Files, the Date field is Date
This could be a delegation issue because date fields aren't degelable and the default for non-delegable queries is 500 rows. This means the filter doesn't get applied until after the first 500 items are returned from the connector. There is a new feature that allows you to increase the non-delegable threshold up to 2,000.
PowerApps data row limit for non-delegable queries
How can that increase the threshold?
it does not work, there is no other way to create that filter
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 381 Super User 2026 Season 2
Mohsin Ali 340
WarrenBelz 187 Most Valuable Professional
