Attributes.LastModifiedTime - what does it represent?

Copper Contributor

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

2 Replies

@ClaudiaSa25 

Did you get any reponse here? Also want to know what changes this attribute.

 

br,

Frans

@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