Skip to main content

Notifications

Power Automate - General Discussion
Answered

The datetime string must match ISO8601 format

(0) ShareShare
ReportReport
Posted on by 19

HI All

Error message prompted out -  " In function 'formatDateTime', the value provided for date time string '44865' was not valid. The datetime string must match ISO 8601 format.'"

 

my designed flow as below (the data of 'Compose' is from the Microsoft Form and it is set for input as a date)

Problematic_1-1666171329517.png

The flow failed to run as error message indicated that the datestring does not comply with ISO 8601.

Problematic_0-1666171183951.png

 

can anyone advise how to change the date format in Number to ISO 8601 format

  • Problematic Profile Picture
    Problematic 19 on at
    Re: The datetime string must match ISO8601 format

    Hi Sundeep

    Thanks for your quick response and my problem is resolved.😊

  • Verified answer
    Sundeep_Malik Profile Picture
    Sundeep_Malik 6,480 on at

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,445

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,741

Leaderboard