Delegation warning.

[Anonymous]

What is the best practice when there's a delegation warning?

[timl]

Hi @Anonymous 

The short answer is this.

If your source data contains fewer than 2000 rows, you don't need to worry about delegation warnings. Otherwise, it would be wise to rewrite your query/function, re-structure your data, cache data locally, or to carry out some other task to resolve the warning. 

If you could provide details of the formula that you're using, I'm sure someone here can provide some more specific advise.

[v-yutliu-msft]

Hi @Anonymous ,

1)If your record is smaller than 2000, I suggest you change your non-limit to 2000.

File->app settings->advanced settings:

2)if your recordis larger than 2000, I suggest you use delegable data source and delegable functions.

Here are delegable data source:

• Common Data Service
• SharePoint
• SQL Server

You could click the link to see its delegable functions. Different data source has different delegable functions.

If you do not modify your foemula, you app may not perform well.

Best regards,

Community Support Team _ Phoebe Liu