I created a PowerAutomate flow that reads data from an excel file and writes to a SharePoint List. When it tries to write a date field that is empty, I get the error message below

OpenApiOperationParameterTypeConversionFailed. The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/field_9' 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? And also any thoughts on how to obtain the column ID would be highly appreciated