cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dave8
Post Prodigy
Post Prodigy

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

Hello,

 

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?

 

Thanks,

2 REPLIES 2
HSheild
Super User
Super User

Hi @dave8 

 

Have you seen this article? https://docs.microsoft.com/en-us/powerapps/maker/data-platform/types-of-entities#activity-tables

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 

Prakash4691
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.

 

 

Regards,

Prakash

Helpful resources

Announcements
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!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Users online (53,399)