![]() It’s because names can change, and a small change in the name could break your flow. ![]() It’s important to understand that Power Automate doesn’t work with names, it works with IDs. The solution above describes how to use Power Automate to import Planner tasks from Excel into various groups, plans and buckets. "planId": "S4VCKKcv60CO-f_TtS-GhJgADSVZ",įind the right bucket by its name, take its ID and add it to your Excel import file. "W/\"JzEtQnVja2V0QEBAQEBAQEBAQEBAQEBARCc=\"", Among it will be the bucket ‘name’ and the ‘bucketId’ (under the ‘id’ key). If you add the action to your flow and run it, you’ll see in the run history all the available buckets and their information. But you can use the Power Automate action ‘List buckets’ to get it as a workaround. ![]() It’s not so simple with ‘bucketId’ as that one doesn’t appear in the url. PlanId=S4VCKKcv60CO-f_TtS-GhJgADSVZ Get the bucketId Just open the plan in your browser and take it from there, ‘groupId’ is after ‘groupId=’ and ‘planId’ after ‘planId=’. The ‘groupId’ and ‘planId’ are easy to get from the url in the plan. To import tasks from an Excel file into various plans/groups/buckets you’ll need their ID. There isn’t any name except the task title. There’s a ‘groupId’ for the M365 group, ‘planId’ for the plan and ‘bucketId’ for the bucket. You can see that if you configure the ‘Create a task’ action and then switch to ‘Peek code’. Power Automate works with the IDs of the Planner groups, plans and buckets, not with their names. But what if you don’t want all the tasks in the same plan/bucket? If you want to use a single Excel file with all the tasks for multiple plans and/or buckets? How can you tell Power Automate which plan and which bucket to use for each of the tasks? Use the group/bucket/plan IDs Every row in the Excel table will be taken and imported into the predefined plan and bucket. I already published a post on importing tasks from Excel to Planner with Power Automate, but the solution is importing all the tasks into the same place. The format for each checklist item should be as below.“Is there any way I could fill-in buckets and plans directly in an Excel sheet so I could use only one file to create Planner tasks in as many plans as I need with Power Automate?” If the array is empty, it won’t add any checklist item if it’s not empty, it’ll add all the items. Switching to ‘input entire array’ will allow you to add that array of checklist items to the task. ![]() you store the checklist in an Excel file or in a SharePoint list, you must build an array. Dynamic checklist (0 – n items) from a ‘template’ The example below will create 2 checklist items in a task: ‘Checklist item 1’ and ‘Checklist item 2’. Just fill out the required fields: Checklist Id (any number, but it must be unique), Checklist Title (name of the item), and if the Checklist item is checked when created. If your checklist is always the same, it might be sufficient to create it directly in the action. You can define either fixed checklist items for all task, or you can ‘input entire array’ to add 0-n checklist items. Among the other available fields is ‘Checklist’ where you can add the… checklist. The action you’ll need is ‘Update task details’ (the action you use to update the task description). If you use Power Automate to automatically create a task in Planner, you should be able to create a checklist too. “I’m using Power Automate to automate creation of Planner tasks, can I create also a checklist inside the task?”Īdding a checklist to a task is a basic functionality for any planning application, and it’s the same with Planner. ![]()
0 Comments
Leave a Reply. |