Showing results for 
Search instead for 
Did you mean: 
Post Prodigy
Post Prodigy

What is Activity table and why should I use it instead of standard table?



I have come across to "Activity Table" type, however I could not get the clarity on how it could be more useful than the "Standard Table" - Can anyone please provide me the reference link or explain in which scenario I should use that?



Super User
Super User

Hi @dave8 


Have you seen this article?

I think it explains it pretty clearly. Essentially, Activity tables represent something that you can schedule and put on a calendar, and that you would like to track its completion. They have certain shared properties like start and end date etc. They  can be shown in the Timeline control. Security is a consideration when creating custom Activity tables as you can only set a security role’s permissions to be for all Activities, not at an individual Activity table level. 

An example of a custom activity is a Site Visit - where a user has a time booked to visit a client on a building site, for example, and this activity is used to report on how often site visits are completed etc.


I hope that makes sense. Let us know if you have a certain scenario you are thinking of using the Activity table for, but are not sure 

Resolver II
Resolver II

Hi @dave8 ,


Addition to @HSheild points,


Activity table by OOB has party list. 


CRM Activity Party List field is a special type of lookup field which refers to multiple entities. To hold or store these multiple entities references, Microsoft has provided one special type of entity named Activity Party.


Activity Party, has one special field called Party Id. which has the capability to store multiple entities references like user, contact, account, lead etc.





Helpful resources

PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!


Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (44,510)