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

PA Community Call

Power Apps Community Call

Next call is happening on April 21st at 8a PST.

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Users online (63,437)