Skip to content

Let's POWER Automate

From no-code to low-code

Menu
  • Expressions
  • Filters
  • General
  • Problems
  • Triggers
  • Application specific solutions
    • Excel
    • Forms
    • Planner
    • Outlook
    • SharePoint
    • Teams
  • Resources
Menu

Import Planner tasks with checklists into various buckets (Power Automate)

Posted on May 15, 2022May 15, 2022 by Tom

“I’d like a single template with everything, Planner tasks, checklists, and buckets, what would such Power Automate flow look like?”


Some time ago I wrote articles on importing tasks into Planner using a Power Automate flow. There’s an article on importing tasks from Excel, import of checklist items from a SharePoint list, and an article on importing tasks into various plans/buckets. But there’s one more solution that wasn’t described. It’s a combination of all the solutions – one configuration list with everything. Tasks, checklist items, buckets, and plans, all in a single SharePoint list. What would such solution look like?

Extend the configuration list

Start from the checklist configuration list as created in the previous article and extend it by the additional columns – GroupID, PlanID, and BucketID. Since these columns define the location of the task, it should be the same for each separate task. Fill them out as described in the original article. The final list might look as below – checklist items are unique while the other columns keep the same information for given task.

This example will create 2 tasks in the same plan and group, but in different buckets.

Power Automate Planner tasks checklists buckets

Get the new information in the flow

Follow the original flow until you get to the “Create the unique tasks” section. There’re two actions whose order must be changed – the ‘Create a task’ and ‘Filter array’. Originally you used only the TaskName so it was ok to create the task right away. But now you need also the other information – GroupID, PlanID, and BucketID, and for those you’ll need the whole item – provided as the output of the ‘Filter array’.

Take only the first checklist item

The ‘Filter array’ will return an array with all the checklist items for given task. If the currently processed task is the ‘Task_1’, it’ll give you all the rows below.

That’s 3 times the TaskName, GroupID, PlanID, and BucketID. But you want it only once, you want to create only 1 task for all the checklist items. Use the first(…) expression on the ‘Filter array’ output to take only the first of the rows.

first(body('Filter_array'))

Now, when you’ve got the first row, you can access the values from all the columns. Prepare the expressions to extract them from the JSON.

first(body('Filter_array'))?['GroupID']
first(body('Filter_array'))?['PlanID']
first(body('Filter_array'))?['BucketID']

Note: you must use the columns internal name.

Take these expressions and use them in the Planner ‘Create a task’ action.

Power Automate Planner tasks checklists buckets

From that point you can continue with the flow as it was before.

Power Automate Planner tasks checklists buckets

Summary

It’s possible to use Power Automate to import all the Planner tasks, checklists, and buckets from a single configuration list. But since most of the information will be repeated, you must be careful about how you use it. The task itself should be created only once, that’s why you filter the unique task title and select only the first item to get the GroupID, PlanID, and BucketID.


Do you struggle with the various expressions, conditions, filters, or HTTP requests available in Power Automate?

I send one email per week with a summary of the new solutions, designed to help even non IT people to automate some of their repetitive tasks.

All subscribers have also access to resources like a SharePoint Filter Query cheat sheet or Date expressions cheat sheet.

Zero spam, unsubscribe anytime.

Leave a Reply Cancel reply

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

Now available:

The Ultimate Power Automate expressions cheat sheet
Equip yourself with the tool to translate your thoughts into Power Automate expressions!

Do you struggle with the various expressions, conditions, filters, or HTTP requests available in Power Automate?

I send one email per week with a summary of the new solutions, designed to help even non IT people to automate some of their repetitive tasks.

All subscribers have also access to resources like a SharePoint Filter Query cheat sheet or Date expressions cheat sheet.

Zero spam, unsubscribe anytime.

Hello and welcome!

My name is Tom and I'm a business process automation consultant and Microsoft MVP living in the Czech Republic. I’ve been working with Microsoft technologies for almost 10 years, currently using mainly Power Automate, SharePoint, Teams, and the other M365 tools.

I believe that everyone can automate part of their work with the Power Automate platform. You can achieve a lot by "clicking" the flows in the designer, but you can achieve much more if you add a bit of coding knowledge. And that's what this blog is about.

To make the step from no-code Power Automate flows to low-code flows: using basic coding knowledge to build more complex yet more efficient flows to automate more of your daily tasks.

  • Format results of date calculation in SharePoint columnJune 29, 2022
  • Why is your Power Automate flow creating duplicatesJune 26, 2022
  • How to create a unique identifier in your Power Automate flowJune 22, 2022
  • How to assign custom SharePoint permission level with Power AutomateJune 19, 2022
  • Remove permissions from a specific SharePoint user with Power AutomateJune 15, 2022

Power Automate blogs worth visiting

Damien Bird
Dennis (Expiscornovus)
Paul Murana

© 2022 Let's POWER Automate | Powered by Superbs Personal Blog theme