Troubleshoot & Optimise Apps

Finding and fixing problems

Debugging with Monitor

The Monitor tool captures everything your app does behind the scenes.

What Monitor Shows	Why It Matters
Network requests	See every call to Dataverse, connectors, and APIs — including timing and payload size
Formula evaluations	Which formulas are running, how long they take, and what they return
Errors and warnings	Detailed error messages that may not appear in the app UI
Delegation warnings	Which queries are running client-side instead of server-side
User actions	Track what the user clicked and the resulting data flow

Common debugging patterns

1. App returns wrong data → Check Monitor for the network request. Is the filter correct? Is the query delegated?
2. App is slow → Sort Monitor events by duration. Find the slowest network requests.
3. Intermittent errors → Run Monitor with “Join session” to capture a user’s live session remotely.
4. Connector failures → Monitor shows the raw HTTP response including error codes and messages.

💡 Scenario: Kai debugs a slow shipment app

Kai’s shipment tracking app takes 15 seconds to load the main screen. He opens Monitor and sees:

1. Three sequential Dataverse queries — each takes 3-4 seconds. They load Shipments, Drivers, and Vehicles.
2. A delegation warning on the Shipments query — the filter uses a Left() function, which is not delegable. Dataverse returns only the first 500 records, then the app filters 10,000 records locally.
3. A large payload — the Drivers query returns all 50 columns when the screen only displays Name and Phone.

Fixes:

• Replace Left() filter with a delegable StartsWith() function
• Use Concurrent() to load all three queries in parallel
• Add ShowColumns() to the Drivers query to fetch only Name and Phone
• Result: load time drops from 15 seconds to 3 seconds

Delegation: the performance killer

Delegation means the data source (Dataverse, SQL, SharePoint) processes the query server-side. If a formula is not delegable, Power Apps downloads all records and filters locally — with a cap (default 500, max 2,000).

Memorise which functions delegate and which do not — the exam tests this

Function	Delegable to Dataverse?	Alternative
Filter with =, <>, <, >	Yes	N/A — use these
StartsWith	Yes	N/A — use this for text matching
Search (in view)	Yes	Use Dataverse search for best results
Left, Right, Mid	Yes (Dataverse)	Note: delegable to Dataverse but NOT to SharePoint or SQL — check per data source
Len	Yes (Dataverse)	Delegable to Dataverse; not all sources support it
in operator (collection)	No	Use AddColumns + LookUp pattern instead
IsBlank (on lookup)	No	Filter on the lookup column directly
Sort with formula	Partial — simple column sorts are delegable	Add a sort column in Dataverse

Pre-loading data

For data that does not change during a session, load it upfront:

• Named formulas — define in App.Formulas for automatic caching
• Concurrent() — load multiple data sources in parallel on App.OnStart or screen OnVisible
• Collections — ClearCollect(LocalCache, Filter(BigTable, ...)) to create a local copy for non-delegable operations

💡 Exam tip: The delegation warning trap

The exam often presents a scenario where an app works correctly in testing (small dataset, under 500 records) but fails in production (large dataset, 10,000+ records). The cause: a non-delegable formula that silently drops records beyond the delegation limit.

The fix is always: use delegable functions, increase the delegation limit (Settings → max 2,000), or pre-filter with a delegable query before applying non-delegable transformations.

Model-driven app optimisation

Form performance

Optimisation	Impact
Remove unused tabs and sections	Fewer components to render
Lazy-load tabs (expand by default = off)	Tabs load only when clicked
Minimise JavaScript on form load	Reduce OnLoad execution time
Batch Web API calls	One request instead of multiple
Use business rules instead of scripts for simple logic	Faster, no JavaScript overhead

View performance

• Limit columns — show only what users need (each column is a query join)
• Add appropriate filters — avoid “all records” views on large tables
• Use personal views for individual needs instead of modifying system views

Question

What is delegation in Power Apps?

Click or press Enter to reveal answer

Answer

Delegation means the data source (Dataverse, SQL) processes the query server-side and returns only the matching results. Non-delegable formulas download all records (capped at 500-2000) and filter locally. With large datasets, non-delegable queries silently return incomplete results.

Click to flip back

Question

How does Concurrent() improve canvas app performance?

Click or press Enter to reveal answer

Answer

Concurrent() runs multiple data loading operations in parallel instead of sequentially. If three queries each take 3 seconds, sequential loading takes 9 seconds but Concurrent() takes ~3 seconds (they run simultaneously). Use it for independent data sources on OnVisible or OnStart.

Click to flip back

Question

What does Monitor show that browser dev tools do not?

Click or press Enter to reveal answer

Answer

Monitor provides Power Apps-specific context: formula evaluations, delegation warnings, connector call details, and Power Fx errors. Browser dev tools show raw network traffic and JavaScript errors but do not understand Power Fx formulas or delegation. Use both together for complete debugging.

Click to flip back

Knowledge Check

A canvas app displays a gallery of Customer records filtered by the first three characters of the customer name. The app works correctly with 200 test records but shows incomplete results in production with 15,000 records. What is the most likely cause?

AThe Dataverse connector has a rate limit that caps results at 500BThe Left() function used in the filter is not delegable, so only the first 500 records are downloaded and filtered locallyCThe gallery control has a maximum item count of 500DThe user's security role restricts access to only 500 records

Check Answer

🎬 Video coming soon

Next up: Client Scripting — writing JavaScript for model-driven app form events, the Client API, and Dataverse Web API calls.