You’ll see a new available dynamic content inside ‘Apply to each’: ‘Current item’. Be careful to not use the original ‘value’ output from ‘Get items’. As already mentioned, the output will contain only the unique task names at this moment, no duplicates. Add ‘Apply to each’ with outputs from the ‘Compose’ action as the input. Now, when you’ve got the unique task names, you can create the tasks in the Planner. The output of the ‘Compose’ action above will be an array with values ‘Task_1’ and ‘Task_2’ from the example above. If you enter the same array (in this case the output from ‘Select’) twice into union(…), it’ll return only unique values from the array. If you enter 2 arrays into union(…), it’ll return the overlapping values. To remove the duplicates you’ll need the union(…) expression. The ‘Select’ output will be an array with only the task names, but it’ll still contain duplicates. Put ‘value’ into the ‘From’ field, switch to ‘text mode’, and enter the task name column into ‘Map’. To continue with the example above, you don’t want 3x ‘Task_1’ and 2x ‘Task_2’, you want 1x ‘Task_1’ and 1x ‘Task_2’.Īdd the ‘Select’ action to your flow, it’ll allow you to select only the task names from the items in the ‘Get items’ output. Once you have the items, you should filter out duplicate task names as you want each task only once. The starting point is the ‘Get items’ action to get all the tasks and checklist items from the list. You can’t simply loop through all the items as it’d create multiple planner tasks, you must preprocess the data first. What if you need more complex template? One SharePoint list with multiple tasks with various checklist items that should be created on a regular basis? Two columns, one with the task name (repeated) and the second one with the checklist items? But it included only two simple template examples, a SharePoint list and an Excel table.
#Employee task planner how to
The previous post “ How to create a checklist in a Planner task with Power Automate” already explained how to create a checklist in a Planner task. “I have one SharePoint list with all the Planner tasks (which repeat) and a checklist for each, how can I avoid creating new task for each item with Power Automate?”
0 kommentar(er)
