Search and Filter Dynamics 365 Cases by Customer, Priority, and Status: Series 6

Search and Filter Dynamics 365 Cases by Customer, Priority, and Status: Series 6

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.