Skip to main content

Notifications

Power Automate - General Discussion
Answered

Keep getting this error about formatting of date

(0) ShareShare
ReportReport
Posted on by 427

I keep receiving this error

 

The 'inputs.parameters' of workflow operation 'Update_item_-_Pending_Approver_1_AND_Approval_1_Link' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/RequestCreated' is required to be of type 'String/date'. The runtime value '"23-02-2024"' to be converted doesn't have the expected format 'String/date'.

 


when i try to do this to a DateTime column in my sharepoint list.

 

formatDateTime(convertTimeZone(utcNow(), 'UTC', 'AUS Eastern Standard Time'), 'dd/MM/yyyy')

 


what seems to be the problem? I don't understand at all.

  • Verified answer
    Re: Keep getting this error about formatting of date

    Hi @kej,

    That depends on if you have set the site settings with your timezone.

     

    Generally, you send datetime to SharePoint as UTC and then the Site Settings will display it in your timezone if you have set the site settings with your timezone, you couls send the data from power automate to the sharepoint list without converting the timezone. 

    You just need to save the utc time as below:

    formatDateTime(utcNow(), 'yyyy-MM-dd')​

     

  • The21k Profile Picture
    The21k 33 on at
    Re: Keep getting this error about formatting of date

    From what i've read, some operations need to have the date format be like yyyy-MM-dd, meaning an ISO8601 date format. Give it a try to make your input date with the previous format, and don't worry about your output as it should be in the dd/MM/yyyy format.

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