Hello everyone and welcome to my blog. In today’s blog we are going to learn on how to execute DataVerse actions using transaction scope in Power Automate flow.
Through my blog I share interesting tips and discuss on latest releases of Microsoft.NET technologies, Dynamics 365 and Power Platform, SharePoint and Client scripting libraries. Please subscribe to my blog to stay updated.
Power Automate have a large set of actions for Microsoft DataVerse. Once of such action is the ‘Perform a changeset request‘ action.
The quick tip pane for the action, in the above picture explains the purpose as it mentions that the action can perform a group of Microsoft DataVerse connector operations in a single transaction.
Let’s select the action. Once you select the action, you should be able to select from the list of available DataVerse actions which are supported inside transaction scope.
As you can see only three operations are supported within a Changeset request, as of the time of writing this blog – Create, Update and Delete.
Let’s complete this example. I have added three actions here.
- A create action to create a contact record
- A delete action to delete the parent company associated with the contact.
- An Update action to update the contact details.
Below is an illustration of the completed flow.
All the three operations are atomic. Either all will pass or all will fail.
Few things to note here.
- Nested actions of changeset scope are not allowed to reference actions in the same scope. If you observe the pic above, there is no arrow connecting the actions. None of the DataVerse action in the Changeset scope are connected.
- As mentioned earlier, the Changeset scope only support three DataVerse action – Create, Update and Delete.
Hope this helped. For more interesting topics on Microsoft .NET, Dynamics 365 and Power Platform, you can subscribe to my blog.
Debajit Dutta
Business Solutions MVP