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