Skip to main content

Notifications

Power Automate - General Discussion
Answered

Error when trying to update Sharepoint with a date.

(0) ShareShare
ReportReport
Posted on by

I have a flow that I am trying to build. It's relatively long and has a number of steps. 

 

Trigged by a user completing a Microsoft Form. The form is to indicate availability. It then sends dates from the form in an email with options the email with options would read as "31/08/2022 PM". I want to update my Sharepoint list with the selected option from the email. I've split the response and removed the AM or PM part so I am only left with the date (31/08/2022). However when I try to run the flow I get an error.

 

Jamie5_0-1661949965191.png

 

I tried formatting the date and it won't allow me to do that either 

 

Jamie5_1-1661950028321.png

Can anyone help?

  

  • Verified answer
    Re: Error when trying to update Sharepoint with a date.

    HI @Jamie5,

    Have you resolved your problem?

    Could you please tell me if you have a date/time column in your SP list to save this extracted date value?

     

    I agree with @David- that the SharePoint list expects date format like "yyyy/MM/dd".

    ISO 8601 specifies that the date portion of a Date Time string is always formatted as yyyy-MM-dd.  Yours is formatted as dd/MM/yyyy. 

    formatDateTime(<Dynamic Content>,'yyyy/MM/dd')

     

    If the date comes from as a string, then you may need to break it apart and rearrange it to the correct formatting to use it as a DateTime string.  If its a date already then you should be able to use DateTimeFormat.

    You can re-organise your date string as this thread described:

    Solved: Error- The datetime string must match ISO 8601 for... - Power Platform Community (microsoft.com)

  • Verified answer
    David- Profile Picture
    David- 1,254 on at
    Re: Error when trying to update Sharepoint with a date.

    You need to use the ISO 8601 date format as noted in the error message. In your formatDateTime expression, use 'yyyy-MM-dd' as the format instead of 'dd/MM/YYYY'. 

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,343

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard