The only difference is that the (Preview) action can assign a priority to a task, I’d use that one.Īdd the ‘Create a task’ action and use the ‘Task name’ from the Excel table as the task ‘Title’, that will add the ‘Apply to each’ action automatically. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |