HELP: The date format is altered from Excel to Outlook email in Power Automate

Like (0) Share

Report

Posted on 3 Apr 2023 09:58:14 by KKOW

Hello,

I have a flow that links excel to outlook in order to send email on a schedule.

The Flow looks for a "Y" in a specific column, and then generates a template email in outlook that contains dynamic content fields from the excel document.

When it comes to the date, although it appears correctly in excel, when the email is sent through Power Automate and appears in the outlook email message, the dates appear as a number like eg 45026.

The steps in the flow are pictured below - I would appreciate any advice you can share.

I have the same question (0)

All responses (6)

Answers (0)

Chriddle 8,141 Super User 2025 Season 2 on 05 Apr 2023 at 06:47:59

Like (0)

Report

Re: HELP: The date format is altered from Excel to Outlook email in Power Automate

Have you checked the output of the List rows action and the format of the Excel column?

Was this reply helpful? Yes No
KKOW 6 on 04 Apr 2023 at 22:29:26

Like (0)

Report

Re: HELP: The date format is altered from Excel to Outlook email in Power Automate

Hi Chriddle,

Based on my googling of my issue, i had tried to update to ISO 8601 in the Date/Time format in the second step of my flow "List Rows Present in a Table".
Unfortunately that didnt seem to work, and the date (e.g 10-Apr-23) still appeared as 45026 in the outlook message.

I then tried changing the date format in excel to US, and various combinations, but no matter the changes i made in excel, 45026 still appeared.
Any ideas what i may be doing wrong - or any formatting in excel which I should apply?

Was this reply helpful? Yes No
Kaif_Siddique 2,104 Super User 2024 Season 1 on 04 Apr 2023 at 18:42:21

Like (0)

Report
Re: HELP: The date format is altered from Excel to Outlook email in Power Automate

Agree with @Chriddle on this point.

Or

- Where would I add that expression?

Date field which appear as a number in Update a row connector

- In the expression is written “Your Date”. Do I customize that expression in some way or include “Your Date” exactly as it’s written?

customize that expression - replace "Your Data" with input date

Was this reply helpful? Yes No
Chriddle 8,141 Super User 2025 Season 2 on 04 Apr 2023 at 13:43:21

Like (1)

Report

Re: HELP: The date format is altered from Excel to Outlook email in Power Automate

I think it's easier to set the DateTime format to ISO 8601 in the Excel action than to do this calculation.

Was this reply helpful? Yes No
KKOW 6 on 03 Apr 2023 at 20:45:19

Like (0)

Report

Re: HELP: The date format is altered from Excel to Outlook email in Power Automate

Hi Kaif,
Thank you for your advice.
Im a new user of Power Automate, so can I please clarify a couple of points,
- Where would I add that expression?
- In the expression is written “Your Date”. Do I customize that expression in some way or include “Your Date” exactly as it’s written?
Many Thanks!

Was this reply helpful? Yes No
Kaif_Siddique 2,104 Super User 2024 Season 1 on 03 Apr 2023 at 18:37:08

Like (0)

Report
Re: HELP: The date format is altered from Excel to Outlook email in Power Automate

Use the below expression to convert numerical value to date:

addDays('1899-12-30',int(<<Your Date>>),'yyyy-MM-dd')

Was this reply helpful? Yes No