I have 3 columns in the Customer Visit (renamed appointment table) entity which has the type Party List. I want to know how this column works. Where is it connected to? When a new record is added into this table, automatically a new record is getting added in the Activity table in my env. What is that connection?
The Activity table has a relationship to the Activity Party table. What is this relation? How can I filter and see the data which is there in the Activity Party table?
Thank you in advance!
Hello
If I try to summarize:
Party List Data Type:
I found the relationship. The three tables in the scene here are Appointment, Activity, and Activity Party. The Appointment table (appointment) is a specific type of activity. The Activity table (activity pointer) serves as a common base table that includes generic fields applicable to all activity types (such as tasks, emails, phone calls, and appointments).
So when a record gets added into Appointment table, a new record gets added to the Activity table. And the associated parties for that specific activities, which here are the Customer/Accounts appointments will be stored in the Activity Party table.
If we use a flow to filter out Activity Party table with a normal Appointment GUID lookup, we will get the related records for the specific appointment.
You can see the activities table as an aggregation table or perhaps an aggregate view, in this table you will not have forms, only views, and you will be able to filter by type of activities only if you use Model Driven Apps for Canvas Apps the TypeActivity field is not available
I believe the activity party table will have pointers to the other activities from your primary table. Kind of an intersect table that will point you all the items in the ‘party’.
i dont recall if its a standard lookup or simply a GUID that points to the activities. If its a standard lookup you could probably use the $expand criteria in power automate to retrieve the fields from the related activity to help you filter.
otherwise you’d query the Activity Party table for all associated activities, then filter the resultset based on your criteria.
Okay. Correct me if my understanding is wrong. Does that mean In the Activity Party table there will be a normal lookup to the Activity table? Can I filter the Activity Party table with a specific Activity from the Activity table?
If I remember correctly and ActivityParty is just a polymorphic lookup to multiple possible activity types. Think of an email “to” line, it is a lookup to GAL entries for multiple people. The fact that you can select multiple, similar to a multi-select lookup is what makes it different than a normal lookup. Also that it’s tied to only activities.
Take a look here:
https://learn.microsoft.com/en-us/power-apps/developer/data-platform/activityparty-entity
It is a relationship that is created to use various fields such as to sender activities, this relationship is created with the users, account and contact table