Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities - Lets Get Started!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Date issue
Power Automate - Building Flows
Suggested answer

Date issue

(0) ShareShare
ReportReport
Posted on by Kmayes 782
I have a flow that is trowing a random issue. Below is the flow setup and further down is the error issue I am getting on random data rows. The reason I say its a random issue is that the dates in the excel file are all formatted the same so I cant see why it is an issue on some rows?
 
If anyone could shed some light or rational I would be most grateful.
 
 
 
 
Categories:
Business Process Flows
  • Vejai SH Profile Picture
    Vejai SH 127 on at
    Date issue
  • Chriddle Profile Picture
    Chriddle 7,791 Super User 2025 Season 1 on at
    Date issue
    13/01/2025 should fail as well and the others might have swapped days and months.
    Except for strings formatted according to ISO 8601, Power Automate only considers dates in US format (MM/dd/yyyy) to be valid.
     
    With "set the correct types in the Excel file" I meant setting the Excel's column type to "Date" 😉
    If you do so and set the DateTimeFormat in the Power Automate Excel connector to ISO 8601, you get valid dates in Power Automate (if you enter somthing in the Excel that is a date)
  • Kmayes Profile Picture
    Kmayes 782 on at
    Date issue
     
    I have tested with both format date and parse date and still getting the same issue. Its odd because like mentioned the excel file is formatted in the correct manner to start below is an example of the dates, now the one highlighted is one that is failing and all the other dates around it are working ok
     
  • Chriddle Profile Picture
    Chriddle 7,791 Super User 2025 Season 1 on at
    Date issue
    Use parseDateTime to convert your string into a valid date string:
    parseDateTime('15/01/2025', 'es-es', 'dd/MM/yyyy')
     
    Or set the correct types in the Excel file from the beginning.
  • Suggested answer
    Vejai SH Profile Picture
    Vejai SH 127 on at
    Date issue
    Hi @Kmayes,
     
    Use formatDateTime() to convert to a respected format for Sharepoint.
     
     
    formatDateTime('16/01/2025', 'yyyy-MM-dd')
     
    Thanks,
    Vejai SH

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

News and Announcements

Welcome to the Power Platform Communities - Lets Get Started!

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans