Getting email time stamp to be pulled from and used instead of when posted to my excel spreadsheet.

(0) Share

Report

Posted on by Em27

My flow current works like this. Email comes in > Converted to HTML to Text > it reads that captured information and adds the outputs to an excel document.

Issue one 1: for the Date column I use:

formatDateTime(convertTimeZone('2024-04-01T12:00:00Z', 'UTC', 'Eastern Standard Time'), 'MM-dd-yyyy')

For time I use:

formatDateTime(convertTimeZone(utcNow(), 'UTC', 'Eastern Standard Time'), 'HH:mm:ss')

or capturing the Date to be added into the column has been working find until 4/1 where now my excel spreadsheet says the "Column formula is inconsistent." every date that is entered is now 4/1 and I have to manually update to today's date.

So my question is how do I change it to just capture the date and time from the email?

I've done this in the past with a Apply to each when capturing past email that I was recovering. but I don't have an apply to reach action and didn't want to mess with the flow too much if I didn't need too.

thank you for any additional insights on this.

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Em27 72 on at

Like (0)

Report

Re: Getting email time stamp to be pulled from and used instead of when posted to my excel spreadsheet.

I was able to resolve this after I posted it... I guess i just needed to work it out by typing.

formatDateTime(convertTimeZone(triggerOutputs()?['body/receivedDateTime'], 'UTC', 'Eastern Standard Time'), 'MM/dd/yyyy')

For the Time
formatDateTime(convertTimeZone(triggerOutputs()?['body/receivedDateTime'], 'UTC', 'Eastern Standard Time'), 'HH:mm:ss')

Was this reply helpful? Yes No