Hi @testaccPA ,
The reason that you formula not works good is because of delegation.
As you konwn, when your data is larger than 2000, delegation will lead to this.
To avoid this, you need to modify your formula to only use delegable functions.
Here are all delegable functions of sharepoint for your reference:
| Item |
Number |
Text |
Boolean |
DateTime |
Complex [1] |
| Filter |
Yes |
Yes |
Yes |
No [4] |
Yes |
| Sort |
Yes |
Yes |
Yes |
Yes |
No |
| SortByColumns |
Yes |
Yes |
Yes |
Yes |
No |
| Lookup |
Yes |
Yes |
Yes |
No |
Yes |
| = |
Yes |
Yes |
Yes |
No [4] |
Yes |
| <, <=,<>, >, >= |
Yes [2] |
No |
No |
No |
Yes |
| StartsWith |
- |
Yes |
- |
- |
Yes |
| IsBlank |
- |
No [3] |
- |
- |
No |
Firstly, datetime type is no-delegable in filter function.
Other functins about filtering not support datetime either.
So I could only suggest you filter based on other data type, for example number, text,boolen and complex.
What's more, you could only save your data to collection splitly, per 2000 records as a collection.
In collection, there's no delegation limit.
Here'a s doc about delegation functions in sharepoint list for your reference:
https://docs.microsoft.com/en-us/connectors/sharepointonline/
Best regards,
