A useful case workspace lets agents narrow records by subject, customer, priority, and status. The key is to keep filtering on Dataverse rather than downloading a large table to the client.
1. Search by subject
Filter(
Cases,
IsBlank(txtSearch.Text) || StartsWith(Title, txtSearch.Text)
)
Check the delegation status of the combined expression in your app. If the OR condition produces a delegation warning, use separate query branches or a delegable filter pattern supported by the current Dataverse connector.
2. Filter by priority
If(
IsBlank(cmbPriority.Selected),
Cases,
Filter(Cases, Priority = cmbPriority.Selected)
)
3. Filter by status
Use the Dataverse Status and Status Reason choices available in the data source. Distinguish active, resolved, and cancelled cases according to the configured lifecycle; do not assume a custom status reason has the same numeric value in another environment.
4. Combine filters
Filter(
Cases,
(IsBlank(txtSearch.Text) || StartsWith(Title, txtSearch.Text)) &&
(IsBlank(cmbPriority.Selected) || Priority = cmbPriority.Selected)
)
Validate delegation in Power Apps Studio, then use Monitor to inspect requests and response times. Test with enough records to exceed the app’s configured nondelegable row limit.
