Hi All
Would anyone please advise me on the error below:
OpenApiOperationParameterTypeConversionFailed. The 'inputs.parameters' of workflow operation 'Update_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/Cargo_x0020_Ready_x0020_Date' is required to be of type 'String/date'. The runtime value '"30-06-2020"' to be converted doesn't have the expected format 'String/date'.
I am trying to get the date value from excel and write it to SharePoint list.
I have a few issues:
Hi @SueB
Thank you for your reply. It seems to be the date format issue. The correct date format for me is yyyy-MM-dd instead of dd-MM-yyyy.
Hi @Akuner
Have you looked at Norm Young's guide on importing Excel data to SharePoint? There is a segment on handling dates that is helpful. Here are screenshots of that section.
I hope this helps! 🙂
If this post helps, then please consider accepting it as the solution to help other members find it more quickly! Have a great day!