Answered

My email is showing date as numbers not date?

(0) Share

Report

Posted on by Dougers1

Let me start by saying Hello, i am a newbie to power automate flows and am in middle of building a flow that will email the data from a excel sheet. i seem to have it working apart from the date of assignment and time of assignment

screen shot of my flow

how do i sort this

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Srini007 3,467 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Dougers1

Check below post for your reference

https://powerusers.microsoft.com/t5/Using-Flows/Convert-excel-numerical-dates-to-date-MS-FLOW/td-p/408590

If you find this reply helpful, please consider giving it a LIKE AND

If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION

Thanks,

Srini

Was this reply helpful? Yes No
Dougers1 99 on at

Like (0)

Report
Copy link

Link copied!

im getting this
Date of the Appointment 2023-10-20T00:00:00.000Z2023-10-20T00:00:00.000Z
Time of the Appointment 1899-12-30T08:35:00.000Z

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Dougers1,

Please check the following steps:

1). Please select the date formate as ISO8601 as below:

2). Then in the email body tab, please formate the date time as below:

formatDateTime(items('Apply_to_each')?['YourDateField'], 'dd-MM-yyyy')
formatDateTime(items('Apply_to_each')?['YourTimeField'], 'hh:mm:ss')

If it does not solve your problem, please show me your excel date time configuration.

Was this reply helpful? Yes No
Dougers1 99 on at

Like (0)

Report
Copy link

Link copied!

Thanks this worked 🙂

Was this reply helpful? Yes No