cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
luisv
Helper I
Helper I

Creating a flow to have planned update a row in an excel table

I would like to create a flow that allows me to update a planner task and it will update a current column in my excel table. Something like: I go into planner update a task ie “ in progress” section from “ not started” to “ in progress “ and it will will change a column in my table to a unique word like “shipped” from “in process”. Can this be done?
1 ACCEPTED SOLUTION

Accepted Solutions
v-alzhan-msft
Community Support
Community Support

Hi @luisv ,

 

As @efialttes  said the trigger "When a planner task is updated" is not supported in microsoft flow currently, so your requirment to update a column in table when a planner task is updated is not supported in microsoft flow currently.

 

If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

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

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
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

3 REPLIES 3
efialttes
Super User
Super User

Hi

I don't think so.

Current Planner connector supports the following triggers:

https://docs.microsoft.com/en-us/connectors/planner/#triggers

So you have 'When a task is created' and 'When a task is completed' but you do not have 'When a task is updated' yet.

 

You can perform syncronization once a day, or once an hour by means of the recurrence trigger, but you cannot have sync on real time

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



v-alzhan-msft
Community Support
Community Support

Hi @luisv ,

 

As @efialttes  said the trigger "When a planner task is updated" is not supported in microsoft flow currently, so your requirment to update a column in table when a planner task is updated is not supported in microsoft flow currently.

 

If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

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

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
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

luisv
Helper I
Helper I

Thank you all for a fast response! I hope they add those features. You all have been extremely helpful!!!

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,448)