Forum Discussion
Gwen05
Jan 14, 2022Copper Contributor
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 can only retrieve dd-mm-yyyy for each. Is there a trick to get the time, or does it require further enhancements to the export function ?
- Justin-GOVBrass ContributorI'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,- SamreenFathimaCopper ContributorHi 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? - Gwen05Copper Contributor
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.
- Justin-GOVBrass ContributorI'm sorry. It does require some experience with Graph. The link I provided requires Graph experience to get it to work. It will require some specialized knowledge if you have anybody you work with may be able to develop something for you. I just wanted to let you know that the information is there, just not for the Excel export.