Forum Discussion
Automated task creation in Premium plan
Hi,
I'm wondering if it's possible to automatically create a Planner Premium task from a Teams post. I've spent a day trying to bottom this out, and I've had no luck. I tried using PowerAutomate with the Dataverse connector, but it seems like adding a new row to the Project Tasks table in Dataverse is not a supported way to create new tasks. If this is supported, is there documentation on how to do this?
This is a very simple process in Basic plans - doesn't make sense that it's so hard to do this in a product I'm paying for!
Since the Premium plans are essentially what used to be called Project for the Web projects, I assume that they would need to be updated via the Project Schedule APIs. This means that the updates have to go through the Project Scheduling Service (PSS), not directly via Dataverse table actions. It involves creating an Operation Set, which is then passed to the PSS that's responsible for maintaining transactional consistency.
You can find a very detailed description from this blog post by Antti Pajunen: Project Operations and Project for the web: Schedule API guide for Power Automate users.
Now, for a more simple step-by-step process, this blog post by Leoza Kabir Barker looks like it would cover your needs for task creation in Microsoft Planner Premium plans: Power Automate: Create Project Tasks directly into Project for the Web.
UPDATE: I just tested this in my own tenant and it seems to work just fine. Here's a screenshot of the flow I created, using the above mentioned blog post as guidance.UPDATE 2: I wrote a longer article about the story behind this dependency of Microsoft Planner Premium plans to the Project Scheduling Service - and all the way up to the MS Project Windows executable.😆
Perspectives on Power Platform: Microsoft Planner and the revenge of MS Project
8 Replies
I cannot even go in there to upvote. Microsoft should hotfix this immediately. It is not acceptable to have a broken "premium" product.
Thanks JukkaNiiranen for the detailed and thorough response!
Since the Premium plans are essentially what used to be called Project for the Web projects, I assume that they would need to be updated via the Project Schedule APIs. This means that the updates have to go through the Project Scheduling Service (PSS), not directly via Dataverse table actions. It involves creating an Operation Set, which is then passed to the PSS that's responsible for maintaining transactional consistency.
You can find a very detailed description from this blog post by Antti Pajunen: Project Operations and Project for the web: Schedule API guide for Power Automate users.
Now, for a more simple step-by-step process, this blog post by Leoza Kabir Barker looks like it would cover your needs for task creation in Microsoft Planner Premium plans: Power Automate: Create Project Tasks directly into Project for the Web.
UPDATE: I just tested this in my own tenant and it seems to work just fine. Here's a screenshot of the flow I created, using the above mentioned blog post as guidance.UPDATE 2: I wrote a longer article about the story behind this dependency of Microsoft Planner Premium plans to the Project Scheduling Service - and all the way up to the MS Project Windows executable.😆
Perspectives on Power Platform: Microsoft Planner and the revenge of MS ProjectHow did you source the projectID and BucketID?
You could browse the underlying Dataverse tables via Power Apps maker portal, for example, and get them from there:
Thanks - your article looks fascinating!
- I have roughly the SAME scenario, and have dug into this a lot deeper.
The problem affects the Graph API. The reason Flows and Power-Automate fail on Premium Plans is because they rely on GRAPH and the Planner API is not complete or only has HALF the functionality. You can read a plan, read a bucket and read tasks, but you cannot POST/PUT (Create/Update) anything on a PREMIUM Plan.
I blogged about it here:
https://theofficecontext.com/2024/10/22/403-error-with-planner-api/
And I have added product feedback request here:
https://feedbackportal.microsoft.com/feedback/idea/91794c73-0e87-ef11-9442-6045bdb4f28f
Please, PLEASE, PLEASE, if you are reading this because you are trying to get a Premium Plan to work with your flow or automation OR you are getting a 403 error on a POST/PUT, PLEASE UPVOTE.I will definitely up vote this. Thanks!
