1/31/2023

---

The Why

In a MDA the need to move a business process forward without have a user do anything is a great feature. This guide will show how to move a BPF forward using Power Automate when a change occurs us. I used Power Automate vs the client side java script so I could tie the action into notifications. This BPF is built in a way that each step is done by a different party, so the need for immediate change was not needed.

The How

This flow will be built using a modify for a Dataverse table

Create a new flow, configure the trigger to be a Dataverse modify

💡 Its is recommended to use the select columns for this action so only one column is watched.

Use a List rows action and find the BPF associated with the table

💡 This solution is using an Activity table as an example

The Filter rows will be the ID from the trigger

_bpf_triggertable_value eq '@{triggerOutputs()?['body/activityid']}'

Now you need to get the process ID for the business process flow

Get Stage ID for Business Process Flows

Once you have the stage ID you need, create a variable with the string in it

Add a update Row action

For the row ID use a First to filter and avoid a loop

first(outputs('List_rows_-_BPF')?['body/value'])?['businessprocessflowinstanceid']

Use the format for Active Stage to select the new business process step.

Resources