How to send an automated email in Dataverse using Power Automate?

Arun PottiDyn365CE4 days ago135 Views

This is a quite common requirement from the business to send automated emails on some Dataverse record create/ update / delete using Microsoft No Code/ Low Code platform.

In this article, will explain about the below requirement step by step using Power Automate.

Requirement: Send an Email to Customer (Contact) when the contact record is created.

Follow the below steps.

Pre-requisites:

  1. Configure donotreply email using Shared mailboxes in Dynamics 365 CE
  2. Understanding Activity Party Types in Dynamics 365 CE

Step 1: Click on the below link to open Power Automate Maker portal.

https://make.powerautomate.com/

Step 2: Click on Environments, Click on the required Environment.

Screenshot of the Power Automate Maker portal showing options to create flows including Automated cloud flow, Instant cloud flow, and Scheduled cloud flow.

Step 3: Click on the Automated cloud flow.

Power Automate interface displaying options for creating a flow, including 'Automated cloud flow,' 'Instant cloud flow,' 'Scheduled cloud flow,' and various templates. The sidebar shows navigation options like Home, Create, Templates, and My flows, with a highlighted 'Automated cloud flow.'

Step 4: Give the Flow a name. Search for Dataverse. Select the When a row is added, modified or deleted option. Click on Create.

A screenshot of the Power Automate interface, showing the 'Build an automated cloud flow' dialog. It includes fields for naming the flow and selecting triggers from the Dataverse.

Step 5: Click on When a row is added, modified or deleted and choose the below options.

Change type Added
Table name Contacts
Scope Organization
Power Automate interface displaying the setup for 'When a row is added, modified or deleted' trigger with parameters including Change type, Table name, and Scope.

Step 6: Click on + icon to add new Action.

Screenshot of the Power Automate interface showing the parameters for the 'When a row is added, modified or deleted' trigger, including options for Change type, Table name, and Scope.

Step 7: Search for Dataverse Add a new row. Click on Add a new row.

A screenshot of the Power Automate interface showing the action 'Add a new row' in the Dataverse section, with options for various actions listed below.

Step 8: Search for Email Messages Table name. Click on Email Messages.

Screenshot of the Power Automate interface showing the Add a new row action with a dropdown for selecting the Email Messages table.

Step 9: Click on the Drop down of the Advanced parameters.

Screenshot of the Power Automate interface showing the 'Add a new row' parameters for Email Messages.

Step 10: Search for the below parameters and select them. Click outside of the parameters popup once your selection is completed.

Note: If you want to add any other parameters, please select them.

Activity Parties Will set From and To in the Activity Parties
Due Date Give some date
Subject Give some email subject
Description Give some email body
Regarding (Contacts) Give Contact GUID to this email
Screenshot of the Power Automate interface showing parameters for adding a new row, including fields for Activity Parties, Due Date, Subject, Description, and Regarding (Contacts).

Now you can see the list of all selected parameters appearing in the screen.

Screenshot of Power Automate interface showing the 'Add a new row' action for the 'Email Messages' table with parameters for Activity Parties, Description, Due Date, Regarding (Contacts), and Subject.

Step 11: Click on the T icon to switch to Input entire array.

A screenshot showing the 'Add a new row' interface in Power Automate with parameters for Email Messages, including sections for Advanced parameters, Activity Parties, Description, Due Date, Regarding (Contacts), and Subject.

Step 12: Enter the below information.

Participation Type Mask 1 is From field and 2 is To field in the email.

[
  {
    "participationtypemask": 1,
    "partyid@odata.bind": "/queues()"
  },
  {
    "participationtypemask": 2,
    "partyid@odata.bind": "/contacts()"
  }
]

Note: Click here to know more about Activity Party types for Email in Dynamics 365 CE.

Screenshot of the Power Automate interface showing the parameters for adding a new row, specifically the Activity Parties section with JSON details.

Step 13: Click on Switch to details inputs for the array item.

User interface displaying the 'Add a new row' function in Power Automate, showing parameters for Activity Parties.

Changed back to Switch to Input entire array.

Screenshot showing the Power Automate interface with parameters for adding a new row, including fields for Activity Party attributes.

Step 14: Get the Queue Id and Paste in the participationtypemask: 1

Or

You can dynamically retrieve this value from Configuration Entity.

Note: Click on the article link to Configure donotreply email using Shared mailboxes in Dynamics 365 CE.

Power Automate Maker portal interface displaying a queue named 'DoNotReply' along with relevant details like type, incoming email, owner, and description.

Step 15: Give the QueueId in Activity Party participationmask 1.

Place the cursor in the Contacts braces and Click on Insert dynamic content.

Screenshot of the Power Automate interface showing the parameters for adding a new row and configuring activity parties for an email message.

Step 16: Search for Contact and Click on Contact (Unique identifier of the contact).

Interface for adding a new row in the Dataverse with parameters listed.

After insertion,

Screenshot of Power Automate interface showing parameters to add a new row with specified attributes.

Step 17: Enter the below text in the Description field. Place the cursor after Dear . Click on Insert Dynamic content.

Dear ,

Welcome to Arun Potti Corp! We’re excited to have you with us. Stay tuned for updates, insights, and exclusive content. Feel free to reach out with any questions—we’re happy to connect!

Best regards,
Administrator

User interface for adding a new row in Power Automate with parameters labeled, including a welcome email description.

Step 18: Search for Full Name and Click on Full Name.

Screenshot of the Power Automate interface showing the parameters section for adding a new row with various fields.

After insertion,

Screenshot of the Power Automate interface showing the parameters for adding a new row, including recipient details and email body.

Step 19: Place the cursor on the Due Date and Click on Insert Expression.

Screenshot of Power Automate showing the setup for adding a new row with parameters, including activity party, description, and due date.

Step 20: Enter the below expression and click on Add.

utcNow()

Screenshot of the Power Automate interface highlighting the parameters for adding a new row.

Step 21: Give the below text and place the cursor on Regarding (Contacts) in the braces. Click on Insert Dynamic content.

/contacts()

Screenshot showing the parameters for adding a new row in Microsoft Dataverse, including fields for Activity Party, Description, Due Date, and Subject.

Step 22: Search for Contact and Click on Contact (Unique identifier of the contact).

Screenshot of the Power Automate interface with fields for adding a new row, including parameters like Activity Party Attribute Name, Description, Due Date, and Regarding Contact.

After update,

Screenshot of the Power Automate interface showing parameters for adding a new row in the Dataverse.

Step 23: Give the below Subject.

Welcome to Arun Potti Corp!

Screenshot of the Microsoft Dataverse interface for creating a new row in an automated flow, displaying parameters for an email welcome message with fields for activity party attributes, description, due date, and subject.

Step 24: Click on Add a new row and update the Name to Create contact welcome email.

Screenshot of the Power Automate Maker interface showing parameters for adding a new row in the Email Messages table.

After update,

Screenshot of the Power Automate interface showing the configuration for sending a welcome email to a contact, including parameters for 'Email Messages' and 'Activity Parties'.

Step 25: Click on Save and after Save click on + icon to add new action.

Screenshot of the Power Automate interface showing the creation of a welcome email flow with parameters for 'Email Messages'.

Step 26: Search for Perform a bound action and click on it (Microsoft Dataverse -> Perform a bound action).

Screenshot of the Power Automate interface showing options to add a new action.

Step 27: Select the Table name as Email Messages.
Choose the Action Name as SendEmail.
Place the cursor in the Row ID field. Click on Insert Dynamic content.

Screenshot of the Perform a bound action settings in Power Automate, showing parameters for Email Messages and action name SendEmail.

Step 28: Search for Email Message and Click on Email Message (Action: Create contact welcome email).

Interface for performing a bound action in Microsoft Dataverse, with parameters including Table name and Action Name.

After insertion,

Screenshot of the 'Perform a bound action' interface in Microsoft Dataverse, showing parameters for sending a welcome email within an automated flow.

Step 29: Select the Item/IssueSend to Yes.

Power Automate interface showing parameters for sending a welcome email in the Email Messages table.

Step 30: Update the Action to Perform a bound action – Send Email and Click on Save.

Visual representation of creating a flow in Power Automate, showing the 'Perform a bound action - Send Email' parameters for the Email Messages table.

Step 31: Once Power Automate is saved. Go to any Model-driven App. Create a new Contact record to test the welcome email flow.

Note: Make sure to provide the Email address when creating the Contact.

User interface showing the New Contact form in Power Apps with fields for entering contact details such as first name, last name, email, and buttons for saving the information.

You will get the email once the flow executed successfully.

Screenshot showing steps for creating an automated cloud flow in Power Automate.

Hope you have successfully sent the email after creating the contact using Power Automate by following all the above steps.

Please like and share your valuable feedback on this article. Also, follow my blog to get my articles to your Inbox.

Click on the below image to navigate to my YouTube Channel.

Graphic promoting a YouTube channel with the text 'Has my blog post helped you?' and buttons for 'WATCH', 'LEARN', and 'SUBSCRIBE'.

Below are my earlier articles that you can have a look.

Understanding Activity Party Types in Dynamics 365 CE

How to configure donotreply email using Shared mailboxes in Dynamics 365 CE?

Microsoft Power Pages: The authentication key for your portal will expire

Microsoft Azure: You’re not eligible for an Azure free account

How to create Microsoft Azure 30 days trial?

Edit in Visual Studio Code for the Web in Power Apps Portals

Error: The object cannot be updated because it is read-only in Microsoft Power Apps

Resolved: Fix connections issue in Power Automate Flow

Clear all objects feature in Power Apps Solutions

Power Automate Error: The ‘inputs.parameters’ of workflow operation of type ‘OpenApiConnection’ is not valid.

Power Automate Error: To use FilteringAttributes, your trigger must include an Update event on Dataverse Trigger

Dynamics 365 CE Solution Import Failed in Azure DevOps Pipelines

Power Automate Error: Cannot write more bytes to the buffer than the configured maximum buffer size: 104857600

Error while opening a Tool in XRMToolBox

The Power Automate Cloud Flows Best Practices Whitepaper is now LIVE!

Error in Power Automate: There’s a problem that needs to be fixed to trigger this flow. To see more details, open Flow checker.

How to get the Dataverse Table’s first row from List Rows in Power Automate?

Microsoft Dataverse Accelerator – Part 2 – Installation

Microsoft Dataverse Accelerator – Part 1 – Introduction

How to get the Database Version of the Dataverse?

API playground feature not available in Dataverse Accelerator App?

How to Explore and test Dataverse in the Web API playground (preview)?

Web resource method does not exist in Dynamics 365 CE

How to get Environment Variable Value in Dynamics 365 CE using JavaScript?

Model-driven Apps – openAlertDialog – JavaScript – Code Snippet

Power Automate – Flow is not running on Trigger condition

Power Automate – Input field Delete option is disabled

Recipient of type ‘Contact’ with ID is marked as non-emailable

Preferred Solution | New feature | Microsoft Dataverse

New and Retired Microsoft Dynamics 365 Certifications

Environment settings behavior (Preview) feature in Model-driven Apps

Error while connecting to Dataverse environment in XrmToolBox

Power Fx Formula Columns in Microsoft Power Apps

How to Enable 2024 Release Wave 1 Updates in the Microsoft Dynamics 365 CE Environment?

Delete and Restore records (Preview) feature in Microsoft Dataverse

Microsoft Power App Environments Retention Period

How to Override the Model-driven app header colors?

Timeline Highlights (New feature) in Microsoft Power Apps

Model-driven App – Cannot “See associate records” option in the sub grid (arunpotti.com)

Bookmark the Important Dynamics 365 URLs

How to Enable Tenant-level analytics for Power Automate and Power Apps?

Microsoft Power Automate Copy and Paste Action in New DesignerHow to Setup Multi-Factor Authentication for your Microsoft Power Apps environment?

Microsoft Power Apps | Modern Themes | Preview feature

How to Download and Install the .NET Framework?

How to Create a SharePoint Site Online?

How to add and use Copilot answer control (Preview) in Microsoft Power Apps?

Dark Mode in Microsoft Power Apps

How to create Microsoft 365 E3 Trial for 30 days?

Refreshed look of solution dependencies in Dataverse Solutions

Microsoft Power Automate | Version History | Restore | New Feature

MICROSOFT LEARN – Artificial Intelligence Skills Challenge​ 2024!!!

Resolved – ‘InvokerConnectionOverrideFailed’ Error When a Power App Custom Page call a Power Automate Flow

How to Create Microsoft Power Apps Trial 30 days?

Not able to Create Power Automate Flow in Custom Page in Model-Driven App?

How to Enable Inline Actions feature in Microsoft Canvas Apps?

How to use /mention in Outlook web client for Dataverse records?

Associate Activities Multiple Related Records (Preview) feature in Microsoft Dynamics 365 CE

How to Enable Aggregation (preview) feature in Microsoft Power Apps?

Power Apps – Some components of this app require you to sign in. If you don’t sign in, part of the app may not work.

How to Enable the SQL Server stored procedures (preview) feature in the Power Apps?

How to get the Client Version of the Model Driven Apps?

How to get Microsoft 365 E3 Trial for 30 days?

How to Enable Copilot for Model-Driven apps feature in Dynamics 365 CE Environment?

[Resolved] Web resource method does not exist in Dynamics 365 CE JavaScript Error

How to Enable Blocking unmanaged customizations (Preview) feature in Dynamics 365 CE?

How to create Microsoft Power Apps Developer Plan Environment?

Microsoft Power Apps Developer Plan vs Power Apps Trial 30 days

What is Microsoft Power Apps Developer Plan?

[Resolved] PCF Field Control not showing anything in the PCF Test Environment?

[Issue Resolved] ReferenceError: Web resource method does not exist in Dynamics 365 CE Javascript Error

[Issue Resolved] Subcomponent cannot be added to the solution because the root component Template is missing in Dataverse

How to Turn Off the Modern Look in the Model Driven Apps?

How to Turn on the New modern, refreshed look for the Model-Driven apps?

Microsoft Power Apps – Apps filter feature

How to Create Microsoft Power Apps 30 days Online Trial Version and an Environment?

Microsoft Power Apps – Solutions filter Preview feature

How to Show the Power Automate complete Expressions?

Dataverse Error: Cannot start the requested operation [EntityCustomization] because there is another [PublishAll] running at this moment.

Power Automate Error: You should specify a contact or account.

How to get the Choice Text and Value in the Dataverse using JavaScript?

Microsoft Dataverse Low Code No Code Plugins

How to convert the Number String to Number Array?

How to Integrate Instant Plugins in the Power Automate Flow?

Power Apps – ‘actionname’ is an unknown or unsupported function in namespace ‘Environment’

Dataverse Browser V1.1.0.1 is available for Dataverse Plugin Debugging

How to Integrate Instant Plugins in the Canvas App?

How to Enable Access to Microsoft Dataverse Actions (Preview feature) in the Power Apps?

How to Create an Instant Plugin in the Dataverse Environment?

How to Install the Microsoft Dataverse Accelerator in the Dataverse Environment?

What is Microsoft Dataverse Accelerator?

How to get the Logged in User Information in the Power Apps?

How to Install Power Platform Tools in Visual Studio Code?

How to Install the Apps from the Microsoft AppSource to your Dataverse Environment?

Microsoft Power Apps Maker Portal has a new look

Microsoft Power Apps Emulator (New Feature)

How to Enable the Dataverse Offline (Experimental Feature) in the Canvas Apps?

How to set the Authoring Version in the Canvas App?

New version of Dataverse Browser is available for Dataverse Plugin Debugging

Latest Free Practice Assessments for Microsoft Certifications

Download CRM 365 V9.X Tools using PowerShell

How to set the Refresh cadence for a Power Platform Environment?

Update forms and views (Preview feature) in Dataverse

How to connect to Microsoft Dataverse in Power Automate Flow using Service principal?

How to Enable Copilot (Preview) feature in Canvas Apps?

How to Debug a Dataverse Plugin without Installing the Profiler in the Plugin Registration Tool?

How to Enable the Licenses (Preview) feature for a Power Platform Environment?

How to Enable Maker Welcome Content (preview) in Power Apps Maker Portal?

How to Enable Managed Environments for a Dataverse Environment?

How to Enable the Modern Controls (Preview feature) in the Canvas Apps?

How to Enable 2023 Release Wave 1 updates in the Dataverse Environment?

How to Deploy Enterprise Applications in the new Dataverse Environment?

What is Preview, Experimental and Retired features in Canvas Apps?

How to Enable the New Power Fx Formula Bar in Power Apps Studio?

Writing Power Fx formulas with natural language

Power Fx Formula Columns in Dataverse

Generating Power Fx formulas from examples

How to Create Dynamics 365 Marketing 30 Days Trial Version Online?

How to disable Multi-Factor Authentication (MFA) on Dynamics 365 Login?

How to Create Microsoft Power Apps 30 days Online Trial Version and an Environment?

Original Post https://arunpotti.com/2025/05/31/how-to-send-an-automated-email-in-dataverse-using-power-automate/

0 Votes: 0 Upvotes, 0 Downvotes (0 Points)

Leave a reply

Top Headlines
    Join Us
    • X Network2.1K
    • LinkedIn3.8k
    • Bluesky0.5K
    Support The Site
    Events
    June 2025
    MTWTFSS
           1
    2 3 4 5 6 7 8
    9 10 11 12 13 14 15
    16 17 18 19 20 21 22
    23 24 25 26 27 28 29
    30       
    « May   Jul »
    Follow
    Sign In/Sign Up Sidebar Search
    Loading

    Signing-in 3 seconds...

    Signing-up 3 seconds...