I've spent some time trying to create a publish approval flow for SharePoint documents. What I have eventually come up with is a manually initiated flow, which I hope is a useful stop-gap until a publish trigger is released.
This flow does not publish the document before it has been approved - the initial set content approval is for submit, which sets the status to pending. Depending on the approve/reject decision, the relevant approval status is then set.
No. The ETag is there to check that the document being approved is the same version that was submitted for approval - i.e. not a subsequent draft.
I will try and find some time to write up what it's actually doing.
in My case it doesn't work : I've created a simple doc lib with approval
When I add a new document in the library the flow runs and succeed
But the status is still "Pending" even tough the Flow changed it to Approved...
This will generate an error when the document status is already pending. Before the you set the approval status to "pending" there should be a condition to check whether it's already in pending status or not. Unfortunately I can't find any Flow action to get the current approval status.
This link looks to hold the answer for setting the approval status to approved from pending.
Fill out a quick form to claim your user group badge now!
We've given our badges an overhaul and also added some brand new ones!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!