6. How do you design apps to avoid delegation issues?

Good app design can prevent many delegation problems.
Recommended practices:

• Choose the right data source: Dataverse or SQL often support better delegation.
• Use delegable functions: Prefer Filter() and StartsWith().
• Avoid complex transformations: Functions like ForAll or AddColumns on large datasets may cause issues.
• Test with small row limit: Temporarily set the limit to 1 to detect non-delegable formulas.
• Fix warnings early: Do not ignore delegation warnings during development.

These practices help ensure apps scale correctly as datasets grow.