Power Automate Dataverse Add New Row

by

    In this Dataverse tutorial, We will discuss Power Automate Dataverse Add New Row. That means, how we can add a new row in Dataverse using Power Automate.

    Also, we’ll explore how to use Power Automate to send a user a successful message after the row has been added to the Dataverse table.

    Recently, I had a task where I needed to use Power Automate to automatically add a new row to a Dataverse table.

    Also, Read: How to Update a Row in Dataverse Using Power Automate

    Power Automate Dataverse Add New Row

    Consider the scenario where you want to add a new record to a Dataverse Table without doing it manually one by one. In that case, Power Automate can be used to help you add a new row to the Dataverse table whenever an action takes place. Let’s follow the example below to know more details.

    Scenario:

    Below represents a Dataverse table named IT Issue Resolutions. This custom table has the below fields with various data types. Such as:

    1. Sender = This is the Dataverse Primary Column name with the Text data type
    2. Issues = Single line of text data type
    3. Report Date = Date Data type
    4. Status = Choice Column having some choices like Approved, Rejected, Pending, etc.
    Power Automate Dataverse Add New Row
    Power Automate Dataverse Add New Row

    Now I want to build a flow where, when a user reports an issue via email, all the issue information is automatically stored in a specific Dataverse table (IT Problem Resolutions). And at the same time, the specific sender will get a success notification once the particular record has been added to the Dataverse Table. To do so, follow the instructions below.

    Step – 1: [Create a new Automated cloud flow]

    • Open Power Automate and Sign in with your valid Microsoft credentials.
    • Go to + Create (from the left navigation) -> Select Automated cloud flow under the Start from blank section.
    Create a new row in Dataverse using Power Automate
    Create a new row in Dataverse using Power Automate

    Step – 2: [Provide Flow name and Choose the trigger]

    • Then the below window will appear where you need to provide the flow name and choose the flow trigger.
      • Flow name = I have given the flow name as Dataverse Add New Row From Email.
      • Choose your flow’s trigger = Search or select the trigger from the list below to create a flow. In my case, it’s When a new email arrives (V3).
    • Click on Create.
    Create a new row in Dataverse using Flow
    Create a new row in Dataverse using Flow
    • Once the flow has been created, the trigger will appear as shown in the screenshot below. You can just rename it to “When a new issue arrives“.
    Add a new row in Dataverse table using Flow
    Add a new row in Dataverse table using Flow

    Step – 3: [Insert Dataverse Add a new row action]

    • Next, click on the + icon to insert a new step below the trigger (When a new issue arrives).
    • Search Add a new row in the search bar -> Select Microsoft Dataverse -> Click on Add a new row (PREMIUM) under the Actions tab.
    Power Automate Dataverse add a new row
    Power Automate Dataverse add a new row
    • Just rename the action Add a new row to Add new issue in Dataverse. Also, enter the details below:
      • Table name = Select the IT Issue Resolutions table using the dropdown menu.
      • Sender = Select the field -> Go to Dynamic content -> Click From under When a new issue arrives.
      • Issues = Select the field -> Go to Dynamic content -> Click Subject under When a new issue arrives.
      • Report Date = Select the field -> Go to Dynamic content -> Click Received Time under When a new issue arrives.
    How to add a new row in Dataverse using Power Automate
    How to add a new row in Dataverse using Power Automate

    Step – 4: [Add Send an Email action]

    • Then, click on the + icon to insert a new step below the Dataverse add a new row action.
    • Search Send an email in the search bar and add Send an email (V2) under the Actions tab.
    How to add a new row in Dataverse using flow
    How to add a new row in Dataverse using flow
    • Expand the action and apply the below field values:
      • To = Select the field -> Go to Dynamic content -> Select From under the When a new issue arrives.
      • Subject = Provide any subject line that you want to mention in the mail.
      • Body = You can describe your body details like the respective issue has been submitted Successfully.
    Add a new row in Dataverse using flow
    Add a new row in Dataverse using flow
    • You can take the Issues field from the Dynamic content -> Add new issue in Dataverse action.
    How to add a new row in Dataverse table using flow
    How to add a new row in Dataverse table using flow

    Step – 5: [Save and Test the flow]

    • Finally, save the flow. Also, click the Flow checker and check if any issues are there.
    • If yes, then fix it, and If not, then proceed to Test the flow. Click on Test.
    Power Automate insert a row in Dataverse
    Power Automate insert a row in Dataverse
    • In the Test Flow pane, select Manually and click on Test as shown below. To see whether the flow works or not, you need to send a new email to your inbox.
    • For this purpose, I have used another user (Sonam) and sent a mail to my inbox.
    Power Automate add a new row in Dataverse
    Power Automate add a new row in Dataverse
    • After a while, the flow will run successfully and a notification will appear at the top of the flow like “Your flow ran successfully“.
    Dataverse Add a New Row using Flow
    Dataverse Add a New Row using Flow

    Step – 6: [Refresh Dataverse Table]

    • Now come back to the relevant Dataverse table (IT Issue Resolutions) and refresh it once. You can view the new item that has been added to the Dataverse table in the below image.
    Dataverse add a new row using Power Automate
    Dataverse add a new row using Power Automate
    • Also, at the same time, the sender will get a submitted notification that “Request has been Submitted” as shown in the screenshot below.
    Power Automate Add new row in Dataverse
    Power Automate Add new row in Dataverse

    This is how we can work with Power Automate Dataverse Add New Row.

    Furthermore, you may like some more below Dataverse tutorials:

    In this Dataverse tutorial, We discussed Power Automate Dataverse Add New Row. That means, how we can add a new row in Dataverse using Power Automate.

    Also, we saw how to use Power Automate to send a user a successful message after the row has been added to the Dataverse table.

    >