Unanswered

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

(2) Share

Report

Posted on by Dave Wi

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,

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Hamish Sheild 3,005 Most Valuable Professional on at

Like (3)

Report

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

Was this reply helpful? Yes No
Prakash4691 1,332 on at

Like (0)

Report

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

Was this reply helpful? Yes No
safwankarim 19 on at

Like (2)

Report

Hi @HSheild, do you know if this has changed? Can Custom Activity tables be given specific permissions? I have 2 custom activity tables, AT1 and AT2. I want AT1 to be read-only for portal contact users and AT2 to be read and write permissions.

Was this reply helpful? Yes No