Sending CDS Email ACtivity from Power Automate

[Radoslavov]

Hi all,

I'm trying to send a CRM email from Power Automate, but I'm having a problem building the logic so I'm looking for some assistance. 

This is the scenario:

Inside CDS I have a field containing email addresses (it is a text field), these are normally emails of people that will also be placed in the CC of the email.

Power Automate gets this emails and separates them as individual values

what I'm trying to do now is to send a new CRM email associated with a case record.

The trigger of the flow is when a case is created.

Inside the case, I have the From queue stored in a lookup filed, and I also have the customer (contact).

For both entities, I'm listing them in the flow so I can get their properties such as

So the email structure should be like this:

From is the queue inside the case

The subject is the Case title

To is the customer

and in CC or at least in the TO again, must have the additional email addresses contoso1@, contoso2@, etc. 

I've tried using the create record and point to the Email message entity but there was a couple of problems:

1. neither the From and the TO fields were populated. 

2.  I don't have a CC filed in Power Automate in the email message entity

3. I'm not sure how to add each item from applying to each step (which represents different email addresses)into the CRM email entity. They are in append to array step, but CRM needs an email party or something like that, or it will accept them as they are?

Looking forward to any proposals.

Regards

Kiril

[Mira_Ghaly]

@Radoslavov 

1. Are you using the CDS (Current Environment Connector)?

3. you need to set as activity party,

[Radoslavov]

Hi @Mira_Ghaly ,

thanks for looking into this.

I'm actually using CDS only, not the (current environment) one.

[Radoslavov]

So. I set CDS (current environment) like the screenshot you send.

The FLow fails to say that: Queue With Id = 8724de58-de5f-e711-80e2-3863bb349ac0 Does Not Exist

but that is actually not true.

this is the list queue output

3. you need to set as an activity party- how can this be done from Power Automate? As I've never done this before, how to use the apply to each to convert each value to an activity party

Many thanks for the help.

Kiril

[Mira_Ghaly]

@Radoslavov 

No. 3 no Ididn't mean , to create row of type activity party sorry for confusion; I meant you can't pass it as arrays of strings

Can you add a screenshot of the create email message?

[Radoslavov]

Sure, here it is

[Mira_Ghaly]

@Radoslavov 

I am not sure what is the issue with the queue, can u add the value of Queue u are passing to a compose data operation for troubleshooting.

but for contact you should use contact id in place of email below

[ManishJain]

Hi @Radoslavov ,

Following urls might help you resolve the issue :

http://benitezhere.blogspot.com/2020/04/sending-an-email-from-a-queue-with-power-automate.html

https://www.crmsoftwareblog.com/2020/01/send-dynamics-365-emails-from-power-automate/

https://www.briteglobal.com/blogs/community/send-bulk-email-flow-to-all-customers/

Thanks

[Radoslavov]

Nope, still getting error message queue doesn't exist although it does as I can see it from the previous step.

I even used triggerOutputs()['body']['_newcreatedbyteam_value']

and stil lget the error Queue doesn't exist.

I don't know why they make it so difficult to send a simple email from Power Automate using CDS, and MS is planning to remove the D365 Workflows one day, pffff.....

[Mira_Ghaly]

@Radoslavov

From inside D365 have u tried sending email from this queue. 

[Radoslavov]

Yes, from CRM we are sending emails every day, but due to new requirements, I need to automate it from Power Automate.

[Mira_Ghaly]

@Radoslavov

I even used triggerOutputs()['body']['_newcreatedbyteam_value']

This looks like a team not queue so try using teams/yourguid

[ManishJain]

Hi @Radoslavov ,

In order to set party id correctly you need to use  : 

“partyid_<entitylogicalname>@odata.bind”: “/<entitysetname>(<guid of the record>)”,

in this case you are using queues :

"partyid_queue@odata.bind":"/queues(GUID)"

Thanks

[Radoslavov]

it's a queue.

dynamics.com/main.aspx?appid=ec88f958-d1f0-e911-a812-000d3abaae50&forceUCI=1&pagetype=entityrecord&etn=queue&id=8724de58-de5f-e711-80e2-3863bb349ac0

But MS flow still giving me 

very weird.

This is the step configuration

[ManishJain · Accepted solution]

Hi @Radoslavov ,

Can you please confirm if you are able to send mail via this queue and configured it correctly. Please follow the steps from this url to see if it is done correctly:

http://benitezhere.blogspot.com/2020/04/sending-an-email-from-a-queue-with-power-automate.html

Thanks