M365 – Convert SharePoint List Items to Planner Tasks Using Power Automate

Hi Everyone
I hope everyone is doing great!!!

Recently I was working on migration activity, which required document library migration, user groups and list migration. So, there was one generic list whose columns we could map with planner task properties such as Task Name, Start Date, Due Date, Assigned To, Status etc. We thought if we can manage our tasks and activities through planner, end user don’t have to maintain the sp list. There were more than 800 list items to convert.

So, I started working on this POC which came out to be successful, so I am sharing it with you. For the sake of demonstration and understanding I have created a demo list.

Setup was as below:

  1. List available in SharePoint (List name: Conversion List)
  2. Tasks to be created in Planner
  3. To create tasks and update its details automatically I used Power Automate (Our key part is here)



Figure 1: List to be converted

Mapping of SP list columns with planner task properties:

PlannerSP List Columns
Bucket NameClient
Task NameTask Name
Assign ToAssigned To
Start DateStart Date
Due DateDue Date
StatusStatus
Table 1: Mapping of SP list columns with planner task properties

Now let’s get started with the flow.

  1. As this is being onetime activity, I created Instant cloud flow which can be triggered manually.
Figure 2: Select flow type

2. Give the name to the flow, and under Choose how to trigger this flow select Manually trigger a flow and click Create.

Figure 3: Create a flow

3. After flow is created, you will see it as follows

Figure 4: Initial Flow

4. Add the step -> Initialize variable, give name to the variable and select its type to Array.

Figure 5: Initialize variable – bucketArray

5. Add the step -> Get items, select Site Address and List Name

Figure 6: Get items action

6. Add the step -> Append to array variable, select the name bucketArray and in the value field add Client Value from dynamic content.

Figure 7: Add client value to bucket array variable

7. As soon as you select Client Value it will wrap your Append to array variable action with Apply to each.

Figure 8: Action wrapping

8. Add the step -> Compose, in the Inputs field add the expression: union(variables(‘bucketArray’), variables(‘bucketArray’))

This is because, if you see our list all Client values are added to bucketArray variable, and to create bucket we require unique values.

Figure 9: Create unique array of items

9. Add the step -> Apply to each, and select output of compose action in the Select an output from previous steps field.

Figure 10: Select output of compose action

10. Inside the loop, click Add an action and add Create a bucket action.

11. In the Name field select Current Item, as it is looping through each bucketArray element.

Figure 11: Select name of bucket

12. Select respective Group Id and Plan Id.

Figure 12: Select group and plan ids

13. Give 5 second delay, to make sure all the buckets are created and our next step is depending on create bucket action. Sometimes, it throws error that “Bucket with the name does not exists”, that’s why delay is needed.

14. Add the step -> List Buckets, select Group and Plan Id

Figure 13: List all buckets

15. Add the step -> Apply to each, in the field Select an output from previous steps select value which is output of List Bucket action.

Figure 14: Select bucket value

16. Click Add an Action, in the From field select value which is output of Get items action, and filter when Client Value is equal to name of bucket, so only those items will be brought up where filter criteria is met.

Figure 15: Filter Array

17. Add Apply to each, to loop through each filtered item, in the field Select an output from previous steps select Body which is output of Filter Array action.

Figure 16: Select filter output body

18. Click Add an action, and add Create a task. Select Group Id, Plan Id, in the title field add an expression: item()?[‘Title’]. Similarly for Start Date, Due Date, Assigned User Ids do the same but instead of Title put their internal names, select Bucket Id.

Figure 17: Create a task

19. Click Add an action, add Update a task, in the field Task Id select the id of the task which is output of Create a task action. And in the Progress field add expression: item()?[‘MDCStatus/Value’]

Figure 18: Update a task

20. Our flow is complete. Let’s run it. Complete flow given below:

Figure 19: Final Flow

21. Before flow runs, planner looks like below:

Figure 20: Planner before flow run

22. Tasks must have been created in the Planner. Planner after flow run.

Figure 21: Planner after flow run

Limitations of Planner or Power Automate:
As there are advantages of anything, limitations also come with it. Our flow runs successfully and tasks are also created and ready to use but we should know the limitations of Flow and Planner also.

  1. Power Automate Planner related actions doesn’t provide any property to set priority value of task.
  2. For the completed tasks planner marks it as completed by the user account with which flow is run.
  3. We cannot add custom status values to Planner. Only we can use statuses provided by planner which are Not Started, In progress and Completed. You can map other statuses (On Hold, In Review etc.) to In progress.

Thanks for reading.

Please like, share, comment.

You may also like...

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: