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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Keep getting this erro...
Power Automate
Answered

Keep getting this error about formatting of date

(0) ShareShare
ReportReport
Posted on by 824 Moderator

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.

Categories:
I have the same question (0)
  • The21k Profile Picture
    33 on at

    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.

  • Verified answer
    v-qiaqi@microsoft.com Profile Picture
    Microsoft Employee on at

    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')​

     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 77 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 68

#3
Expiscornovus Profile Picture

Expiscornovus 56 Most Valuable Professional

Last 30 days Overall leaderboard