Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

Sending CDS Email ACtivity from Power Automate

(0) ShareShare
ReportReport
Posted on by 817

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.

Radoslavov_0-1613636334876.png

Power Automate gets this emails and separates them as individual values

Radoslavov_1-1613636416088.png

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

Radoslavov_2-1613636582243.png

So the email structure should be like this:

 

From is the queue inside the case

Radoslavov_3-1613636637913.png

The subject is the Case title

To is the customer

Radoslavov_4-1613636677524.png

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. 

Radoslavov_5-1613637091641.png

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

 

  • Verified answer
    MJain Profile Picture
    2,450 on at
    Re: Sending CDS Email ACtivity from Power Automate

    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

  • Radoslavov Profile Picture
    817 on at
    Re: Sending CDS Email ACtivity from Power Automate

    it's a queue.

    Radoslavov_0-1614336210701.png

    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 

    Radoslavov_1-1614336249888.png

    very weird.

    This is the step configuration

    Radoslavov_2-1614336300079.pngRadoslavov_3-1614336328526.png

     

  • MJain Profile Picture
    2,450 on at
    Re: Sending CDS Email ACtivity from Power Automate

    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

  • Mira Ghaly Profile Picture
    11,409 Super User 2025 Season 1 on at
    Re: Sending CDS Email ACtivity from Power Automate

    @Radoslavov

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

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

     

  • Radoslavov Profile Picture
    817 on at
    Re: Sending CDS Email ACtivity from Power Automate

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

  • Mira Ghaly Profile Picture
    11,409 Super User 2025 Season 1 on at
    Re: Sending CDS Email ACtivity from Power Automate

    @Radoslavov

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

     

  • Radoslavov Profile Picture
    817 on at
    Re: Sending CDS Email ACtivity from Power Automate

    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.....

  • MJain Profile Picture
    2,450 on at
  • Mira Ghaly Profile Picture
    11,409 Super User 2025 Season 1 on at
    Re: Sending CDS Email ACtivity from Power Automate

    @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

    Mira_Ghaly_0-1613651700995.png

     

  • Radoslavov Profile Picture
    817 on at
    Re: Sending CDS Email ACtivity from Power Automate

    Sure, here it is

    Radoslavov_0-1613648943920.png

     

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

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1