Power Platform Community Forum Thread Details

Hi all,

I'm trying to upload an excel to create a Sales Order in business central. I managed to fix the date format issue to a readable format in DD-MM-YYYY but when the data is passed to BC connector for Create Record(V3), I encounter the following error code:

The 'inputs.parameters' of workflow operation 'Create_record_(V3)' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/orderDate' is required to be of type 'String/date'. The runtime value '"21-05-2021"' to be converted doesn't have the expected format 'String/date'.