Others

How to Create an Approval for an Entire Microsoft List with Power Automate

Kushani Nimanthika Oct 12, 2026 869 views

Question details

The user needs to create a comprehensive approval workflow and record the final approval status for an entire Microsoft List, rather than processing approvals for individual list items.

How to Create an Approval for an Entire Microsoft List Using Power Automate

Product: Power Automate / Microsoft Lists
Device & OS: not provided
Scenario: Setting up an overarching approval process to review and sign off on a complete dataset within a Microsoft List.
Observed behavior: Default Power Automate approval triggers apply only to individual list items, requiring a custom workflow approach to treat the entire list as a single entity for approval.

Before you start

Ensure you have permission to edit the Microsoft List structure and access to create custom instant or scheduled cloud flows in Power Automate.

Solution 1Recommended

Build a Custom Workflow for List-Level Approvals

Create a custom Power Automate flow with an independent trigger and a dedicated tracking record to manage the entire list's approval status.

Because default Power Automate approval triggers are designed to fire for individual items, triggering an approval for an entire list requires a different approach. You must create a custom workflow utilizing a manual or scheduled trigger, and maintain a separate record to log the final overarching approval details.

Create a master tracking record

In your Microsoft List (or a separate master list), set up dedicated columns to record the overall approval data. You will need columns for 'Overall Approval Status', 'Approver Name', and 'Approval Date'.

Set up a custom trigger

Open Power Automate and create a new flow. Choose 'Instant cloud flow' to manually trigger the approval when the list is complete, or use a 'Scheduled cloud flow' to run it at a specific time.

Configure the Approval action

Add the 'Start and wait for an approval' action. In the 'Item link' field of the approval details, insert the URL of your entire Microsoft List so the approver can review the complete dataset.

Update the tracking record

Add a condition step based on the outcome of the approval. Use the 'Update item' action to write the final approval status, approver's name, and timestamp back to the master tracking record you created in Step 1.

Consult the community for advanced logic

If you need to incorporate complex looping across list items or advanced Power Platform designs, visit the official Microsoft Power Platform Community forums for expert workflow templates.

Build a Custom Workflow for List-Level Approvals

Advanced Design Requirements: Managing whole-list approvals often requires custom workflow mapping. If your scenario involves locking the list to prevent further edits after approval, you will need to add SharePoint permission actions to your flow.

Free Microsoft Office alternative

Looking for a Simpler Way to Manage Data and Documents?

While Power Automate and Microsoft Lists handle complex enterprise workflows, if you simply need to manage spreadsheets, track data, and handle documents efficiently, try WPS Office. It is a highly compatible, free alternative to Microsoft Office that is lightweight and incredibly easy to use.

1. Download WPS Office: Visit the official WPS Office website and download the free installation package for your operating system.
2. Install the application: Run the downloaded installer and follow the simple on-screen instructions to set up the software.
3. Open your files: Launch WPS Office and directly open your existing Microsoft Office documents and spreadsheets to start working seamlessly.

Fully compatible with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint (.pptx) formatsLightweight application that runs smoothly on almost any deviceFamiliar user interface ensuring seamless migration with zero learning curveBuilt-in PDF toolkit for quick document reviewing and digital signing

microsoft office alternative - wps office

Frequently Asked Questions

Why isn't there a default Power Automate trigger for an entire Microsoft List?

Power Automate triggers for Microsoft Lists are primarily designed for row-level or item-level data processing. Treating an entire list as a single entity requires custom logic to define when the list's data entry is considered 'complete' and ready for a bulk review.

Can I trigger an approval for multiple selected list items at once?

Yes, you can use the 'For a selected item' trigger combined with a 'For each' loop in Power Automate. However, by default, this will still generate individual approval requests for each selected item unless you specifically aggregate the data into a single custom approval message.

How can I prevent users from editing the Microsoft List after it has been approved?

You can add an HTTP request action or use advanced SharePoint actions within your Power Automate flow to automatically change the list or item permissions to 'Read-Only' once the overarching approval status is marked as approved.

Office Quick Solutions