Forum Discussion

MatthewJamesDavis's avatar
MatthewJamesDavis
Iron Contributor
Nov 14, 2023

Planner Plan Backup Resolved

Just wrapped up an excellent nightly backup solution for your Plans! This Power Automate system captures your entire Microsoft Planner Plan, including checklist items, assigned names, dates, labels, and priorities, and generates a dated backup Excel file in SharePoint. Saying goodbye to worries about accidentally deleted tasks or plans :lol:.

 

Additionally, I'm nearly finished with a backup import trigger that will generate a new Planner Plan with any of this nightly generated back up files as needed. I'm also exploring the option of incorporating comments into the backup file soon. Certainly know a way to make it happen!

This automation is part of a larger course/solution package I'm developing. Other upcoming features include automatic assignment of unique project codes (you can catch a glimpse of it in the title column), auto-assignment of staff based on labels (for instance, if your yellow label is labeled Marketing, it automatically assigns everyone in marketing when used), working comment notifications and more.

 

I'm eager to hear your thoughts on this backup solution, and if enough people want it just @mention me in the comments below. Suggestions also always welcome!

  • Mike_D365's avatar
    Mike_D365
    Copper Contributor

    Thank you for your work and contributions here!  Any info on the latest build?  Can I offer assistance to test/validate? :)

  • MatthewJamesDavis 

    I was wondering if you have a new link to the Power Automate solution with the version two fixes for:

    The known issues include:

    1. Your plan must have labels assigned to all tasks.
    2. Comments are currently not included.
    3. Dates (start dates/end dates) need formatting adjustments.
    4. User accounts need to be integrated into the automation to ensure that the "Assigned to" column displays full names.

    and if you have completed the transfer back to MS Planner when necessary?

    Also, have you thought about a process to notify the owner of the plan when someone does accidentally delete something so you know when to implement the transfer backup?

     

    for the above known issues in version one backup; are there explanations for what these should be for each issue? like any label on all tasks?  what is the proper date format?

     

    Thank you.

  • DelphinaC's avatar
    DelphinaC
    Copper Contributor
    Will this recover deleted buckets along with the details as well for premium?
  • Lettmetall's avatar
    Lettmetall
    Copper Contributor

    MatthewJamesDavis 

     

    Hello Matthew!

    May I ask if there has been any progress towards your version two of this brilliant work?

     

    Thanks in advance 🙂

    • MatthewJamesDavis's avatar
      MatthewJamesDavis
      Iron Contributor
      Hi Lettmetall, currently working on this. Been tied up in other projects. So version two would cover adding in comments to the back up, and removing the need to always having to label every task. Anything else hoping to see?
  • Thanks to those that reached out to me on Linkedin about this, let's get version two going shall we! Back with you over the coming week. 🙂
    • r_denham's avatar
      r_denham
      Copper Contributor
      I'm excited to see what version 2 looks like - the accidental delete aspect is one of our biggest concerns with using Planner.

      Would this work with the "premium" version too (we haven't got it yet, but we were interested in the sub tasks etc).
      • MatthewJamesDavis's avatar
        MatthewJamesDavis
        Iron Contributor
        We will need to do some testing with the premium version, but i can't see any reason why not! I've only just managed to pick this back up. I'll be back with an update soon.
  • I've generated version one as a Power Automate solution for everyone to test (see attached). Please be aware that this is an initial release with a few identified bugs, which I am actively addressing for version two.

    The known issues include:

    1. Your plan must have labels assigned to all tasks.
    2. Comments are currently not included.
    3. Dates (start dates/end dates) need formatting adjustments.
    4. User accounts need to be integrated into the automation to ensure that the "Assigned to" column displays full names.

    As said, I'm working on resolving these issues for the upcoming version two. Additionally, I am developing a secondary automation to seamlessly transfer data back into Microsoft Planner when necessary.

    I'll prioritise addressing these concerns and second automation based on demand, so please share your feedback in the comments or by liking this post.

    Thank you for your patience, and I hope you enjoy testing the current version.

     

    • DelphinaC's avatar
      DelphinaC
      Copper Contributor
      It's not working for me, when I go upload in power automate I get an error message/red banner "try again later"... is there a way around this? Thanks!
    • Tomas_Wianto's avatar
      Tomas_Wianto
      Copper Contributor
      Hi, any chance that you have reached version 2 for this?
      • MatthewJamesDavis's avatar
        MatthewJamesDavis
        Iron Contributor
        Hi Tomas, currently working on this. Been tied up in other projects. So version two would cover adding in comments to the back up, and removing the need to always having to label every task. Anything else hoping to see?
    • MatthewJamesDavis's avatar
      MatthewJamesDavis
      Iron Contributor

      Sorry for the delay Sunsadymark, this was a big one so i've simple provided the zip file to pull it straight into your Power Automate. You just need to update what Plan it's looking at, the location you want the file and a few other obvious bits.  I've just posted the file as a reply to my original post :).  

    • MatthewJamesDavis's avatar
      MatthewJamesDavis
      Iron Contributor
      Thanks for the message. give me till middle of next week and i'll write up a step by step process on how to do this yourself.
  • BonnieH's avatar
    BonnieH
    Copper Contributor
    Can you provide details on how to do this? Sorry I am not as technical as most around here. Thanks so much
    • MatthewJamesDavis's avatar
      MatthewJamesDavis
      Iron Contributor

      Sorry for the delay Bonnie, this was a big one so i've simple provided the zip file to pull it straight into your Power Automate. You just need to update what Plan it's looking at, the location you want the file and a few other obvious bits.  I've just posted the file as a reply to my original post :).  

    • MatthewJamesDavis's avatar
      MatthewJamesDavis
      Iron Contributor
      Thanks for the reply, give me till middle of next week and i'll write up a step by step process on how to do this yourself.

Resources