Changeset Request in the Dataverse Connector | Power Automate

 

Perform a Changeset Request in Power Automate

Introduction:

For those already leveraging the power of Microsoft Power Automate, exploring advanced features and connectors can significantly enhance their workflow automation capabilities. In this blog post, we will dive into the world of changeset requests in the Dataverse connector, empowering Power Automate users to streamline data management processes and achieve greater efficiency.

 

What is a Changeset Request?

A changeset request allows you to group multiple create, update, and delete operations within a single transaction. This ensures that all the changes in the request are committed successfully, or none of them are applied, maintaining data integrity and consistency. Changeset requests offer a powerful way to manage related data changes as a single unit of work.

Demo:

Creating a Demo Flow with Changeset Requests:

Step 1:

Go to https://make.powerautomate.com/

Step 2:

Click on "Create" from the left navigation bar

Step 3"

Click on "Instant Cloud Flow"

Step 4:

a) Give your Flow a name

b) Select "Manually trigger a Flow"

c) Click in "Create"

Step 4:

Click on "New Step"

Step 5:

a) Search "Changeset Request"
b) Select the following action:

Step 6:

a) Click on "Add an action"

b) As you can see these are the following actions that can be preformed inside a changeset request action.

Note:

Please note that the Outputs of the Changeset request itself or even within the steps within a changeset request cannot be captured or referred to in Dynamic Content.

Step 7:

Lets Add two demo actions:

When this Flow runs, for example, if the Contact creation fails, the Account creation too will be rollbacked unlike having these steps outside of the “Perform a changeset request” action.

Hope you like this blog, Thanks for reading.