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!
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!
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!
User | Count |
---|---|
37 | |
28 | |
19 | |
18 | |
11 |
User | Count |
---|---|
32 | |
24 | |
16 | |
15 | |
13 |