New to Power Automate so struggling a little.
So this is what I want to do:
I want to send a Planner Task details to Excel Online when a new task is created.
So in Flow I need to extract the following fields from the newly created Planner Task:
I have added the Trigger 'When a task is created' - so far so good. The Flow picks that New Task up.
But the problem I am having is getting the Start date and Due date. Because when you Add a Task to Planner you then have to go into the Task you just created to set the Start date.
I thought a solution might be to add a Delay of 5 mins after the Trigger 'When a task is created'. Because I am guessing when you add a Task to Planner the Flow runs instantly so how would the Flow pick out this other information (Start date + Due date)?
I hope that makes some sort of sense lol.
"I am guessing when you add a Task to Planner the Flow runs instantly so how would the Flow pick out this other information (Start date + Due date)?"
I guess it depends on the way you create the planner task, but in some circumstances you will get Due Date empty... and unfortunatelly there is not any "When a task is created or modified" trigger
Did you consider an alternate approach? THat is, to have a recurrence trigger executed daily (at night), now list tasks, for those that are not yet in your Excel, add them. Does it match with your requirements?
Some threads on this approach in this same community
Hope his helps
Thanks for getting back to me so fast! Ahhh I see. I have been messing around trying to get it to work with trial and error lol. Not knowing it cant really be done.
That seems like a good solution though. So you can set up the recurrence trigger to only add those TAsks which have not been already added to my Excel?
You can set the recurrence trigger to be executed every hour, or daily, weekly...
Now I am assuming you stored in every excel row the corresponding Task Id in an specific column
1.-You get all Planner tasks by means of 'List tasks'
2.-You get all Excel rows by means og 'List rows present in a table'
3.-NExt, you iterate all through your 'Lists tasks' output by means of an 'Apply to each'
INside the 'Apply to each':
-you add a 'Filter Array' action block, assign as its input 'List rows present in a table' output. Now, the condition of 'Filter Array' shall evaluate if Planner 'Task Id' matches with Excel 'Task Id column' value, you can add them from Dynamic Content menu.
-you add a Condition action block, to evaluate nr of elements in "Filter array" output, If nr equals 0, this means Task is not yet exported to Excel. Assuming you used the english default name suggested by Flow editor for 'Filter Array' , add the following expression on the left term:
Several threads discussing this approach, one of them here -more complex than the text description I provided-
Hope this makes sense
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.