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