Skip to main content

Notifications

Power Automate - Using Connectors
Unanswered

Error Message on creating flow for SQL datetime to SharePoint Date and Time list

(0) ShareShare
ReportReport
Posted on by 6

Here is the error I am seeing, all my other points are pulling in as expected from SQL but the my datetime is not. Any ideas or help would be great.

 

 

 

Flow save failed with code 'OpenApiOperationParameterValidationFailed' and message 'Input parameter 'item' validation failed in workflow operation 'Create_item': The parameter with value '"@items('Apply_to_each')?['TIMESTAMP']"' in path 'item/output' with type/format 'String/date-no-tz' is not convertible to type/format 'String/date-time'.'.

 

 

 

Thank you

  • 46m4art Profile Picture
    46m4art 6 on at
    Re: Error Message on creating flow for SQL datetime to SharePoint Date and Time list
    I believe I have found my issue and I am still not sure how to proceed. My datetime is pulling in from SQL as follow "2021-09-21T13:30:00.02000009/22/2021" And I am not sure how to convert that using formatdatetime. I need it to be format d and I have no idea what this format sql is spitting at me is, tomorrow and year?image.png

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

Featured topics