✦Template Printable Ideas Insights

**Seamlessly Connect Microsoft Lists & Planner with Power Automate**

By

Streamlining workflows in the modern office often involves connecting different Microsoft 365 applications. Power Automate, a key tool in this suite, facilitates this integration. One useful flow is transforming data between Microsoft Lists and Microsoft Planner. Let's explore how to achieve this.

First, understand that Microsoft Lists serves as a flexible tracking tool, while Planner helps teams organize tasks into plans. By combining these, you can manage tasks directly from Lists or sync data between them. Power Automate bridges this gap with automated flows.

Automating Lists to Planner

To begin, let's set up a flow that transfers items from a List to a Planner bucket when a new item is added.

Microsoft’s Planner: To Try or Not to Try? | The Together Group
Microsoft’s Planner: To Try or Not to Try? | The Together Group
Microsoft Lists: Integrations, Power Apps, takeaways
Microsoft Lists: Integrations, Power Apps, takeaways
How To Use Tasks by Planner & To Do
How To Use Tasks by Planner & To Do

First, sign in to your Power Automate account and click on 'Create' from the dashboard. Then, select 'Automated from blank' and choose 'When an item is created or modified' as the trigger for your chosen List.

Setting up the Flow

Next, add a 'Get item' action to fetch the specific item data that you want to transfer. Map the necessary fields. For instance, map the title field to the 'Title' of the Planner task, and description to the 'Details'.

Microsoft Lists: The Secret to Effortless Organization
Microsoft Lists: The Secret to Effortless Organization
the power automate sheet is shown with an arrow pointing up to it's center
the power automate sheet is shown with an arrow pointing up to it's center
7 Ways to Organize Your Workflow Using Microsoft Lists
7 Ways to Organize Your Workflow Using Microsoft Lists

Then, add an 'Add a task to a plan' action. This action will transfer the List item data into a Planner task. Map the relevant fields, select the plan, and choose the appropriate bucket.

Testing and Publishing

Use the 'Test' option to ensure your flow works correctly. After confirming, click 'Save', give your flow a name, and then click 'Turn on'. Now, whenever a new item is added to your List, it will automatically transfer to Planner.

Automating Planner to Lists

Similarly, you can create a flow that syncs Planner tasks back to your List. This process involves a slightly different set of triggers and actions, but follows the same logic.

Microsoft Planner Updates
Microsoft Planner Updates
What is Office 365 Planner? A Beginner's Guide
What is Office 365 Planner? A Beginner's Guide
Saving data from Microsoft Forms into Excel using Power Automate (Flow)
Saving data from Microsoft Forms into Excel using Power Automate (Flow)
To Do List Template: Excel & Google Sheets Planner (digital Download) - Etsy
To Do List Template: Excel & Google Sheets Planner (digital Download) - Etsy
How to Make a Gantt Chart in Microsoft Planner
How to Make a Gantt Chart in Microsoft Planner
How to use Microsoft's New Planner to organize your life in 2024
How to use Microsoft's New Planner to organize your life in 2024

Start by choosing the 'When an item is created' trigger for a specific Planner plan. Then, add an 'Get item' action to fetch the Planner task details. Map these details to their corresponding fields in your List.

Mapping Fields and Testing

Just like in the previous flow, ensure you map all necessary fields, such as the task title to the List item subject, and details to the List item description. After setting up the flow, test and publish it.

Now, whenever you add a task to your Planner, it would also automatically create an item in your List.

Effective OneNote Organization Tips for Busy Professionals
Effective OneNote Organization Tips for Busy Professionals
Weekly To-Do List with Automated Backlog in Excel Template | Color Coded Digital Product
Weekly To-Do List with Automated Backlog in Excel Template | Color Coded Digital Product
Microsoft Planner | Creating a Plan the Right Way
Microsoft Planner | Creating a Plan the Right Way

The automation of Microsoft Lists and Microsoft Planner using Power Automate not only saves time but also ensures data consistency. Consider how these flows could benefit your team's work management. Why not start by setting up one of these flows today?