cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Copy Planner Tasks into Sharepoint List(Create and update)

Hi all,

 

I hope you doing well and Safe,

 

I am trying to create a Flow to copy all planner tasks details into a sharepoint list(in order to create a Power BI dashboard), but without no success,

  • Create sharepoint item when new task in planner created( copy all task details)
  • Update the existing sharepoint items with any changes happened to the task in planner(with no duplication) 
1 ACCEPTED SOLUTION

Accepted Solutions

 

Hi @Anonymous ,

 

If so, I think the Export plan to Excel is the best option since you could use the data as the Data source to create the Power BI report.

58.PNG

Use format as table to format the data in the Excel sheet.

57.PNG

You can replace the exported Excel file in OneDrive regularly, and then the data can be refreshed regularly.

I think the above option is more suitable for your needs.

 

In addition, if you want to get Assigned to and Bucket name, please refer to the method below.

92.PNG93.PNG

If you want to get Description, please use Get task details action and currently we cannot get Priority.

Anf this is the completed Time:

94.PNG

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

8 REPLIES 8
v-bacao-msft
Community Support
Community Support

 

Hi @Anonymous ,

 

If you want to monitor changes of the task, I am afraid that we could not achieve it depend on the existing triggers in the Planner task connector.

 

Please try to create the following three Flows to achieve your needs.

 

  • First Flow, using when a task is created as the trigger and create the item in SharePoint list.

82.PNG

  • The second Flow, use When a task is completed as the trigger and update the specified item. You need to use Task id to filter the eligible item and update it.

83.PNG

  • The third Flow, use Recurrence as the trigger and set the interval to 1 day.  Configure List tasks action to get all tasks and update the items in the list.

84.PNG

Similarly, you also need to use Task id to filter the eligible items and update them.

So the key point is Task id, you need to create a column(single line of text) in the list to record task id.

 

Hope this helps.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Hi @v-bacao-msft 

Thanks for you support, partially working,

 

the challenge is when task is created not all the tasks details pulled in, for example:

  • some fields cannot get the details for it, Asignee ( whom task assigned to), Bucket, Description, Priority
  • Completion date isn't shown on the SP list when task is completed
  • Tasks before creating the Flows not transfers into the SharePoint list Sharepoint list.pngWhen Task is Created.png

 

Hi @Anonymous ,

 

If so, I think the Export plan to Excel is the best option since you could use the data as the Data source to create the Power BI report.

58.PNG

Use format as table to format the data in the Excel sheet.

57.PNG

You can replace the exported Excel file in OneDrive regularly, and then the data can be refreshed regularly.

I think the above option is more suitable for your needs.

 

In addition, if you want to get Assigned to and Bucket name, please refer to the method below.

92.PNG93.PNG

If you want to get Description, please use Get task details action and currently we cannot get Priority.

Anf this is the completed Time:

94.PNG

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

@v-bacao-msft 

 

Thanks for your reply, I agreed with the Excel approach,

 

is there any chance to have the Flow do that:

  • Update the excel and the information's inside
  • create, update and delete rows and cells

Kind Regards

Magdy

 

Hi @Anonymous ,

 

I think you do not need to use Flow to update task details, you only need to export the task to Excel directly again.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

hi @v-bacao-msft 

 

Thanks for the reply, 

 

So there Isn't a way to automate the idea/solution?

 

Regards

Magdy

 

Hi @Anonymous ,

 

I am afraid that we could not export tasks automatically by Power Automate.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi

Would it be possible to use desktop power automate to create the export action ?

thanks in advance 

 

Will

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (2,314)