Forum Discussion

mmace1's avatar
mmace1
Impactful Individual
9 years ago

(Outlook Exchange Server) - Attributes.ExtendedProperties.TaskDateCompleted time data is missing

Hi,

 

I'm pulling over when people flagged an email "completed".  If you check in Outlook directly, it shows the date & time someone flagged an email completed, no problem. 


When I connect with Power BI however, I see the Attributes.ExtendedProperties.TaskDateCompleted category, and it shows the date. But, the time is always 7:00:00 AM.

 

Anyone else experience this, or have any idea what's going on?

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    mmace1,

    I test the scenario as yours, the data in  Attributes.ExtendedProperties.TaskDateCompleted doesn’t  change when I flag an email completed, only the Attributes.LastModifiedTime column changes the time along with the completed time.

    Based on my reserach, the Attributes.ExtendedProperies is related to custom data in Outlook, I would recommend you contact outlook support about what Attributes.ExtendedProperties.TaskDateCompleted refers to.

    Regards,
    Lydia

    • mmace1's avatar
      mmace1
      Impactful Individual
      9 years ago

      OK, thanks!  Good to know that's not just something with our system.

       

      Thanks, I went ahead and posted the question there.

       

      Attributes.LastModifiedTime does show the checkmark, but it also shows - simply any last modified time (whatever that modification was).  That's a pretty good proxy for the green checkmark time-date.  It just seems weird the exact one I want, doesn't seem to be preesent.