Let's POWER Automate

From no-code to low-code

Menu
  • Expressions
  • Filters
  • General
  • Application specific solutions
    • Dataverse
    • Excel
    • Forms
    • Outlook
    • Planner
    • Power Apps
    • SharePoint
    • Teams
  • Triggers
  • Ready to use solutions
    • Approval Process Template
    • Task Delegation App
    • The Ultimate Power Automate expressions cheat sheet
    • Power Automate HTTP requests to SharePoint cheat sheet
    • Power Automate HTTP requests to Graph API cheat sheet
  • ABOUT ME
  • Get help with your flow
  • POWER PLATFORM SERVICES
Menu

SharePoint list as Planner ‘task and checklist template’ in Power Automate

Posted on April 18, 2021January 6, 2022 by Tom

“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?”


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. But it included only two simple template examples, a SharePoint list and an Excel table. 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?

Planner tasks template SharePoint list

You can’t simply loop through all the items as it’d create multiple planner tasks, you must preprocess the data first.

The starting point is the ‘Get items’ action to get all the tasks and checklist items from the list. Don’t use any filter.

Get items

Get the unique task names

Once you have the items, you should filter out duplicate task names as you want each task only once. 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’.

Add the ‘Select’ action to your flow, it’ll allow you to select only the task names from the items in the ‘Get items’ output. Put ‘value’ into the ‘From’ field, switch to ‘text mode’, and enter the task name column into ‘Map’.

Select task name

The ‘Select’ output will be an array with only the task names, but it’ll still contain duplicates. To remove the duplicates you’ll need the union(…) expression. If you enter 2 arrays into union(…), it’ll return the overlapping values. 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.

union(body('Select'),body('Select'))
Power Automate get unique Planner task names from SharePoint

The output of the ‘Compose’ action above will be an array with values ‘Task_1’ and ‘Task_2’ from the example above.

Create the unique tasks

Now, when you’ve got the unique task names, you can create the tasks in the Planner. Add ‘Apply to each’ with outputs from the ‘Compose’ action as the input. As already mentioned, the output will contain only the unique task names at this moment, no duplicates. Be careful to not use the original ‘value’ output from ‘Get items’.

You’ll see a new available dynamic content inside ‘Apply to each’: ‘Current item’. This dynamic content contains the currently processed value from the input array, in this flow the task name. Following the example, in the 1st loop it’ll contain ‘Task_1’, in the second loop ‘Task_2’.

One use for the ‘Current item’ dynamic content is the task ‘Title’ field.

Create unique Planner tasks PA

Get the checklist items for each task

The second use is to get the corresponding checklist items. At this moment you’ve got the array with all tasks/checklist items (output from ‘Get items’), and the current, unique task name. Combining this in the ‘Filter array’ you can filter from all checklist items only the ones for given task. Put the ‘value’ output from ‘Get items’ as the ‘From’ field, and filter only the checklist items where task name column is equal to ‘Current item’ (the currently processed task).

Filter Planner checklist items from SharePoint with Power Automate

Then you can add another ‘Apply to each’ to process all the checklist items that fit the ‘Filter array’ condition. From this point it’s the same approach as in the original post.

There’re two more things to be careful about though. Firstly, ‘Filter array’ won’t give you dynamic content for the checklist item ID and Title. You can either get it back with ‘Parse JSON’ action, or you can get the values using the expression item()?[‘ColumnInternalName‘]. And secondly, don’t forget to always set the array variable to null expression before you start appending checklist items for the next task.

Process checklist items

Full flow diagram

Power Automate create Planner tasks checklist from SharePoint list

Summary

The Power Automate solution above will allow you to repeatedly create multiple Planner tasks including checklist from a SharePoint list, potentially also with attachments.

The main part here is the work with the array(s). When you ‘Get items’ from a SharePoint list, they’ll be always stored in an array during the whole flow run. You can take some data from the array for further processing, e.g. to get the task names with ‘Select’. But you can always go back to the original full array to get a different part of it, e.g. only the checklist items for selected task in ‘Filter array’.

You should also keep in mind that every time you append data to an array in a loop, you must clear that array before the next loop. You don’t want a single array with all the data, each task in this solution has it’s own checklist.

And if you’re looking for a solution to create just a single task with a checklist, you can ‘lookup’ the desired checklist items instead. This flow will always create all tasks from the ‘template’ list, it doesn’t have any filter on the tasks.

Or you can create tasks from the same list in various groups/plans/buckets.


🚀 Master Power Automate

Join 2,000+ professionals getting actionable Power Automate tutorials, solutions, cheat sheets & tips every week.

No spam. Unsubscribe anytime.

8 thoughts on “SharePoint list as Planner ‘task and checklist template’ in Power Automate”

  1. Roger Neubauer says:
    May 11, 2022 at 10:33 am

    Hello Tom, THANK YOU! You saved my day, the way how you post your “How to’s” is just so easy to read and understand.
    I just did my first Power Automate flow with your “SharePoint list as Planner ‘task and checklist template’ in Power Automate” and it works flawless for simple Tasks.
    Now I extended my Sharepoint list “CecklistTasksMaster” with additional fields “GroupID”, “PlanID”, BucketID” based on your Guide “Import Planner tasks into various plans/buckets with Power Automate”.
    But now I’m struggling to get this implemented in the Flow that when the Planner task gets created it gets the right ID’s from the List. Could you guide me in this?
    I believe then this Flow would be so Powerful and would be an Accelerator with Process automatizations.

    Thx again
    br Roger

    Reply
    1. Tom says:
      May 15, 2022 at 6:45 pm

      Hello Roger,
      I hope this article will help you with that: https://tomriha.com/import-planner-tasks-with-checklists-into-various-buckets-power-automate/

      Reply
  2. Hilaire Givelet says:
    June 22, 2022 at 3:48 pm

    Hello Tom,

    Your solution was really useful thank you. Nevertheless I struggle with it because I would like to create severeal checklists in severeal tasks and all the checklists are mixed when using your technique.

    Do you have an idea to help me please ?

    Thank you
    Hilaire

    Reply
    1. Hilaire Givelet says:
      June 22, 2022 at 3:49 pm

      PS: I am using Excel instead of SP

      Reply
    2. Tom says:
      June 28, 2022 at 4:28 pm

      Hello Hilaire,
      the solution is designed to create multiple tasks each with their own checklist, I’d check if you didn’t miss one of the steps in the flow, the most common pain points are:

      • not switching to Text mode in ‘Select’
      • wrong filter in the ‘Filter array’
      • not setting the checklist variable to ‘null’ at the beginning of each loop
      Reply
  3. Neven says:
    November 16, 2023 at 5:02 am

    Hi Tom,

    I am having difficulty in the “Get the unique task names” section setting the Map to “TaskName”. There is no dynamic content for this under Get Items. Not sure if this has changed since you wrote this article.

    Look forward to hearing from you

    Reply
    1. Nobody says:
      March 22, 2024 at 12:27 pm

      Dear Neven,
      It seems the sharepoint list has to have three columns. First column should be the ID. (Should be created automatically if you export a two-column-table to sharepoint)

      Reply
    2. Nobody says:
      March 25, 2024 at 2:59 pm

      Dear Neven,
      you may also need to initialize the variable ‘checklist_array’ right after you trigger the flow.

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

🚀 Master Power Automate

Join 2,000+ professionals getting actionable Power Automate tutorials, solutions, cheat sheets & tips every week.

No spam. Unsubscribe anytime.

Working on an Approval process?

Use the Approval Process Template and the Task Delegation App to skip the hard part and deploy a fully functional approval solution on a SharePoint list in minutes! And then the next one, and the next one...

Approval Template Preview ✨ Learn more ✨

Turn ideas into flows with ease!

Grab the complete Power Automate Cheat Sheet Bundle—everything you need to master expressions, SharePoint HTTP calls, and Graph API in Power Automate.

Cheat Sheet Bundle Preview ✨ Get the Cheat Sheets

Didn't find what you were looking for?
Need to adjust a solution to fit your needs?
Or would you just like to get an assistance from somebody with thousands of hours of experience with Power Automate?

Power Automate blogs worth visiting

Damien Bird
Dennis (Expiscornovus)
Paul Murana

©2025 Let's POWER Automate | Theme by SuperbThemes