G'day
I am having trouble trying to find a way to make Excel more dynamic.
Here is the use case
I need to have all Planner tasks that are assigned to me available for my manager to quickly look at so they can see my current workload without having to dig through Planner itself.
What I wish to do is have all my tasks from Planner populate an Excel spreadsheet which will everyday dump what my tasks are.
The catch is I also need it to Update or at least delete the old information. so everyday I get a fresh dump of what is on my planner board without it doubling up in the spreadsheet.
I can create a macro to erase info from the spreadsheet every day or use Excel to hide information with a certain date stamp but that becomes difficult to manage and rather clunky.
This is the flow i have now which does not fully work as it fails when it comes to the Row ID im not sure how to set that field to get it to always look at all the rows and update all of them. All I can get so far is the dump of all my tasks over and over so they duplicate everytime the flow runs. I put the Current time in the flow as a way to work out when it was dumped so i can see which is a duplicate.
Excel Flow part 1
Excel Flow part 2
Any advice or solution would be very welcome
Cheers
Tristan
