Forum

Please or Register to create posts and topics.

Send Trailing Follow-Up email in Microsoft Dynamics 365 CRM using Power Automate Flow

Microsoft Dynamics 365 CRM allows users to send an Email to any recipient through Power Automate Flow. Recently we received a requirement to send a follow-up email that should be trailing mail for the previous email after 2 days of New Opportunity.

So, to fulfill this requirement, we have used Power Automate Flow to create an email to be sent as a Follow up trailing email in Microsoft Dynamics 365 CRM.

In this blog, we will walk through the steps for sending a trailing follow-up email after 2 days of Opportunity Creation to the respective Customer.

Step 1: When Opportunity is created we will be sending an initial Email to the Customer and after 2 days there will be a trailing follow-up email sent to them. Let us start with developing a Power Automate flow in Microsoft Dynamics 365 CRM.

Now navigate to https://make.powerapps.com environment and Create a solution for Power Automate Flow.

Step 2: Create a new Automated Flow with triggering action as “Row is Added, Modified or Deleted” as shown in the below screenshot.

Power Automate Flow

We will select Change Type as Added and Table Name as Opportunities for our requirement. Check in the screenshot below.

Power Automate Flow

Step 3: On creation of Opportunity will first send an initial mail to the customer (i.e. Account) of the Opportunity, so add a step to create an Email Message by selecting Add a row step and selecting Email Messages entity with the below details of the email.

  • From: Created By of the Opportunity
  • To: Account of the Opportunity
  • Subject: Add a subject based on your requirement
  • Description: Add an email content message
  • Regarding: Set Opportunity reference so that the email conversation will be respected to Opportunity and available in the Timeline of Opportunity record in Microsoft Dynamics 365 CRM

Please refer the screenshot below for reference emails created in the power automate flow step.

Power Automate Flow

Step 4: Once the email is created will add a “Send Email” bound action step in Power Automate flow which will send an email message to Account.

Add a Perform a Bound Action step and select the below details within this step.

Table Name = Email Message

Action Name = “SendEmail”

Row ID = Unique Identifier of Email Message created in the previous step

IssueSend = Yes

Find screenshot below

Power Automate Flow

Step 5: We have sent an initial mail so will wait for 2 days and send a follow-up email to the Customer.

Add a Delay Step in power Automate with Count as 2 and Unit as Day as seen in the screenshot.

Power Automate Flow

Step 6: Now to create a new email, add a step “Add a new Row” and select Email Message Table Name with the below-listed details in the email message:

  • From: Created By of the Opportunity
  • To: Account of the Opportunity
  • Subject: Add a subject based on your requirement
  • Description:

Email content of current follow-up Email

——————- Original Message ——————-

From: Sender’s Email

Sent: Sent On of the previous email

To: ‘torecipients’ of the previous email

Subject: subject of the previous email

Description of the previous email

  • Regarding: Set Opportunity reference so that the email conversation will be respected to Opportunity and available iTimelinene of Opportunity record in Microsoft Dynamics 365 CRM
  • Following: Yes
  • Parent Activity: /emails(<Guid of Previous Email Message>)

Power Automate Flow

Step 7: Add a Perform a bound Action step for sending the Follow-up Email to the Account of the Opportunity.

Power Automate Flow

We have completed developing the power automate flow now save the flow and test the functionality by creating a new Opportunity in CRM.

Power Automate Flow

You can check in Outlook the email will be received as shown below screenshot,

Power Automate Flow

Conclusion

In this way, we can customize the process of sending a follow-up email as a trail mail to the previous email using Power Automate Flow.