cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
SchwerzmannC
Level: Powered On

Project Tasks to Planner Tasks

Good day!

 

I'm pretty new to Flow/JSON and all this.

But I was able to create a flow that brings all newly created Tasks in our Projects (MS Project Online) directly in our Team Planner.

 

Flow 1.JPG

 

But I do now have the problem, that I have to assign and date all task manually, as these things are not being considered when the tasks are created in Planner.

When I try to choose the Start and Due Date from Project, I do receive an error message:

 

image.png

 

I also tried to play with custom connectors. But being pretty new to all that, I always get errors with my connectors:

 

Flow 2.JPG

with according error message:

 

image.png

 

 

Has anyone solved this? And was able to get those information out of Project into Planner?

 

Any help is appreciated!

Thank you!

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Project Tasks to Planner Tasks

Hi @SchwerzmannC,

 

Please refer to screenshot below to created the flow:

Capture.PNG

 

The expression in the Start Date Time field as below:

formatDateTime(triggerBody()?['TaskStartDate'],'yyyy-MM-ddTHH:mm:ssZ')

The expression in the Due Date Time field as below:

formatDateTime(triggerBody()?['TaskFinishDate'],'yyyy-MM-ddTHH:mm:ssZ')

 

Best regards,

Alice

 

View solution in original post

3 REPLIES 3
Community Support Team
Community Support Team

Re: Project Tasks to Planner Tasks

Hi @SchwerzmannC,

 

Please refer to screenshot below to created the flow:

Capture.PNG

 

The expression in the Start Date Time field as below:

formatDateTime(triggerBody()?['TaskStartDate'],'yyyy-MM-ddTHH:mm:ssZ')

The expression in the Due Date Time field as below:

formatDateTime(triggerBody()?['TaskFinishDate'],'yyyy-MM-ddTHH:mm:ssZ')

 

Best regards,

Alice

 

View solution in original post

SchwerzmannC
Level: Powered On

Re: Project Tasks to Planner Tasks

Hi @v-yuazh-msft

 

Thank you very much! It finally takes over the right time stamps.

 

But I am still struggling with the Assigned User Id in Planner Task.

I've tried it with several functions (like parameters(), replace(), etc.).

The string for the email in Project is 'Email', in Planner the assigned user id is 'assignments'.

And it says it's the id or email address of the user. So I thought, if I get the email address from the task to that field, it should work?

But I always get error messages, at it seems not to work?

 

Also if I try to build it up with "Get User Profiles", it simply puts me the last User in all tasks that are created in Planner:

Capture.JPG

 

Any ideas here?

Thato
Level: Power Up

Re: Project Tasks to Planner Tasks

Thank guys for the information 

 

I need your help in designing a workflow that would automatically generate a Plan in Microsoft teams, After publishing a Project the flow should create a Plan in MS Planner in Microsoft teams. To do, buckets and assigning team members should be able to be updated on MS projects or Bi-directional 

 

Please help 

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 155 members 5,399 guests
Please welcome our newest community members: