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,
Hi Justin,
Thanks for the info. It works.
Could u also let know on how the timestamps from the JSON response returned using the provided Graph Query be exported to Excel from the Planner?
Thanks for the info. It works.
Could u also let know on how the timestamps from the JSON response returned using the provided Graph Query be exported to Excel from the Planner?