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

[mmace1]

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?

[Anonymous]

@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]

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.