Show Case Timeline Activities and Customer Interactions in Power Apps: Series 7

Show Case Timeline Activities and Customer Interactions in Power Apps: Series 7

Agents need to know what has already happened before contacting a customer again. This part adds an activity panel to the Case details screen.

1. Understand activity relationships

Dynamics 365 activities can be associated with a Case through the Regarding relationship. Tasks, phone calls, appointments, and emails are activity records; notes are stored separately as annotations. Confirm the connector tables and relationship fields available in your environment.

2. Query related tasks

Filter(
    Tasks,
    Regarding = varSelectedCase
)

The exact lookup field and equality expression depend on the activity table’s Regarding lookup projection. If the formula is not accepted, inspect the relationship fields in the data pane and use the supported Case reference.

3. Present a unified activity view

For a simple screen, use separate galleries for tasks and phone calls. A unified timeline may require a normalized collection with a common display schema (activity type, subject, date, owner, and state). Keep the source queries filtered on Dataverse before collecting records.

4. Include notes carefully

Notes may contain confidential information and file attachments. Apply the correct Dataverse privileges and avoid loading attachment bodies unless the user explicitly opens the note. Use a secure file experience for downloads.