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

A Flow that checks the status of a planner task

Hey Everyone, 

 

I need help creating a flow that will check the status of my tasks in microsoft planner and then sending specific emails depending on their status. Also if the tasks is complete, I would like to update a sharepoint list item. 

 

Is this something that is possible? 

 

Best, 

 

J.O 

5 REPLIES 5
v-bacao-msft
Community Support
Community Support

Hi @jortizfr5195,

 

Yes, this is achievable.

But there are a few points in your needs that are not clear.

Q1: "check the status" refers to checking whether the task has been completed?

Q2: Is it only checking the assignment of your own task?

Q3: If you only check the assignment of your own task, then the mail seems to only need to be sent to yourself.

Q4: update the details of the list item, what needs to be used in the task

 

For the content you currently provide, the Flow configured for you is roughly as follows. If it is consistent with your needs, you could use it for reference:

  Use the List my task to get all the tasks assigned to yourself.

  Use Filter array to get the uncompleted task, if the value Completed by is empty, then use Select to select the field you want to view.

43.PNG

Create a Html table and send it as the body of the email.

44.PNG

Use Apply_to_each to traverse the completed task and update the item.

45.PNG

Please take a try. 

Or provide more details about you requirements.

 

Best Regards,

Barry

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-bacao-msft

 

Thanks for the reply. 

 

To answer your questions: 

 

Q1: "check status" does indeed refer to checking if the task has been completed.

Q2 + Q3: I was hoping to check the status of ALL of the tasks within the planner and email the person the task is assigned to accordingly. 

Q4: Im a bit confused by this point. 

 

Best, 

 

JO

Hi Barry,

This is really helpful. How to include tasks that are with the status 'In Progress' along with the email for this?

Also looking for a way to include the status into a Flow, have you had any luck @Harisriram @jortizfr5195

Hi,

The 'value' mentioned under Filter Array is the one you should use to include the status in the Flow.

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!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Users online (2,142)