cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NicoApps
Frequent Visitor

What is this error?

I've created my first flow, where on Submit of a form, data is supposed to go into a Sharepoint list. I followed all appropriate steps, however, this is what I get: 

 

Flow save failed with code 'OpenApiOperationParameterValidationFailed' and message 'Input parameter 'item' validation failed in workflow operation 'Create_item': The parameter with value '"@outputs('Get_response_details')?['body/submitDate']"' in path 'item/field_2' with type/format 'String/date-time' is not convertible to type/format 'Number/double'.'.

 

Screenshot 2022-07-15 150955.png

 

 

Pleaes advise. 

1 ACCEPTED SOLUTION

Accepted Solutions
v-yujincui-msft
Community Support
Community Support

Hi @NicoApps ,

 

Based on your error message, it seems to be caused by a data type mismatch. 

I suggest you to check the column type of the 'Completion time' column.

vyujincuimsft_0-1658309191877.png

Here is my SharePoint List.

vyujincuimsft_1-1658309334337.png

Result Screenshot:

vyujincuimsft_2-1658309734034.png

 

 

Best Regards,
Charlie Choi

View solution in original post

2 REPLIES 2
Ankesh_49
Super User
Super User

@NicoApps Its a date/Time format issue. You can use formatdatetime/converttoUTC expression in your flow so that it aligns to he format required in SharePoint.
Or You can change the settings in SharePoint for Date/Time

 

Hope it helps!!

 

Cheers,

Ankesh

--------------------------------

If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

v-yujincui-msft
Community Support
Community Support

Hi @NicoApps ,

 

Based on your error message, it seems to be caused by a data type mismatch. 

I suggest you to check the column type of the 'Completion time' column.

vyujincuimsft_0-1658309191877.png

Here is my SharePoint List.

vyujincuimsft_1-1658309334337.png

Result Screenshot:

vyujincuimsft_2-1658309734034.png

 

 

Best Regards,
Charlie Choi

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (2,258)