I have created an approval flow that is triggered "when a file is created or modified (properties only)" using a trigger of
@equals(triggerOutputs()?['body/{ModerationStatus}'],'Pending')
The above trigger doesn't appear to be working and as it passes through all documents in the library regardless of moderation status, e.g. draft etc.
In the "get files (properties only)" I've had to add a filterby query of OData__ModerationStatus eq 'Pending' to overcome the issues above. The resto f the flow works correctly and is sending out approvals as expected. However, whenever a file is created or modified it is triggering the flow and sending out another approvals instance. This results in multiple approvals for the same document which I want to avoid, is there a way to stop this?
Additional stages of the flow.
WarrenBelz
146,660
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,999
Most Valuable Professional