1. What are activity tables and how are they different from standard tables?

Activity tables track time‑based actions. They share common fields like subject, start/end time, and “regarding.”

Standard tables store business data without timeline behavior.

As shown in below diagram, Appointment is marked as an Activity table, while Account is marked as a Standard table.

Dataverse-tables-showing-Activity-vs-Standard-types-in-Power-Apps-by-CoyLix

 

Examples

  • Activity Tables: Appointment, Email, Fax, Letter, Phone Call etc.
  • Standard Tables: Account, Business Unit, Contact etc.

Difference

Activity tables can only be owned by a User or a Team. Organization-level ownership is not allowed in activity table. Standard tables support both user/team and organization ownership

Interview tip: They’ll often ask “Can an activity table be org-owned?” – the answer is No.

Scroll to Top