Have my HTML to Text caputure the date of the email instead of the date entered.

[Em27]

I'm currently running flow that captures certain parts of a body in an email and adds it to a excel table. I was looking at ways to adjust it so it also captures the date and time of the email was received instead of the time it was entered into the table. 

[VictorIvanidze]

Show your "Get emails copy" action in edit mode.

[DJ_Jamba · Accepted solution]

Hi @Em27 

The timestamp of when the email was received is in property receivedDateTime

[Em27]

So that works, I need to convert it to a different time zone. I see the code as 

items('Apply_to_each')?['receivedDateTime']. I know I should be able to convert it as I have in the past with convertTimeZone('2024-01-01T08:00:00.0000000Z', 'UTC', 'Eastern Standard Time') 

But I'm unsure who to do it with an Dynamic content 

[DJ_Jamba]

Hi @Em27 

Not at a pc right now but it should be something like the following:

Date and Time:

convertFromUTC(items('Apply_to_each')?['receivedDateTime'], 'Eastern Standard Time', ‘MM/dd/yyyy hh:mm:ss’) 

Date Only:

convertFromUTC(items('Apply_to_each')?['receivedDateTime'], 'Eastern Standard Time', ‘MM/dd/yyyy’) 

Time only:

convertFromUTC(items('Apply_to_each')?['receivedDateTime'], 'Eastern Standard Time', ‘hh:mm:ss’) 

which needs to be entered as an expression. So click on the required field select the expression tab in the popup (not dynamic tab). Then paste one of those formulas and click done. 

[Em27]

Thank you, marked as solution as you were able to solve the question I was having. No rush btw, but I am getting this error now though. 

Perhaps It wasn't capturing a UTC time from the email. I'm unsure...

[DJ_Jamba]

It's because Outlook is outputting time zone info as well.

Use the Convert time zone action

[DJ_Jamba]

Glad you're all sorted!

Just @mention me if there's any problem with that action

d(-_-)b

[Em27]

I was able to add the convert time zone to the expression and it is now working correctly. Thank you @DJ_Jamba 

[Em27]

Last question I hope for a while @DJ_Jamba , The automation you helped me with was mainly to help recover lost data from my emails that piled up while my system was down, but is not my main data resource/Automation. I was looking at adding just the Mark email as read action to my main automation. Again this is my 2nd automation and I've learned so much just from playing around... Thank you for your support/help on this. If you'd prefer me to make a new post I'll do so. I believe its a straight forward issue but I'll run it by you real quick just not sure where to start. 

When email arrives > *Apply to Each* > Want it to HTML to text it > Filter Array > Add it to a table in Excel > *Mark as read* was the added action * *. 

[DJ_Jamba]

Hi @Em27 
Could you start a new post? It would really help the community if an answer to a question is not buried in another question.

Hope you understand 🙂

[Em27]

absolutely understandable. I'll make a new post in just a bit. Thank you for the help. Great community support truely!