Change sets feature

To understand this feature better, Lets take an example of Banking transactions.

I am from India . Currently working in Netherlands. I usually transfer money from my NL account to IND account almost every month.

Deduction from my NL account and Credit into my IND account are part of a single transaction.

What does it mean ?

It means that if any failure occurs in between deduction and credit , the whole action should be rolled back.

This is called Atomicity. Atomicity is part of the ACID model (Atomicity, Consistency, Isolation, Durability), which is a set of principles used to guarantee the reliability of database transactions.

This should be one of basic features of any component that can do database transactions including Power Automate/Flow. However I didn’t find this before (correct me if I am wrong).

No worries !!

As part of 2019 release wave 2,Microsoft has recently announced that Change Set feature has been added to the Power Automate designer so that users can replace classic Common Data Service workflows that previously needed atomic transactions.

Resources:

Microsoft docs: https://docs.microsoft.com/en-us/power-platform-release-plan/2019wave2/power-automate/automated-flows-support-change-sets-common-data-service

Note : General availability of change set feature will be in Nov,2019.

Blog Article:  https://powerofpowerplatform.com/power-automate-change-sets-feature/