Microsoft Planner Gantt Chart with Power Apps – download your own!

[If you’re just looking for the download link, it’s at the end of this blog post]

Update on Oct 7th 2021: Planner UserVoice is gone and I was not able to find the corresponding feature request any longer. I removed the link below 😦

So far (May 15th, 2021) there has been 11957 votes on the Microsoft Planner UserVoice for a feature to get a Gantt chart view in Microsoft Planner. The latest reply from the Planner Team is, that people should start using Microsoft Project. Obviously, that is not always possible, so I wanted to give it a shot whether it is feasible to create a Power Apps canvas app to provide the missing functionality.

Few years ago I wrote an article in LinkedIn introducing a way to create a Gantt chart in Power Apps based on task data stored in Azure SQL Database. This time the data is stored in Microsoft Planner and the implementation method as well as features have evolved in various ways.

I implemented the app and in this blog post I will introduce it from end user perspective. I will walk through some technical implementation highlights in later posts.


View multiple plans on the same chart

You can choose up to four plans and have them displayed on the same Gantt Chart.

Each selected plan is assigned a distinct color so that it is easy to identify which task belongs to which plan.

Smart month range selection

By default the chart displays the previous month, the current month and three upcoming months. You can easily alter the month range by changing the start or end month.

You can also click on the month column on the actual chart to only choose the specific month.

Implementation of the month selector is already described in another blog post.

View assignees of the task

Images of task assignees are displayed once the user clicks on the right angle bracket next to the task. The name of the assignee is displayed on mouse hover.

You can reveal assignees of all tasks by clicking on the Display all assignees.

Task indicator explained

All the elements of a one single task are indicated below.

Task color is always light green unless the task is already completed – completed tasks are filled with light gray. The task dashed border color matches the color assigned to the plan.

There are two things about the task dates that need explaining:

  1. All tasks that are In Progress and that do not have a due date set are displayed on the chart as if the due date was today
  2. If task start date is not set, a date calculated five days backwards from the due date is used

Task buckets and categories (a.k.a. labels)

The bucket of each task is displayed on the left hand side of the chart. All the named categories/labels that are set on the task are displayed on the right.

Note that only labels that have a specific name set in the Planner are displayed.


In addition to the month range filter described earlier, you can also apply other types of filters on the displayed tasks.

Filter by status

You can choose to include only items that you are one of the assignees of. You can also exclude completed tasks. By default neither of the filters are selected.

Filter by bucket

You can choose any of the available buckets to filter by that specific bucket. Only one bucket can be selected at a time.

Filter by category

The labels that are assigned a unique named can be used for filtering. The filtering applies logical conjunction on the tasks – this means that if you have two labels selected to be filtered by, each included task must have at least both those two labels defined.

Note, that Filter by category panel is visible only when there is just one plan selected.

There are six categories/labels available to be used via Planner Connector. This is an obvious drawback as Planner nowadays supports over ten different labels.

Filter by plan

You can also exclude one or more plans from the chart by unselecting the plan at the top of the screen.

Creating new tasks

You can easily create a new task to one of the plans selected to be shown on the chart. You simply click on the desired date below the last task on the chart. Add new task dialog is displayed where you can select target plan, start date (default is the date you clicked on the chart), due date (default is ten days from the start date), bucket, task title and emoji for the task.

When your done with filling in the task data and want to create the task, you can either click on the Save button, which performs the creation of the new task, closes the dialog and refreshed the gantt chart. Alternatively you can click on the Save and open button, which performs the same operations, but in addition also opens the newly created task in Planner for further editing in another tab. With that, you can then fill in some additional information that is not supported in the task creation dialog, such as specifying assignees or labels, creating checklist items, notes or comments or adding attachments.

Accessing Planner

There are multiple places throughout the app providing a link to a specific Planner plan or task. All links open the plan in a new browser tab.

Plan selection page

You can open desired plan on the front page of the app from the upper right corner of each plan tile.

Selected plans display area

Each selected plan in Planner can be also access via the upper horizontal listing of plans on the gantt chart page.

Task lane on the chart

You can open a specific task in Planner by clicking on the icon on the task row.

Use a parameter to preselect a single plan

You can provide a plan parameter to the app to force a single plan to be preselected by default when the app is opened. Very handy e.g. when surfacing the Gantt Chart as a Teams tab!

Read more about it in this blog post.

Download the app and start using it!

The Gantt Chart app is published in my Git repository planner-gantt-chart. It can be downloaded and imported into the desired Power Platform environment as instructed in the README documentation.

Here is a direct link to download the file:


  1. Koen Janssens says:

    It seems that the list of plans showed by ”Planner.ListMyPlansV2” is not complete somehow. I found a similar issue ( but in my case the list of shown plans is not the same as ”Recent” in the planner app…
    Additionaly, I found the ”Planner.ListMyPlansV2” is deprecated?


    1. terhoantila says:

      Hmm, I wasn’t aware of the issue with the list of plans, thanks for pointing that out!

      Yes, I’m aware of the deprecation of that specific method – upgrading it is on my backlog.


      1. Ah yes, I see on your youtube video that is was already on your backlog, sorry for that 😉


  2. Thank you so much for this.


    1. Jane says:

      The app is really awesome! I shared the app with my colleagues to organize our annual plan and check everyone’s loading by labels. I noticed that there’s category7-25 in planner connector. Is it possible to add category7-25 in task categories and filter by category? Thanks a million.
      PS. I tried to update it by myself, but there are errors so i’m not sure if the connector support category7-25 now.

      Liked by 1 person

      1. terhoantila says:

        I’m glad you like the app 🙂 I’ll add adding the new categories to the backlog – who knows, maybe I’ll find some time to implement it.

        Liked by 1 person

      2. loic says:

        Thanks a lot for your work around this app, it’s exactly what we need in our team. Like Jane’s comment, the app will be 100% usefull for us if we have the possibility to filter all categories (1 to 25). I tried to do, but I’m really not an expert on power apps, maybe you can told how to do it ourself. If it’s isn’t possible I wish you could implement it soon!

        Liked by 1 person

      3. terhoantila says:

        Hi all! The latest version of the app now supports all 25 categories.


      4. Jane says:

        Thanks a million, Terho!
        The 25 categories works perfectly!
        I got a question about the new version, it seems the first and the last task in Planner start/end date shown on the planner is not correct, other tasks are correct. For example, my first task in Planner is from 2022/12/01 to 2023/03/15. It shows the end date is 2023/05/15 in the Gantt chart. Not sure why the issue is caused.


      5. terhoantila says:

        Hmm, have to check this. Thanks for reporting!


      6. terhoantila says:

        Hi Jane. I am not able to reproduce this issue. Can you double check, please? Thanks 😃


      7. Jane says:

        Hi Terho,
        Thanks a lot. I put the image in github issue#13. I found it seems to be happened when the task start/end date in different years(but it seems some of the tasks are correct.) Please kinldy help to check it and let me know if you need more info. 🙂


      8. terhoantila says:

        Hi Jane. The issue with dates with long lasting tasks is now fixed.


  3. Patrick Trautmann says:

    The app looks amazing.
    Could you please add a license to your github so that we can check if we can use it in our company?


    1. terhoantila says:

      Thanks, Patrick, for the tip! MIT license now added.


  4. Matt Lomas says:

    Hello, great app concept.
    Currently fails to import with the very limited message, Something went wrong. Pleaser try again later.
    Suggestions to progress would be great.


    1. terhoantila says:

      That should have nothing to do with the actual app. Are you able to import any other Power Apps canvas app to your organisation’s environment? Are you able to see list of apps in


  5. moyura says:

    That’s brilliant, thank for sharing.


  6. Amanda says:

    Amazing, thanks for sharing, I thought I need to do some configuration to link with my planner project. by follow up the detailed import instructions, it perfectly worked with planner without adidtional setting or changes.

    Liked by 1 person

  7. Urs says:

    Great powerapp. I tested it and it work perfectly. But the current app picks ALL my plans. I saw the related comment above how to select ONE single plan when adding the app into Teams. How can I realize the same behavior within the app?
    I want to add this app as a screen to another app just showing the related planner for this app. Is there a way of hiding/eliminating the ”scr_Plans” screen or picking the related plan by default without giving the user the option to change plans.?


    1. terhoantila says:

      I’m glad you liked the app 😊 Yes, you can provide planId URL parameter to the app as instructed in another blog post here: That way you can make the app to show that specific plan only.


  8. Andres Tomlin says:

    Just want to say thank you. MS trying to push everyone to buy a Project licence just for a Gantt view is so frustrating and ridiculous. This is exactly what I was looking for. Great work!


  9. aaron says:

    This is just awesome. Thank you so much! Is there a way to export the chart to PDF? Printing the page just seems to show the current view, though the gantt chart itself is much longer if there are lots of tasks in it. Thanks a lot!


    1. terhoantila says:

      I’m glad you like the app 😊 Currently there is no way to print the entire chart if it’s higher than the visible area. Perhaps that’s something that I’ll look into at a later time.

      Liked by 1 person

  10. Brad says:

    Just to let you know. Microsoft discontinued the user voice and created a feedback portal.
    Right now there is one feedback with 25 upvotes only.
    In addition I will try to add some ”people picker” to only filter to specific peoples tasks. but maybe I will fail. This would be a great feature.


  11. terhoantila says:

    Hi! The readme file can be found at the repository root at It contains instructions on how to download and install the app for your organisation 😊


  12. Momo says:

    Hi! This is very helpful for me, thanks. IF possible, I would like to confirm the progress rate for each projects in the Gantt Chart and display ”Check list” in planner to the Gantt Chart. Could you please advise me?


  13. Adam says:

    Hi, i have just added in your app, this is looking great so far, i have one question. i have linked to my planner account but its pulling all the planners i am apart of, i only require particular planners to be available as an option to select on the front page. would you be able to help me out with this?


  14. Geert says:

    Hi, first of all, great work, very helpful, thanks! As you mentioned, ’planDetails’ only supports 6 categories, while at the time of writing this comment 25 labels are possible. Do you see any option in applying/implementing the new ’GetPlanDetails’ ( which would make it support all 25 categories/labels (I believe, at least). Thanks again!


    1. terhoantila says:

      Thank you for your interest in the Gantt chart app. Yes, I think using the new GetPlanDetails method should be possible and in fact it is in the backlog.


    2. terhoantila says:

      The latest version of the app now supports all 25 labels.


  15. Raj says:

    Thank you for sharing.

    However, I am having an issue with displaying categories/labels. I have used the first six categories and still, they will not show on the Gantt chart.

    I have the screenshot of the error I am getting for the command but cannot share it as the post does not allow me to upload pictures.

    Below is the command and error
    Concat(ThisItem.categories, Value, “, “)

    Error: Concat(ThisItem.categories, Value, “, “) = This formula uses scope, which is not presently supported for evaluation. Data type: text


    1. terhoantila says:

      The latest version of the app supports all 25 categories. Perhaps you should consider updating.


  16. David Trevor says:

    Great app, very useful! I saw you released a new version of the app recently, is there any way to update an existing canvas app or do we have to import it as a fresh app?


    1. terhoantila says:

      You can update the old one during the import process.


      1. David Trevor says:

        Thanks, worked flawlessly!

        Liked by 1 person

  17. Dang says:

    Thanks a lot for your useful app!

    I have a question about recurrent task which happen every 3 month at date 30. How to show all instance in the gantt chart?

    Thank you again!! Have a nice day!!


    1. terhoantila says:

      Hi Dang. I don’t think all those tasks are shown in Planner either – only the next one. Gantt chart only displays tasks that exist in the Planner.


      1. Dang says:

        Thank you for your quick response and once again – your great app.

        I can set in planner as it is Recurrent do when you have time, please check if you can show it in the chart. I use it to see the workload of the team so it would be better if it displays all.

        As a workaround, I can split a recurrent task as Q1 task, Q2 task… However it will display in many rows.

        Thank you for your time. Nice day!!


      2. terhoantila says:

        Unfortunately this is not possible. Planner Connector does not provide any information whether a task is recurring or not. Therefore, from Gantt Chart’s perspective, these recurring tasks are just normal tasks.


  18. Carol says:

    Hi Terho! Amazing job. However I have two issues. For the filter bucket I can change to “select multiple” but they dont appear on the Gantt chart, just the last one I clicked on. Plus, is there a way of sorting just by buckets so they dont repeat as a separate column if they have activities after a different bucket? BR


    1. terhoantila says:

      Hi Carol. It is not enough to change the bucket selector to allow multiple selections – you also need to edit the Gantt gallery’s Items property to take multiselect into account.

      And unfortunately there is no sorting functionality implemented.


  19. Eric says:

    Hello Terho,

    This app is a great construct to help with gathering all planner boards in one view. Thank you for the hard work on this power app and making it available to all of us.

    I’m still working with skeptical people in my department for using planner. I was actually just starting to try and build something that would bring together all planner info in one place as a list or something, so as a supervisor you can look at total workload across the whole team when you are running multiple boards. So your app saves me months of secondary or after hours work…LOL

    I need a little of your expert help. I was able to upload the app into my environment with no problem. The app shows all my planning boards within my big organization that I am a member. When I go to pull up a single or multiple planners it shows all the task from each of them in your gantt view. So it’s working good in that respect.

    Where I have the problem is when I click any of the links that should take me to the planner board and/or task, it tries to open it in a new tab but I get a screen that says:

    We’re not ready for you yet
    We’re still setting things up. Please try again later
    Date and Time: 4/23/2023 1:49:26 PM
    Planner Version: 16.0.16413.40754

    Then gives two links:
    <- go back
    Sign in as a different user

    I haven't published it just yet but since it was pulling the data accurately I wasn't sure if that would be the problem or if I wasn't doing something correctly. I am on a government net work but they allowed it to be uploaded and again it's pulling all the data from the boards for displaying in the app.

    Thank for your help in advanced.
    Eric B.


    1. terhoantila says:

      Hi Eric. I’m glad you find the app useful. I haven’t seen the problem you described earlier. Perhaps you could compare the URL’s when you open a plan in a traditional way (office waffle menu etc.) and from the Gantt chart. Never worked with government network customers before, so that might be the problem here..


  20. Nikolas says:

    Hello can i assign users from the power app?


    1. terhoantila says:

      Unfortunately that is no currently possible.


  21. mirko says:

    Hi Terhoantila,

    thank you for this app.

    One question: Can the color be changed?

    I installed the app as tab and everything is blue. The bottom line, the header all the tasks.

    Thank you very much.


    1. terhoantila says:

      Hi Mirko, please find the instructions on how to apply your own colors in the app 👉


Leave a Comment

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s