How can we make Planner better?

← Microsoft Planner - Feedback Forum

Create Planner Tasks with VBA

Would like to be able to automate the creation of tasks for projects with a template concept using VBA.
We create similar tasks for projects consistently. I'd love to be able to hit a button from Access, Excel or even PowerApps to create the ~15 tasks each time we create a project - rather than creating an Excel file and copy and pasting each one.

39 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Katie Snow shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

5 comments

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Anonymous commented  ·   ·  Flag as inappropriate

    You can do this with Flow/Automate, but I found out it only works with .xlsx file types and not .xlsm hence why I would like to be able to do it with VBA.

  • Anonymous commented  ·   ·  Flag as inappropriate

    Maybe you could use Automate? I use it to create a project in Access. It automatically creates a task in Planner, folder with subfolders in Sharepoint and OneNote page for notes.

  • Erica Ingram commented  ·   ·  Flag as inappropriate

    i have an access database i made and use for my business and i would LOVE to be able to auto-create planner buckets with static tasks within a plan for it. Then i could customize the information in it automatically.

Microsoft Planner - Feedback Forum: APIs

Categories

Feedback and Knowledge Base

(thinking…)