I cannot find a way to get appointment attendees in Flow or PowerApps using either the Dynamics 365 or Common Data Service connectors. The Activity Party entity is not available and the Appointment entity does not include the required attendees field.
Solved! Go to Solution.
Hi @peteaxtell
If you first get the Appointments using the Common Data Service connector you can loop through these and obtain all the Activity Party records for each Appointment by using a custom value in the entity drop down.
In the Entity Name field select "Enter custom value" and type in "activityparties". Then in the Filter Query field type "_activityid_value eq " and then select the Appointment Id from your Dynamic content panel. You can then loop these records in a later Flow action.
By using the Enter custom value option, you are able to query for any entity that you would have access to via the Dynamics 365 Web API.
Proud to be a Flownaut!
Follow me on Twitter at @QG_LeeJHarris
Or on LinkedIn at in/leejharris
Hi @peteaxtell
If you first get the Appointments using the Common Data Service connector you can loop through these and obtain all the Activity Party records for each Appointment by using a custom value in the entity drop down.
In the Entity Name field select "Enter custom value" and type in "activityparties". Then in the Filter Query field type "_activityid_value eq " and then select the Appointment Id from your Dynamic content panel. You can then loop these records in a later Flow action.
By using the Enter custom value option, you are able to query for any entity that you would have access to via the Dynamics 365 Web API.
Proud to be a Flownaut!
Follow me on Twitter at @QG_LeeJHarris
Or on LinkedIn at in/leejharris
Thanks very much
Hello @LeeHarris
I'm in a similar situation although with just one record needing Activity Parties added. I'm trying to create a phone call. I have been able to add the information calling the activityparties as entity, but when I run the flow, it fails with an error 400 no matter if I use the create, update, or using your list method., Any suggestions?:
As far as I can tell, the activity party entity is only available for Read access using the Web API (https://docs.microsoft.com/en-us/dynamics365/customer-engagement/web-api/activityparty?view=dynamics...).
This may be why it is also not possible to set the from and to fields using the standard Create/Update record actions in the CDS connector, and I would imagine that this limitation also exists in PowerApps.
Unless you can find a really creative way of working around this, I'd suggest posting this in the Ideas board with a link to it here (it gets my vote).
Proud to be a Flownaut!
Follow me on Twitter at @QG_LeeJHarris
Or on LinkedIn at in/leejharris
@LeeHarris Hi Lee, Would you like to share the complete Flow with me as I want to accomplish the exact same (updating contact relating to an appointment).
Eventough I followed your steps, the flow loops through all the contacts in the CDS instead of the contacts relating to the Appointment.
Thanks a mill for your time and support already.
Robin
Hi @RobinMulder
Unfortunately, I do not have a complete Flow that I can share. If you can post screenshots of your Flow process showing where you are encountering the error I may be able to assist though. It sounds like you either need to add a filter to your List records action when you are retrieving the Contacts, or you are using the wrong dynamic value in your loop.
Proud to be a Flownaut!
Follow me on Twitter at @QG_LeeJHarris
Or on LinkedIn at in/leejharris
@LeeHarris Which mistake did I miss? and how can I achieve what would like to achieve which is update a field on the contact from all the contacts the are related to the closed/completed appointment?
Hi @RobinMulder
The Id of the Contact within the Activity Party record is stored in the field "_partyid_value". The Id that you are using in your update Contact step is the Id of the Activity Party record itself. If you are not able to see the Party Id value in the Dynamic Content you can add it to the Id parameter in your action as an Expression.
Proud to be a Flownaut!
Follow me on Twitter at @QG_LeeJHarris
Or on LinkedIn at in/leejharris
Hi @LeeHarris ,
Thanks for your help. With some tweeks here and there I made it work. Couldnt have done it without you.
Excellent, glad to hear you got it working 😄
Proud to be a Flownaut!
Follow me on Twitter at @QG_LeeJHarris
Or on LinkedIn at in/leejharris
Activity party can be retrieved in the same call using expand option as well. Need not to make second call just to retrieve that data. link to similar thread :
Thanks
Hi,
I am trying to move appointment from lead to contact when Lead is converted to Contact. So I am able to achieve it. However, when i am moving the Appointment to Contact the Required Attendees is not changed and which why it is visible in Lead as well as Contact Timeline.
How to update Required Attendees in Appointment? So, that i can update that field and set as contact which will show me Appointment activity in only Contact.
Regards,
Rushi
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
17 | |
14 | |
7 | |
6 | |
5 |
User | Count |
---|---|
23 | |
18 | |
10 | |
8 | |
7 |