web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Appointment - Query "PartyList" using Power Automate to indicate record type

(0) ShareShare
ReportReport
Posted on by 903

Hello,

I have a custom entity enabled for "Create a new activity" as per the below screenshot:

Enabled-Create-Activity.png

In the appointment quick create form we have the required attendees the datatype is "PartyList" so that the user can select the type of record which should be notified for the meeting or appointment.

Appointment-Column.pngpastedimage1681326280709v1.png

In our requirement, we need a power automate flow that does the following:

  1. When an appointment is created regarding our custom table.
  2. Loop through the required attendee's record type dynamically based on the record selected from which table is coming.
  3. Send an email to those users.

The tricky part of that flow is how we can know the record type values selected so that we can know from which table are those records.

Example: I might create an appointment and select the required attendees from the contact table. Another scenario might be creating an appointment by selecting the required attendees from my custom table.

My last question is how the "PartyList" will know that the record types have a valid email address as a custom field in that custom table and rely on it to send out the email if you are creating a normal appointment without a team meeting toggle enabled.

Could you please provide an example of this flow and how it can be done?

Any help is greatly appreciated.

Best regards,

EBMRay

I have the same question (0)
  • Suggested answer
    Leah Ju Profile Picture
    Microsoft Employee on at
    RE: Appointment - Query "PartyList" using Power Automate to indicate record type

    Hi EBMRay, 

    CRM Activity Party List field is a special type of lookup field which refers to multiple entities. This field is not directly visible in the Web API for the entity. To hold or store these multiple entities references, Microsoft has provided a special type of entity named Activity Party.

    So you can list 'Activity Party' entity:

    Filter:

    1)Provide the activityId. This will be the GUID of your Activity(appointment).

    2)Provide the participationtypemask: It can be obtained from the table above, depending on the value you need to obtain (RequiredAttendee).

    pastedimage1681724197237v1.png

    3) You will need the field PartyId, which is the GUID of the Account/Contact/Lead. Using the partyId you can also determine the type of the entity.

    pastedimage1681724520428v4.png

    Output:

    pastedimage1681724495653v3.png

  • EBMRay Profile Picture
    903 on at
    RE: Appointment - Query "PartyList" using Power Automate to indicate record type

    Hello Leah Ju,

    I would appreciate your assistance on this topic.

    Best regards,

    EBMRay

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
Sahan Hasitha Profile Picture

Sahan Hasitha 394

#2
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 123

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 102 Super User 2025 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans