Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Microsoft Dataverse
Answered

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

(2) ShareShare
ReportReport
Posted on by

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,

  • safwankarim Profile Picture
    19 on at
    Re: What is Activity table and why should I use it instead of standard table?

    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. 

  • Prakash4691 Profile Picture
    1,332 on at
    Re: What is Activity table and why should I use it instead of standard table?

    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

  • Verified answer
    H Sheild Profile Picture
    3,000 Most Valuable Professional on at
    Re: What is Activity table and why should I use it instead of standard table?

    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 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Apps - Microsoft Dataverse

#1
mmbr1606 Profile Picture

mmbr1606 22 Super User 2025 Season 1

#2
stampcoin Profile Picture

stampcoin 17

#3
ankit_singhal Profile Picture

ankit_singhal 11 Super User 2025 Season 1

Overall leaderboard

Featured topics