Feb 09 2024 09:44 AM
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
Sep 27 2024 12:22 AM
Sep 27 2024 03:18 AM
@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