Answered

Date Issue

(1) Share

Report

Posted on by Ciaran

261

I have a flow which issues emails from an Excel mailing list stored in TEAMS. I have a date field in the Excel spreadsheet which is formatted as a date field. When I merge this date field onto the email the date is coming out as a string. I have tried to use expressions but always get errors. Any help to change this to a date field would be greatly appreciated.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Sort by

rzaneti 4,491 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi,

All dates in Power Automate are represented as a "special type of string", the timestamp, which can be formatted according to your needs. Assuming that you returned these dates from Excel as ISO8601, you will have a timestamp that can be formatted with expressions. You can refer to this article for some examples on how to format dates in Power Automate.

Can you please share a sample on how exactly do the dates look like in the email, and what is the expected date format?

Let me know if it works for you or if you need any additional help!

-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.

http://digitalmill.net/

https://www.linkedin.com/in/raphael-haus-zaneti/

Was this reply helpful? Yes No
Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @ Ciaran

could you share what expression u are using on for which u are getting errors ?

Thanks & Regards,
Nived N
LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs
Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you!

Was this reply helpful? Yes No
Verified answer

CFernandes 8,504 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

Hey Mate,

Please provide a bit more details "List rows present in a table" you can force it to ISO Format.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No