Excel Date format - not ISO

(0) Share

Report

Posted on by Community Power Pla...

Hello everyone,

i am having a lot of trouble with my PowerAutomate flow.

The flow is that a form entry with Start and End date gets saved to excel (advanced option: Date/Time Format: ISO 8601) together with a unique ID. With another form you can make a change to the previous entry (based on the ID).

The flow should then gather the Start and End date from the Excel Sheet, put in an eMail and send it to someone for approval. When i process the dates it always creates an error message with the oh so familiar "date string "446587" or such.

Funny enough the SAME IDENTICAL FLOW (copied it) works fine..

Can anyone point out some helpers?

Categories:

Business Process Flows

All responses (1)

Answers (0)

tom_riha 10,127 Most Valuable Professional on at

Like (0)

Report

Re: Excel Date format - not ISO

Hello @Kastore ,

I had the same issue recently and it solved itself once I changed the Power Automate language to English. But I'm not sure if that's a replicable solution.