Forum Discussion

ClaudiaSa25's avatar
ClaudiaSa25
Copper Contributor
Feb 09, 2024

Attributes.LastModifiedTime - what does it represent?

Dear All,

 

I am using power query to get some data from an outlook group mailbox. I would like to use this column Attributes.LastModifiedTime with Date Received to calculate Turnaround time. 

 

I just noticed that this column Attributes.LastModifiedTime was modified due to the fact that on some mails I had flags, and thus this column reported todays date when the flag was removed instead of when I replied to this mail. 

 

What would be the use of Attributes.LastModifiedTime? I checked and with some other mails this is equal to the date and time I responded to that mail. 

 

Thanks so much

excel
exchange
microsoft 365
    • ClaudiaSa25's avatar
      ClaudiaSa25
      Copper Contributor
      Sep 27, 2024

      franstomas no, I didn't get any reply. I found a workaround to give each mail a unique ID when received and aggregate all with Power Query based on  Attributes.ConversationName. This would than allow to get the exact received and last reply time and date. No ideal, but this was the compromise I got.

      Hope this helps

Resources