web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Excel Date format - no...
Power Automate
Unanswered

Excel Date format - not ISO

(0) ShareShare
ReportReport
Posted on by

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:
I have the same question (0)
  • tom_riha Profile Picture
    10,185 Most Valuable Professional on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 503 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 321 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard