
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:
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 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')