![]() Power Automate has 2x action called ‘Create a task’, one of them with (Preview) in the name. Once you have the array with rows (tasks), you can loop through all of them and create a Planner task for each. The output of this action will be an array with all rows = all tasks and their data. In the example below the Excel file is stored in OneDrive, the file is called Book.xlsx and the table TableByPA. ![]() While it shows the file name, on the background it needs the file identifier and it’s easier if you select the file from the choices. Use the buttons to select the file and the table, don’t try to type it. As already mentioned, all the data for each task must be on a single row – if you get all rows, you get all tasks.Īdd the ‘List rows present in a table’ action to your flow and select the file location, name and the table with tasks. The first step in the flow should be to list all the rows in the Excel file. Start from the ‘Instant cloud flow’ with manual trigger. Since this article is about the initial tasks import, the flow will be started manually. ![]() The flow in this post will import an Excel file as shown below with the 5 columns table. Start and Due date must be Date only, without time.Assigned To user should be user email address.Depending on the data you want to import, some columns should have a specific format: The Excel file must be stored in SharePoint or OneDrive.Īnd a few optional prerequisites.All the tasks and their data must be in a table, one row per task.Prepare the Excel fileīefore you start with the flow, you must prepare the Excel file with tasks. You can build a Power Automate flow for the tasks import from Excel to Planner. While there’re some 3rd party solutions to do that, it’s not necessary to use one. Maybe you already use an Excel file to track the tasks and you’d like to import them into Planner. If you decide to use Microsoft Planner for a light project management, maybe you don’t want to start from scratch. You can check all details here.“I’ve got 100s of tasks in an Excel file that I’d like to import into Planner, is that possible with Power Automate?” I have a template, and a template that you can use that will help you make your Flow resistant to issues. It’s horrible to have failing Flows in Power Automate since they may go unlooked for a while or generate even worse errors. Have your Flow fail graciously and notify someone that something failed. It’s important to enable faster debugging when something goes wrong. Indicate what’s the plan that you’re inserting data, why you’re inserting it there, and what the rules are. Always add a comment.Īdding a comment will also help to avoid mistakes. Always build the name so that other people can understand what you are using without opening the action and checking the details. The name is super important in this case since there could be hundreds of Plans in your organization. Again, there may be limitations elsewhere, but at least you have a lot of checks done for you automatically. If you can see it in the dropdown, then you can access them. In the same line as above, you’ll always be sure that the permissions are set correctly by picking the items from the list. So you should never have even to know what’s the ID of a Group or Plan.įinally, having the IDs will make debugging harder because you don’t have the description of the Plan to guide you. Even in these cases, pick the group and plan manually and generate multiple actions if you have to. For example, if you have the same task but could go to a department or another to parse depending on the content. I understand that there may be cases where the task may be inserted in one Plan or the other.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |