Power Platform Community Forum Thread Details

Hello, I created a simple flow that will take data from an Excel table, plug it into a SharePoint doc, and then create a new copy of the doc per row in the table.

Everything plugs in fine except a field that is supposed to plug in a date. The date for example should be 7/14/2023, however, when it comes out in the Word doc, it is 45121. I can't fathom why it would come out as this. It did this for a couple dozen documents and they're all random numbers. Can someone help me figure out why this might be happening?

Thanks!

Categories:

Building flows

Hi @prncsclo ,

This is happening because date fields are represented in a "Serial" format in Excel, while they are represented as ISO 8601 in Power Automate. To solve that, click in "Show advanced options" and then you can set the "DateTime Format" dropdown to ISO 8601 (highlighted in yellow):

If you are using the new designer, enable the "DateTimeFormat" in the "Advanced parameters", and then set it as ISO 8601:

This option is available for "List rows present in a table" and "Get row" actions 🙂

I'm also sharing a blog post that I wrote in the past about this topic: http://digitalmill.net/2023/08/18/formatting-dates-from-excel-in-power-automate/

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/