Power Platform Community Forum Thread Details

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.

Categories:

Building flows