How do I pass multiple entity records Guid’s of different type to TO Recipients while creating a email record using power automate

[GaneshT]

How do I pass multiple records Guid’s of different type to TO Recipients while creating a email record? Its dynamic count from source system so cannot add multiple using icon T.

Getting below error

Error: Bad Request - Error in query syntax.

[

  {

    "participationtypemask": 2,

    "partyid@odata.bind": "{accounts(abxxxx-xxxxx-xxxxx-xxxx-xxxxxxxx)},{contacts(yyyyyyy-yyyy-yyyy-yyyy-yyyyyyyyy)}"

  }

]

[Expiscornovus]

Hi @GaneshT,

I am assuming you are using the Web API?

If so, can you try this approach:

{
    "description" : "Email Created", 
    "regardingobjectid_account@odata.bind" : "/accounts(@{variables('AccountId')})",
    "subject" : "Test Email Creation", 
    "email_activity_parties" : [
        {
            "partyid_systemuser@odata.bind" : "/systemusers(@{variables('SystemUserId')})",
            "participationtypemask" : 1  
        },
        {
            "partyid_account@odata.bind" : "/accounts(@{variables('AccountId')})",
            "participationtypemask" : 2  
        },
{            "partyid_contact@odata.bind" : "/contacts(@{variables('ContactId')})",
            "participationtypemask" : 2 
        }
]
}

More examples can be found over here:

https://community.dynamics.com/365/b/dynamics365enterprisecloudfronts/posts/creating-an-email-activi...

[GaneshT]

Thanks @Expiscornovus , for quick reply. 

We are using Microsoft flows to sync from Regional Prod A and Regional Prod B to Global Prod  of dynamics.

We do sync accounts, contacts and activities to Global Prod

During which all emails from regional to be synced with Global Prod

• Fetch To Recipients from source and form the same with Target Guids as below

{accounts(abxxxx-xxxxx-xxxxx-xxxx-xxxxxxxx)},{contacts(yyyyyyy-yyyy-yyyy-yyyy-yyyyyyyyy)} and

• Store it in a legacy field in Target using CDS (Current Data Service)
• In Target, use CDS (Current Environment) to refer this field in cloud flow- Email (Create or Update) Activity Parties
• On Create of Email record in Target, another flow is executed in target to pick value from legacy field and update To Recipients.

Getting below error

Error: Bad Request - Error in query syntax.

it would be great if i could update recipients like you mentioned as below

{
"partyid_account@odata.bind" : "/accounts(@{variables('AccountId')})",
"participationtypemask" : 2
},
{ "partyid_contact@odata.bind" : "/contacts(@{variables('ContactId')})",
"participationtypemask" : 2
}

[JorgeFerr]

Try to append your data into an array first like this:

Then use the variable to bring multi contacts:

Let us know if this solves your problem.

[JorgeFerr]

Correction:
It is "contactid" coming from Contacts entity (not contact_id)

[ManishJain]

Hi @GaneshT ,

Since you are syncing data from one environment to other why are you sending emails. Utilize data configuration utility or Excel import for this purpose. 

Thanks

[GaneshT]

This worked when there is single user / account / contact. but fails when there are multiple recipients.

[GaneshT]

There needs some minor changes to data while syncing from one environment to another there by couldn't use these features. .thanks Manish for suggestions

[GaneshT]

thanks JorgeFerr for suggestions

[GaneshT]

Finally did this with C# Plugin code. but still keen on getting solution for multiple recipients in To. 

[ed101]

All I am having the same issue and this doesn't work - when using the array I am getting:

{

  "error": {

    "code": "0x80060888",

    "message": "Syntax error: character '​' is not valid at position 1 in '(​GUID)'."

  }

}

For one record this works as expected.

Any ideas as I don't want to write a c# plugin, looks like a formatting issue or a payload issue.

Sample payloads tried:

{
  "entityName": "emails",
  "recordId": "GUID",
  "item/activitypointer_activity_parties": [
    {
      "participationtypemask": 2,
      "partyid_systemuser@odata.bind": "/systemusers(​GUID)"
    },
    {
      "participationtypemask": 2,
      "partyid_systemuser@odata.bind": "/systemusers(​GUID)"
    },
    {
      "participationtypemask": 2,
      "partyid_systemuser@odata.bind": "/systemusers(​GUID)"
    },
    {
      "participationtypemask": 2,
      "partyid_systemuser@odata.bind": "/systemusers(​GUID)"
    },
    {
      "participationtypemask": 2,
      "partyid_systemuser@odata.bind": "/systemusers(​GUID)"
    },
    {
      "participationtypemask": 2,
      "partyid_systemuser@odata.bind": "/systemusers(​GUID)"
    },
    {
      "participationtypemask": 1,
      "partyid@odata.bind": "queues(GUID)"
    }
  ]}

Or

{
  "entityName": "emails",
  "recordId": "GUID",
  "item/activitypointer_activity_parties": [
    {
      "participationtypemask": 2,
      "partyid_systemusers@odata.bind": "/systemusers(GUID)"
    },
    {
      "participationtypemask": 2,
      "partyid_systemusers@odata.bind": "/systemusers(GUID)"
    },
    {
      "participationtypemask": 2,
      "partyid_systemusers@odata.bind": "/systemusers(GUID)"
    },
    {
      "participationtypemask": 2,
      "partyid_systemusers@odata.bind": "/systemusers(GUID)"
    },
    {
      "participationtypemask": 2,
      "partyid_systemusers@odata.bind": "/systemusers(GUID)"
    },
    {
      "participationtypemask": 2,
      "partyid_systemusers@odata.bind": "/systemusers(GUID)"
    },
    {
      "participationtypemask": 1,
      "partyid@odata.bind": "queues(GUID)"
    }
  ]}

And then without the forward slash. Same deal just can't seem to add more than one recipient.

[ed101]

All this is now solved - for me it was a hidden character space in front of the GUID that caused the issue. Using a tool like https://jsonlint.com/ and paste your payload you will be able to see any hidden characters that you may not have been expecting.

Good luck

And you don't need partyid_systemuser or partyid_systemuser just partid@...