SharePoint supports many basic queries but has several delegation limitations.
- Search() is not delegable
- Distinct() is not delegable
- The In operator may break delegation
- Complex lookup filtering may fail
- Some aggregation operations are limited
Important point:
Delegation depends on the entire formula, not just the main function.
Example:
Filter() may support delegation, but if you use a non-delegable operator inside the filter, the whole formula may stop delegating.
