Delegation behavior differs because each data source has different query capabilities.
Dataverse
- Built as a relational data platform
- Supports more advanced queries
- Handles complex filtering better
SharePoint
- Designed as a list-based system
- Has more delegation restrictions
Example:
A formula using Search() may work in Dataverse but fail in SharePoint.
Because of these differences, developers must always check whether a function supports delegation for the specific data source they are using.
