Introduction
Power Automate enables no-code/low-code workflow automation. In this tutorial, you'll build a multi-stage approval workflow that integrates with SharePoint and Microsoft Teams.
Step 1: Set Up the SharePoint List
Create a SharePoint list with columns for request details, status, approver, and comments. This serves as the data source for the workflow.
Step 2: Create the Flow Trigger
Set up a Power Automate flow that triggers when a new item is created in the SharePoint list.
Step 3: Configure the First Approval Stage
Add a "Start and wait for an approval" action. Configure the approval type (Approve/Reject), assignees, and details.
Step 4: Handle Approval Responses
Use a condition to check the approval outcome. Route the flow to different branches for approved and rejected requests.
Step 5: Add a Second Approval Stage
For approved requests, add a second-level approval with a different set of approvers (e.g., management chain).
Step 6: Send Teams Notifications
Integrate Microsoft Teams to send notifications at each stage — submission confirmation, approval/rejection notices, and final status.
Step 7: Add Reminder Logic
Configure a parallel branch with a delay to send reminder notifications if an approval is pending for more than 48 hours.
Step 8: Update SharePoint & Send Summary
Update the SharePoint list item with the final status, approver comments, and timestamps. Send a summary email to all stakeholders.
