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