Power Automate unable to write empty date to SharePoint

Copper Contributor

We have a PowerAutomate flow that reads data from an excel file and writes that data to a SharePoint Column.

When the date field on the excel file is empty, the following error message is displayed by PowerAutomate


OpenApiOperationParameterTypeConversionFailed. The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/field_7' is required to be of type 'String/date'. The runtime value '""' to be converted doesn't have the expected format 'String/date'.

Any thoughts on how to resolve this issue?
I need to be able to write null or empty dates to SharePoint sometimes

0 Replies