You’re offline. This is a read only version of the page.
6
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.
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?
Agree with @Chriddle on this point.
Or
- 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?
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!
Use the below expression to convert numerical value to date:
Share
Report
All responses (
Answers (
addDays('1899-12-30',int(<<Your Date>>),'yyyy-MM-dd')
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
