/

Build a Dataverse Case Browse Gallery in Power Apps: Series 2

Dataverse Accounts gallery screenshot

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.