First post, but I have been using PA for a while. I have a flow created where I am trying to update an existing list item when an item in a different list is updated. A few of the fields to be updated are date fields (date only) and this is where I am having trouble. The values in these three fields are driven off a fourth "Project End Date" date field. If there is a date present for "Project End Date" then everything works fine. However, if there is no date present then I am trying to update the other three date fields to null. I have tried numerous was to set the value to null and with each attempt I receive the error:
OpenApiOperationParameterTypeConversionFailed
The 'inputs.parameters' of workflow operation 'Update_item_copy' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/FirstDraftDue' is required to be of type 'String/date'. The runtime value '""' to be converted doesn't have the expected format 'String/date'.
I cannot figure out why it is coming out as basically an empty string when I am specifically asking for null.
All the methods I've tried:
- I have used the expression and simply put in null
- I've initiated a variable and set it to null and then set the dynamic value to the variable
- I have used if equals and if empty to set it to null
- I have used coalesce and even imbedded it within an if equals
None of these have worked and the flow continues to convert the null expression to "". First screenshot is the overall flow, and the red box highlights the piece that is failing. The second screenshot is the update item fields where I am currently using the variable to set the value, but again, I've tried various expressions in place of the variable.
