Tell Us More: Views and Reporting Options in Planner

I have what I think is a very cool idea for my team at least.  We are using checklists a LOT and love that technology.  In the background in the List Tasks function we are pulling tasks and by way of checklist items completed versus created we are creating a percentage of task complete. 

I was using Pivot Tables in excel based on all the data I can output from Connector and the CSV output to One Drive and then I tie all that data together in Excel.  I will try and attach sample here.  However, I can only output 400 items from the Preview Connector for Planner in Flow - not sure why the 400 item limit exists.

Last update of Planner however changed the order of columns in the CSV output so that is a pain.  If you look at the PIVOT table tab in the attached you'll see what I'm up to.  It is very handy for me for a staff of 11 to be able to see what everyone is working on with this PIVOT. 

My best to you and your team - Planner keeps getting better and better - it would be nice to apply a time estimate or an effort rating to each task.  We use labels for priority weighting already.

Cheers,

Tim Grim  tim.grim@genexservices.com