cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
piersm2
Regular Visitor

Outlook task to planner

Hey everyone I need help with my flow.  It is creating the planner task, but I want to assign the planner task to the outlook task individual, but it is not working.  Can you assist me with this?  Also, I want to mark the planner task when the outlook task is completed.

4 REPLIES 4
rmoore
Advocate I
Advocate I

Hi @piersm2 ,

 

What are you using for your trigger?  Is this based on a calendar event or an email?

 

I tested with a calendar event and was able to assign each required attendee to the task.  You will need to create an Array of the attendees to iterate through (I used a Compose data function).

 

Planner1.jpg

For some reason, if you try to do the split off of the Trigger Required Attendees field, Power Automate doesn't give you the option to chose the Required Attendees field.  So, if you put a Compose action in and set it to the Required Attendees value, you can then do a second Compose where you use the Split function.  The required attendees are separated by a Semi-colon, so use that as the character to split the string.  This will give you your Required Attendees array.

 

Planner2.jpg

 

Then run an Apply To Each for the Output of the Array.  Keep in mind that in the Array above, I had 3 required attendees but it give me 4 entries, one that is blank.  To account for the blank, and not have an error thrown, use a Condition to check that each item is not blank.

 

Planner3.jpg 

 

Let me know if you have any questions.

 

 

piersm2
Regular Visitor

I am using a created outlook task to trigger the creation of the planner task.  Screen shot is what I want, but I need to pull out email address from the user profile to use in the "Assigned User Ids" box.  Thoughts?

2020-06-08 10_01_25-Edit your flow _ Power Automate and 1 more page - Work - Microsoft​ Edge.png

Got it.  One thing I noticed was if I created the Task in my "To Do" app, i didn't have the ability to assign the task to someone until the task was already created.  Thus, Assignee was always Blank ("Assignee":"").  However, if I created the task in my Outlook, I could assign the task to someone before it was created and that populated the Assignee field.

 

Planner_outlook2.jpg

 

When added to the To Do app:

 

Planner_outlook3.jpg

 

When added through Outlook:

 

Planner_outlook.jpg

 

If you are adding to the To Do app and you have to assign the task after it's created, you could try a Do Until condition and have it keep trying until the assignee isn't blank.  But I would suggest adding in Outlook and assigning before the task is created.

 

 

UPDATE:

 

I realized I didn't answer the second part of the request - Update the Planner task as complete when the Outlook Task is marked as Complete.  I've built the full solution below, including assigning the Planner task to the Outlook task Assignee.

 

Start with the Trigger of creating a Task.  The assignee comes through as the Display Name.  You will need to search for the User with the Search For Users action in the Office 365 Users Connector.  From there you can create the Planner Task with the required details, using the Email returned from the Search for Users action.

 

NewFlow1.jpg

You'll notice that I initialize a PlannerTaskId Variable.  This is needed for the final step of updating the status to Completed.  It is of type String.

 

The task has been created in Planner and assigned to the user.  Now we need to update the Planner Task when the Outlook Task is completed.  To do this, we will create a String Variable to hold the value of the "Status" of the task.  We'll then go through a Do Until Loop until the Status is "Completed".

 

NewFlow2.jpg

A few things to note about the Do Until loop.

  1. You will need an action in the loop or it will time out.  The Delay will add time between tries and the Set Variable will get the latest status of the Task.
  2. The Count and Time Out fields for the loop.  The Count will perform the Do Until this many times.  I'm pretty sure the limit is 5000. 
  3. The Time Out field is how long the Do Until loop will perform the action if it hasn't reached the Count limit. 

By default the 2 fields are 60 and 1 hour.

 

 

Finally, once the status of the Task has been updated to Completed, we now update the Planner Task as well.  Use the Update a Task Actgion and use the PlannerTaskID variable for the Task ID field. Set the Progress to complete and you should be good to go.

NewFlow3.jpg

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (2,563)