31. How to replace a non-delegable search in SharePoint?

The Search() function is not delegable in SharePoint.
A common solution is to replace it with Filter + StartsWith.
Non-delegable example:

Search(Employees, txtSearch.Text, Name)

Delegable alternative:

Filter(
Employees,
StartsWith(Name, txtSearch.Text)
)

Why this works:

• StartsWith() supports delegation in SharePoint
• Filtering happens on the server
• The full dataset is evaluated