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

(0) Share

Report

Posted on by 46m4art

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

Categories:

Using connectors

I have the same question (0)

All responses (1)

Answers (0)

46m4art 6 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No