Power Automate- trigger an approval flow from a change in a field

Occasional Visitor

Hi community, 

 

I am in need of some assistance with a flow/group of flows I am trying to create. We require a system whereby an approval flow is triggered when an item is created (using the 'when an item is created' trigger. This flow will then update the status of an item to be 'approved' or 'rejected'. This part, we are comfortable with. 

 

We then need the next flow to be triggered by the update in status. So when the item is showing a status as 'approved' we want this to trigger another approval loop. On power automate, I can't find a way for a new flow to be triggered from a change in circumstance of an item. Is there a way to do this or does anyone know of a workaround we can use?

 

Please see picture below for further clarification.

 

Thanks in advance!

 

Screenshot 2022-01-13 at 10.50.30.png

1 Reply

@joelosi your trigger needs to be when an item or a file is modified and the first action is get changes for an item or a file (properties only). But because you are comparing the current version of the status column to the previous version you MUST turn on item version history in your List Settings  -> Versioning Settings

 

 

0-SPList-Versioning.png

 

1-Flow.png

 

The Since field is where you add the expression to compare the current version with the previous one:

 

sub(int(triggerOutputs()?['body/{VersionNumber}']),1)

 

2-Flow.png

 

You need to check not only if the Status column has changed but also if the value is now Approved or Completed or whatever value you are using:

 

3a-Flow.png

 

The status column in my list is a choice so if that's the same with you select Status Value, not Status, from the dynamaic content box:

 

3b-Flow.png

 

4-Flow.png

 

5-SPList-StatusChanged.png

 

6-SPList-Completed.png

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User