Skip to main content

Notifications

Announcements

Announcing our 2025 Season 1 Super Users!
Welcome to the Power Platform Communities
Join us for the Powerful Devs Hack Together
Help us with Power Pages Makers & Tenant Admin
Announcing Forum Attachment Improvements!
News and Announcements icon
Power Platform Community / Forums / Power Automate - Using Connectors / Attribute missing from...
Power Automate - Using Connectors
Unanswered

Attribute missing from activity party (activityparties) for CDS current environment connector

(1) ShareShare
ReportReport
Posted on by Community Power Pla...

When using the standard CDS connector, activityparties entity will return the attribute '_partyid_type' which indicates whether the party is a systemuser or contact. 

 

When using the CDS (current environment) connector, that attribute it not returned and I cannot see how to distinguish between contacts and users. I want to get the underlying contact or user record from the activityparty record.

  • MrsMash09 Profile Picture
    MrsMash09 3 on at
    Re: Attribute missing from activity party (activityparties) for CDS current environment connector

    I'm experiencing the same issue, did you find a resolution for this?

  • Community Power Platform Member Profile Picture
    Community Power Pla... on at
    Re: Attribute missing from activity party (activityparties) for CDS current environment connector

    @v-alzhan-msft 

     

    The connectors/configuration:

    config.png

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    The output from the current environment connector:

     "body": {
 "@odata.context": "https://orgurl.dynamics.com/api/data/v9.0/$metadata#activityparties",
 "value": [
 {
 "@odata.type": "#Microsoft.Dynamics.CRM.activityparty",
 "@odata.id": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)",
 "@odata.etag": "W/\"16900298\"",
 "@odata.editLink": "activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)",
 "ispartydeleted": false,
 "_activityid_value@odata.type": "#Guid",
 "_activityid_value": "ad2dcc7b-e3de-e911-a812-000d3a86d7a3",
 "participationtypemask": 7,
 "scheduledend@odata.type": "#DateTimeOffset",
 "scheduledend": "2019-09-27T17:00:00Z",
 "addressusedemailcolumnnumber": 15,
 "addressused": "test@test.com",
 "_ownerid_value@odata.type": "#Guid",
 "_ownerid_value": "b1317c0b-a1e9-45dd-932b-84422c32517e",
 "_partyid_value@odata.type": "#Guid",
 "_partyid_value": "b1317c0b-a1e9-45dd-932b-84422c32517e",
 "versionnumber@odata.type": "#Int64",
 "versionnumber": 16900298,
 "activitypartyid@odata.type": "#Guid",
 "activitypartyid": "b72dcc7b-e3de-e911-a812-000d3a86d7a3",
 "instancetypecode": 0,
 "scheduledstart@odata.type": "#DateTimeOffset",
 "scheduledstart": "2019-09-27T16:00:00Z",
 "activityid_activitypointer@odata.associationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/activityid_activitypointer/$ref",
 "activityid_activitypointer@odata.navigationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/activityid_activitypointer",
 "activityid_quoteclose@odata.associationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/activityid_quoteclose/$ref",
 "activityid_quoteclose@odata.navigationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/activityid_quoteclose",
 "activityid_task@odata.associationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/activityid_task/$ref",
 "activityid_task@odata.navigationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/activityid_task",
 "activityid_phonecall@odata.associationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/activityid_phonecall/$ref",
 "activityid_phonecall@odata.navigationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/activityid_phonecall",
 "partyid_equipment@odata.associationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/partyid_equipment/$ref",
 "partyid_equipment@odata.navigationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/partyid_equipment",
 "partyid@odata.associationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/partyid/$ref",
 "partyid@odata.navigationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/partyid",
 "activityid_serviceappointment@odata.associationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/activityid_serviceappointment/$ref",
 "activityid_serviceappointment@odata.navigationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/activityid_serviceappointment",
 "partyid_opportunity@odata.associationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/partyid_opportunity/$ref",
 "partyid_opportunity@odata.navigationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/partyid_opportunity",
 "activityid_msfp_surveyinvite_activityparty@odata.associationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/activityid_msfp_surveyinvite_activityparty/$ref",
 "activityid_msfp_surveyinvite_activityparty@odata.navigationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/activityid_msfp_surveyinvite_activityparty",
 "activityid_recurringappointmentmaster@odata.associationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/activityid_recurringappointmentmaster/$ref",
 "activityid_recurringappointmentmaster@odata.navigationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/activityid_recurringappointmentmaster",
 "partyid_quote@odata.associationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/partyid_quote/$ref",
 "partyid_quote@odata.navigationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/partyid_quote",
 "partyid_salesorder@odata.associationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/partyid_salesorder/$ref",
 "partyid_salesorder@odata.navigationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/partyid_salesorder",
 "activityid_opportunityclose@odata.associationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/activityid_opportunityclose/$ref",
 "activityid_opportunityclose@odata.navigationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/activityid_opportunityclose",
 "activityid_orderclose@odata.associationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/activityid_orderclose/$ref",
 "activityid_orderclose@odata.navigationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/activityid_orderclose",
 "partyid_systemuser@odata.associationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/partyid_systemuser/$ref",
 "partyid_systemuser@odata.navigationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/partyid_systemuser",
 "activityid_email@odata.associationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/activityid_email/$ref",
 "activityid_email@odata.navigationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/activityid_email",
 "partyid_contact@odata.associationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/partyid_contact/$ref",
 "partyid_contact@odata.navigationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/partyid_contact",
 "activityid_incidentresolution@odata.associationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/activityid_incidentresolution/$ref",
 "activityid_incidentresolution@odata.navigationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/activityid_incidentresolution",
 "activityid_letter@odata.associationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/activityid_letter/$ref",
 "activityid_letter@odata.navigationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/activityid_letter",
 "partyid_knowledgearticle@odata.associationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/partyid_knowledgearticle/$ref",
 "partyid_knowledgearticle@odata.navigationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/partyid_knowledgearticle",
 "partyid_entitlement@odata.associationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/partyid_entitlement/$ref",
 "partyid_entitlement@odata.navigationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/partyid_entitlement",
 "partyid_campaignactivity@odata.associationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/partyid_campaignactivity/$ref",
 "partyid_campaignactivity@odata.navigationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/partyid_campaignactivity",
 "activityid_msfp_surveyresponse_activityparty@odata.associationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/activityid_msfp_surveyresponse_activityparty/$ref",
 "activityid_msfp_surveyresponse_activityparty@odata.navigationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/activityid_msfp_surveyresponse_activityparty",
 "partyid_account@odata.associationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/partyid_account/$ref",
 "partyid_account@odata.navigationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/partyid_account",
 "partyid_lead@odata.associationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/partyid_lead/$ref",
 "partyid_lead@odata.navigationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/partyid_lead",
 "activityid_fax@odata.associationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/activityid_fax/$ref",
 "activityid_fax@odata.navigationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/activityid_fax",
 "partyid_incident@odata.associationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/partyid_incident/$ref",
 "partyid_incident@odata.navigationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/partyid_incident",
 "partyid_campaign@odata.associationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/partyid_campaign/$ref",
 "partyid_campaign@odata.navigationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/partyid_campaign",
 "partyid_contract@odata.associationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/partyid_contract/$ref",
 "partyid_contract@odata.navigationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/partyid_contract",
 "partyid_queue@odata.associationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/partyid_queue/$ref",
 "partyid_queue@odata.navigationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/partyid_queue",
 "partyid_bulkoperation@odata.associationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/partyid_bulkoperation/$ref",
 "partyid_bulkoperation@odata.navigationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/partyid_bulkoperation",
 "resourcespecid@odata.associationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/resourcespecid/$ref",
 "resourcespecid@odata.navigationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/resourcespecid",
 "partyid_invoice@odata.associationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/partyid_invoice/$ref",
 "partyid_invoice@odata.navigationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/partyid_invoice",
 "activityid_appointment@odata.associationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/activityid_appointment/$ref",
 "activityid_appointment@odata.navigationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/activityid_appointment",
 "activityid_campaignactivity@odata.associationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/activityid_campaignactivity/$ref",
 "activityid_campaignactivity@odata.navigationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/activityid_campaignactivity",
 "activityid_socialactivity@odata.associationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/activityid_socialactivity/$ref",
 "activityid_socialactivity@odata.navigationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/activityid_socialactivity",
 "activityid_campaignresponse@odata.associationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/activityid_campaignresponse/$ref",
 "activityid_campaignresponse@odata.navigationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/activityid_campaignresponse",
 "ActivityParty_SyncErrors@odata.associationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/ActivityParty_SyncErrors/$ref",
 "ActivityParty_SyncErrors@odata.navigationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/ActivityParty_SyncErrors",
 "userentityinstancedata_activityparty@odata.associationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/userentityinstancedata_activityparty/$ref",
 "userentityinstancedata_activityparty@odata.navigationLink": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)/userentityinstancedata_activityparty"
 }

     

    The output from the standard connector:

     "body": {
 "@odata.context": "https://azureurl/apim/commondataservice/shared-commondataser-testguid/$metadata#datasets('default.cds')/tables('activityparties')/items",
 "value": [
 {
 "@odata.id": "https://orgurl.dynamics.com/api/data/v9.0/activityparties(b72dcc7b-e3de-e911-a812-000d3a86d7a3)",
 "@odata.etag": "",
 "ItemInternalId": "b72dcc7b-e3de-e911-a812-000d3a86d7a3",
 "ispartydeleted": false,
 "_activityid_value": "ad2dcc7b-e3de-e911-a812-000d3a86d7a3",
 "_activityid_type": "activitypointers",
 "participationtypemask": 7,
 "_participationtypemask_label": "Organizer",
 "scheduledend": "2019-09-27",
 "addressusedemailcolumnnumber": 15,
 "addressused": "test@test.com",
 "_partyid_value": "b1317c0b-a1e9-45dd-932b-84422c32517e",
 "_partyid_type": "systemusers",
 "versionnumber": 16900298,
 "activitypartyid": "b72dcc7b-e3de-e911-a812-000d3a86d7a3",
 "scheduledstart": "2019-09-27"
 }

    As you can see, the CDS output includes "_partyid_type": "systemusers" but there is nothing to give me this attribute from the CDS current environment output.

  • v-alzhan-msft Profile Picture
    v-alzhan-msft on at
    Re: Attribute missing from activity party (activityparties) for CDS current environment connector

    Hi @Anonymous ,

     

    Could you please share a screenshot of the configuration of your flow?

    Which action are you using with CDS connector and CDS (current environment) connector? 

    Could please share more details about the CDS connector and CDS (current environment) connector?

     

    Best regards,

    Alice       

     

    Community Support Team _ Alice Zhang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

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

News and Announcements

Announcing our 2025 Season 1 Super Users!
Welcome to the Power Platform Communities
Join us for the Powerful Devs Hack Together
Help us with Power Pages Makers & Tenant Admin
Announcing Forum Attachment Improvements!

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans