Forum Discussion

Gwen05's avatar
Gwen05
Copper Contributor
Jan 14, 2022

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-GOV's avatar
    Justin-GOV
    Brass Contributor
    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,

    • SamreenFathima's avatar
      SamreenFathima
      Copper Contributor
      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?
    • Gwen05's avatar
      Gwen05
      Copper 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-GOV's avatar
        Justin-GOV
        Brass Contributor
        I'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.

Resources