The process of building custom applications and tools that interact with Microsoft SharePoint, including SharePoint Online in Microsoft 365.
Hi Diane,
Regarding your concern, you can build this as a single Power Automate flow:
- In your SharePoint document library, create a Person or Group column named "First-stage approvers" and allow multiple selections.
- Create an automated cloud flow using the trigger "When a file is created or modified (properties only)".
- Add "Start and wait for an approval":
- Approval type: Approve/Reject – Everyone must approve
- Assigned to: Select the Email value from the First-stage approvers column.
- Include the document name and link in the approval details.
- Add a condition to check whether the first approval outcome is Approve.
- In the Yes branch, add another Start and wait for an approval and assign it to your email address for final approval.
- Add another condition for the final approval outcome.
- If approved, update the SharePoint document status to Approved.
- If rejected, update it to Rejected or return it for revision.
- In the first-stage No branch, update the document status to Rejected.
For references:
- Create an approval flow that requires everyone to approve - Power Automate
- Manage sequential approvals with Power Automate - Power Automate
This keeps both approval stages in the same flow, and the document is not marked Approved until the final approval is completed. The first approval can require approval from every assigned reviewer before the flow continues. Also, to avoid the flow triggering itself repeatedly when it updates the document, you may need to add a status column or trigger condition so that the flow starts only when the document is submitted for approval.
Hope this will help. Should you have any other questions, please feel free to share them in the comments on this post. I'm happy to assist you further.