Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

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

Posted on by 873

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

  • Suggested answer
    Leah Ju Profile Picture
    Leah Ju 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
    EBMRay 873 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans