cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Planner triggers in Flow

Hi,

I need to set up a flow that triggers when a Planner Task is completed. And since I have many Planner Plans I would like to set up a single flow that will trigger when ANY Planner Task is completed across all Planner Plans.

Any ideas?

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
v-yamao-msft
Community Support
Community Support

Hi @Anonymous ,

 

Trigger When a task is completed could be only used for a specific plan, if you would like to set up a single flow that will trigger when any planner task is completed, please feel free submit a request on Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

Further, I have figured out the following workaround for your reference. My scenario is to get all the tasks in each plan, then filter out completed tasks, which completed date is Today.

 

I am using a button trigger, however, you could use Recurrence as well.

 

Initialize a String variable named as Test1.

 

List tasks from one Plan.

 

Add Filter array, select value from List tasks. Then input the following code:

@and(equals(item()?['percentComplete'], 100),equals(formatDatetime(item()?['completedDateTime'], 'yyyy-MM-dd'), utcNow('yyyy-MM-dd')))

 

Add Apply to each, select value from Filter array body, add Append to string variable, set its value likes below:

1.PNG

 

The same configuration with other plans.

2.PNG

 

In the last step send an email, configure the body likes below, and make sure select Yes for Is HTML field.

3.PNG

 

A full image for your reference:

4.PNG

 

Best regards,

Mabel

 

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

View solution in original post

1 REPLY 1
v-yamao-msft
Community Support
Community Support

Hi @Anonymous ,

 

Trigger When a task is completed could be only used for a specific plan, if you would like to set up a single flow that will trigger when any planner task is completed, please feel free submit a request on Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

Further, I have figured out the following workaround for your reference. My scenario is to get all the tasks in each plan, then filter out completed tasks, which completed date is Today.

 

I am using a button trigger, however, you could use Recurrence as well.

 

Initialize a String variable named as Test1.

 

List tasks from one Plan.

 

Add Filter array, select value from List tasks. Then input the following code:

@and(equals(item()?['percentComplete'], 100),equals(formatDatetime(item()?['completedDateTime'], 'yyyy-MM-dd'), utcNow('yyyy-MM-dd')))

 

Add Apply to each, select value from Filter array body, add Append to string variable, set its value likes below:

1.PNG

 

The same configuration with other plans.

2.PNG

 

In the last step send an email, configure the body likes below, and make sure select Yes for Is HTML field.

3.PNG

 

A full image for your reference:

4.PNG

 

Best regards,

Mabel

 

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

View solution in original post

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!

Top Solution Authors
Top Kudoed Authors
Users online (2,124)