Forum Discussion
Planner - How to export Date and Time to Excel ?
Hello, The export Planner to xls is very convenient to run deeper analysis of the data. However, it looks like the dates (creation date, start date, end date) are not fully exported as Date+Time. I ...
I'm not sure the default Excel export includes time in those fields.
If you have experience with Microsoft Graph you could script an export for those plan details. Those queries do include Date and Time.
Sample Query to graph: https://graph.microsoft.com/v1.0/planner/plans/{plan-id}/tasks
Here is some sample information of what graph produces:
"startDateTime": "2022-01-12T16:00:05.5720315Z",
"createdDateTime": "2022-01-12T16:00:05.6551753Z"
"dueDateTime": "2022-02-19T08:00:00Z",
"completedDateTime": null,
If you have experience with Microsoft Graph you could script an export for those plan details. Those queries do include Date and Time.
Sample Query to graph: https://graph.microsoft.com/v1.0/planner/plans/{plan-id}/tasks
Here is some sample information of what graph produces:
"startDateTime": "2022-01-12T16:00:05.5720315Z",
"createdDateTime": "2022-01-12T16:00:05.6551753Z"
"dueDateTime": "2022-02-19T08:00:00Z",
"completedDateTime": null,
Justin-GOV thanks for your reply. I am not familiar with graph at all. I gave it a try using my plan-ID as suggested but I am getting an error message back.