The tutorial explains how to import Planner Tasks into Dynamic Groups and Plans using Power Automate. The basis of the function relies on a scheduled flow using a data source, in this case an excel sheet, which is updated daily to select necessary tasks. These tasks are then delegated to a relevant group and plan. This is determined by a distinct column value named "assigned".
A secondary table is used for the group and plan ID which can easily be obtained from the URL of your plan. This enables dynamic task creation in the right plan, thus enabling bulk task creation in multiple plans from a single data source. Further in the video, the data source is upgraded to a SharePoint List.
The lesson includes tips, example expressions, descriptions of Select, Filter Arrays, OData Queries on dates for SharePoint, and Excel, custom expressions alongside other useful information.
The video takes viewers through every step of the Planner Task import, opening with building the flow then it continues to testing different groups, filtering tasks, and understanding the flow. The instructor shows how to create Tasks, run the complete flow for a demo, check created tasks in Planner, and update the data source to a SharePoint List.
The major takeaway from this lesson is dynamically creating tasks for different plans using Power Automate. The usage of a scheduled flow can efficiently assign tasks to relevant groups and plans on a daily basis. This operation relies on a distinct value that can be extracted from a secondary table and assigned accordingly. This process enables the dynamic creation of tasks in multiple plans from a single data source. It offers flexibility as the data source can be switched easily from an excel sheet to a SharePoint List if required. Therefore, this video acts as a comprehensive guide to managing tasks in multiple plans conveniently.
In this video, I will demonstrate how to use Power Automate to create planner tasks in dynamic groups and plans from an Excel sheet or SharePoint list as the data source. I will show how to filter tasks based on a distinct column value and use a secondary table as a lookup for the group and plan ID. Tips and tricks, example expressions, and custom expressions will be discussed. Additionally, I will provide a link to a more detailed explanation of importing tasks into Planner with notes, checklists, and attachments. Finally, I will provide links for error handling and dates in Power Automate.
Power Automate, Planner, Dynamic Groups, Automation, SharePoint List, Excel Sheet