Others

How to Create a Power Automate Planner Task from a Microsoft List

Olivia Miller Oct 1, 2026 868 views

Question details

The user wants to set up a Power Automate flow to automatically generate a new Microsoft Planner task whenever a new item is added to a Microsoft List.

Product: Power Automate, Microsoft Lists, Microsoft Planner
Device & OS: not provided
Scenario: Automating task creation in Planner based on new record entries in a Microsoft List to streamline project management.
Observed behavior: Setting up the flow requires using SharePoint triggers because Microsoft Lists data is physically stored in SharePoint Online or OneDrive for Business.

Before you start

Ensure you have active accounts and appropriate permissions for Microsoft Lists, Planner, and Power Automate, and have the URL of your SharePoint site or OneDrive for Business ready.

Solution 1Recommended

Use the SharePoint 'When an item is created' Trigger

Connect your Microsoft List to Power Automate via the SharePoint connector to detect new list items and automatically trigger the Planner task creation.

Since Microsoft Lists is built on top of SharePoint, list data is stored in either SharePoint Online or OneDrive for Business. Therefore, you must use the SharePoint connector in Power Automate to interact with your list.

Create a new automated cloud flow

Add the SharePoint trigger

In the trigger search bar, look for the SharePoint connector and select the trigger named 'When an item is created'.

Configure the Site Address and List

In the 'Site Address' field, select your SharePoint site from the dropdown. If you are using a personal OneDrive for Business list, select 'Enter custom value' and paste your personal SharePoint site URL. Then, select your target Microsoft List from the 'List Name' dropdown.

Add the Planner action

Click 'New step', search for 'Planner', and choose the 'Create a task' action.

Map the task fields

Select the appropriate Group Id and Plan Id. Map the dynamic content from your SharePoint list (such as the list item Title) to the Planner task fields, then save and test your flow.

Use the SharePoint 'When an item is created' Trigger

Personal OneDrive URL Format: A personal SharePoint site URL typically looks like https://[tenant]-my.sharepoint.com/personal/[username]_[tenant]_onmicrosoft_com.

Free Microsoft Office alternative

Looking for a Lightweight Alternative for Your Daily Office Tasks?

While Power Automate and Planner handle complex Microsoft ecosystem workflows, WPS Office provides a lightweight, entirely free, and highly compatible alternative for all your core document, spreadsheet, and presentation needs. Enjoy a familiar interface without heavy subscriptions.

1. Download the installer: Visit the official WPS Office website and click the free download button.
2. Install the software: Run the setup file and follow the simple on-screen instructions to install WPS Office on your device.
3. Open your documents: Launch WPS Office and instantly open any existing Microsoft Office files with perfect formatting.

100% compatible with Microsoft Excel, Word, and PowerPoint formats.Lightweight installation that doesn't consume excessive system resources.Built-in PDF editing, conversion, and collaboration tools.Free to download and use with a highly familiar user interface.

microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't Power Automate have a specific trigger for Microsoft Lists?

Microsoft Lists is fundamentally built on SharePoint infrastructure. All list data is stored in SharePoint or OneDrive for Business, which is why you must use SharePoint triggers (like 'When an item is created') to interact with Lists in Power Automate.

How do I find my OneDrive for Business site URL for Power Automate?

Log in to your OneDrive for Business via your web browser. Look at the URL in the address bar and copy the portion up to your username, excluding any specific folder paths (e.g., https://domain-my.sharepoint.com/personal/username_domain_com).

Can I automatically update existing Planner tasks from a Microsoft List?

Yes. Instead of the creation trigger, you can use the SharePoint trigger 'When an item or a file is modified'. You can then use the 'Update a task' action from the Planner connector in Power Automate to sync changes.

Office Quick Solutions