In this part, create a case list that helps agents find work without loading the entire Case table into a local collection. Add the Dataverse Cases table as a data source and insert a vertical gallery.
1. Basic gallery
Set the gallery Items property to a delegable query for the signed-in user’s active cases. Confirm the exact status and owner column names in your environment before using the formula.
SortByColumns(
Filter(
Cases,
'Owner'.'Primary Email' = User().Email
),
"createdon",
SortOrder.Descending
)
Dataverse owner is a polymorphic lookup and may not expose the same related columns in every app authoring experience. If this relationship expression is not accepted, use a supported owner filter generated from the data pane or expose a dedicated agent view through Dataverse.
2. Add a search box
Filter(
Cases,
StartsWith(Title, txtSearch.Text)
)
For the standard Case table, the primary name column is commonly title. Search by subject first; add customer or case number filters only after checking delegation support for the selected columns.
3. Display useful fields
- Case title and ticket number
- Customer (Account or Contact)
- Priority and status reason
- Created date and owner
4. Open the selected case
Set(varSelectedCase, ThisItem);
Navigate(scrCaseDetails, ScreenTransition.Fade)
Keep the gallery query delegable. Use Power Apps Monitor and the delegation warnings to validate behavior against a dataset larger than the app’s local row limit.
