Others

How to Create Multi-Stage Approval Workflows with Microsoft Lists and Power Automate

Maira Mehtab Sep 20, 2026 868 views

Question details

The user needs to set up a comprehensive workflow to manage task assignments, timelines, multiple approval stages, document uploads, rework requests, and manager alerts for overdue items.

Product: Microsoft Lists and Power Automate
Device & OS: not provided
Scenario: A decoration company requires an automated system to track complex project stages and approvals across their organization.
Observed behavior: The user wants to implement this solution efficiently using their existing Power Automate availability alongside Microsoft Lists or Planner.

Before you start

Ensure you have an active Microsoft 365 subscription with access to Microsoft Lists, Power Automate, and SharePoint, and map out your required approval stages before building the workflow.

Solution 1Recommended

Build a Multi-Stage Approval Workflow using Microsoft Lists

Use Microsoft Lists as the main database to track task statuses and trigger automated approval flows via Power Automate.

While Microsoft Planner is excellent for basic Kanban task management, Microsoft Lists is highly recommended for multi-stage approvals. Lists provides a customizable interface where you can track statuses, assignees, and link documents, seamlessly triggering complex Power Automate logic.

Create a New List in Microsoft Lists

Set up a new List with specialized columns for Task Name, Assignee, Due Date, Status (e.g., Pending, In Progress, Review, Approved, Rework), and a hyperlink column for Document Uploads.

Set Up Document Storage

Create a SharePoint Document Library to store all project-related files. Employees will upload their completed documents here and paste the shareable link into the Document Uploads column in Microsoft Lists.

Create the Primary Power Automate Flow

Open Power Automate and create an 'Automated Cloud Flow'. Choose the trigger 'When an item is created or modified' and connect it to your newly created Microsoft List.

Add Approval Actions

Add the 'Start and wait for an approval' action to your flow. Configure condition logic so that when a list item's Status changes to 'Review', an approval request is automatically routed to the project manager.

Configure Rework and Overdue Alerts

Add condition branches to update the list item Status to 'Rework' and email the assignee if an approval is rejected. For overdue alerts, create a separate 'Scheduled Cloud Flow' that runs daily, fetching items past their Due Date and emailing manager alerts.

Workflow Optimization: Using SharePoint libraries for document storage rather than List attachments ensures better version control and file size management during the rework process.

Free Microsoft Office alternative

Manage Project Documents Easily with WPS Office

While Power Automate handles your complex automated approvals, WPS Office provides a lightweight, comprehensive suite for creating, editing, and managing the project documents and spreadsheets required for your workflows. It is highly compatible with Microsoft Office formats, ensuring seamless integration with your SharePoint libraries.

1. Download and Install WPS Office: Get the free WPS Office suite from the official website and install it on your device.
2. Create Project Documents: Use WPS Writer or Spreadsheet to draft project proposals, timelines, and forms required for your workflow.
3. Save and Upload: Save your files in standard Microsoft formats (.docx, .xlsx) and upload them to your SharePoint library to link with your Microsoft Lists.

Free, lightweight, and incredibly easy-to-use office suiteFully compatible with Microsoft Word, Excel, and PowerPoint formats (.docx, .xlsx, .pptx)Built-in PDF editing tools ideal for managing project contracts and approvalsSeamless collaboration and seamless document sharing

Frequently Asked Questions

Can I upload documents directly to a Microsoft List instead of SharePoint?

Yes, Microsoft Lists allows you to add attachments directly to list items. However, for larger projects with multiple files or rework cycles, storing documents in a SharePoint Document Library and linking them to the list item offers better version control and organization.

How do I trigger alerts for overdue tasks in Power Automate?

You can create a 'Scheduled Cloud Flow' in Power Automate that runs daily. Use the 'Get items' action to fetch list items where the Due Date is less than today's date and the Status is not 'Approved' or 'Completed', then add an action to send an email alert to the manager.

Is Microsoft Planner better than Lists for multi-stage approvals?

Microsoft Planner is excellent for simple, visual task management using boards. However, Microsoft Lists offers far greater customization through columns, metadata, and tighter integration with complex Power Automate conditional logic, making it much better suited for multi-stage approvals and rework cycles.

Office Quick Solutions