Skip to main content

Notifications

Community site session details

Community site session details

Session Id : QWNl+E2F4l9l5U+4cigIxF
Power Automate - Building Flows
Answered

Copy Planner Tasks into Sharepoint List(Create and update)

Like (1) ShareShare
ReportReport
Posted on 1 Apr 2020 09:04:03 by

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) 
  • KC-14081446-0 Profile Picture
    2 on 14 Aug 2024 at 14:49:03
    Copy Planner Tasks into Sharepoint List(Create and update)
    Hi @thomashu1987,
     
    Would it be possible for you to share your flow in more details?
    Either exporting it or more screenshots?
  • thomashu1987 Profile Picture
    5 on 20 Jun 2024 at 05:57:12
    Re: Copy Planner Tasks into Sharepoint List(Create and update)

    Hi, I had the same though as you did before, and still researching on solutions.

     

    However, Thanks to Youtube video posted by Christine Payton, I did managed to create following scheduled cloudflow to backup my planner data into a JSON file on daily basis. I posted the youtube link here for your reference: https://www.youtube.com/watch?v=q7bkWpVczz0&t=930s

     

    And, here's how the flow looks like:

    thomashu1987_0-1718862476481.png

     

     

  • Cym2 Profile Picture
    4 on 26 Jun 2023 at 01:33:09
    Re: Copy Planner Tasks into Sharepoint List(Create and update)

    Hi  Barry, 

     

    I am trying to update a SharePoint person column on completion of the planner task with who the task was assigned to. I followed the directions above, but it doesn't seem to work - are you able to provide some updated advice as i notice this was from a couple of years ago

     

  • Wilson1981_ Profile Picture
    19 on 08 Jul 2022 at 13:46:25
    Re: Copy Planner Tasks into Sharepoint List(Create and update)

    Hi

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

    thanks in advance 

     

    Will

  • v-bacao-msft Profile Picture
    on 07 Apr 2020 at 00:54:26
    Re: Copy Planner Tasks into Sharepoint List(Create and update)

     

    Hi @Anonymous ,

     

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

     

    Best Regards,

  • Community Power Platform Member Profile Picture
    on 06 Apr 2020 at 07:51:31
    Re: Copy Planner Tasks into Sharepoint List(Create and update)

    hi @v-bacao-msft 

     

    Thanks for the reply, 

     

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

     

    Regards

    Magdy

  • v-bacao-msft Profile Picture
    on 06 Apr 2020 at 05:40:56
    Re: Copy Planner Tasks into Sharepoint List(Create and update)

     

    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 Power Platform Member Profile Picture
    on 03 Apr 2020 at 14:16:04
    Re: Copy Planner Tasks into Sharepoint List(Create and update)

    @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

  • Verified answer
    v-bacao-msft Profile Picture
    on 03 Apr 2020 at 02:04:47
    Re: Copy Planner Tasks into Sharepoint List(Create and update)

     

    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 Power Platform Member Profile Picture
    on 02 Apr 2020 at 14:38:38
    Re: Copy Planner Tasks into Sharepoint List(Create and update)

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,769 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,091 Most Valuable Professional

Leaderboard