Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
The ability to connect to an Exchange server is fatastic. Has anyone found a place where the "Replied to" timestamp resides in the data connection?
Solved! Go to Solution.
Also there's an attribute called IconIndex in the Attributes Record column, you can also add a check where the received email has that flag value "MailReplied", so that you won't have to do a search for emails that weren't replied to.
Thank you both for the suggestions; I will attempt both shortly. Ideally I was trying to create a calculated column from time of the origional email to the timestamp it was replied to. This would allow me to monitor the response times under various conditions for a team email box. These methods may allow me to get there with an extra step or two I hope.
Thank you both for the suggestions; I will attempt both shortly. Ideally I was trying to create a calculated column from time of the origional email to the timestamp it was replied to. This would allow me to monitor the response times under various conditions for a team email box. These methods may allow me to get there with an extra step or two I hope.
Hi @alangenfeld,
Based on test, I can't find the “Replied to timestamp”. Since the mail table stored the “DateTimeReceived” and “DateTimeSent”, you can refer to below formula to get the “DateTimeSent” as the “replied to timestamp”.
Table = FILTER(Mail, AND(ISERROR(SEARCH("Sent Items", Mail[Folder Path]))=FALSE(),ISERROR(SEARCH("RE:", Mail[Subject]))=FALSE()))
Notice: The formula is used to filter the table which “folder path” is “send items” and “subject” contains “RE:”, the “DateTimeSent” is the “replied to timestamp”.
Regards,
Xiaoxin Sheng
Also there's an attribute called IconIndex in the Attributes Record column, you can also add a check where the received email has that flag value "MailReplied", so that you won't have to do a search for emails that weren't replied to.
How about if the email was forwarded? I tried a test and got "Default", does this mean Forward?
Hi @arify,
I am currently exploring a shared inbox in outlook. We are trying to compute the time from when an email was received up to when it was first replied to. I can't seem to find where MailReplied is. Is it in Attributes?
Proud to be a Super User!
Looking to do the samething. Did this ever get figured out?
@Wkbdrguy @danextian Expand "Attributes" Column and choose IconIndex. "MailReplied" is the value inside the cell
I figured a solution to it but it is kind of complex and I don't have a copy of the PBIX anymore since I left my previous company. One thing's for sure: connecting to OWA can be very slow.
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.