I'm using flow to import an excel table that has some null values in a date column. If values are null, I get the following error:
The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/ConversationCompletedDate' is required to be of type 'String/date'. The runtime value '""' to be converted doesn't have the expected format 'String/date'.
I'm not sure how to test for null date values.
I have now edited the create Item with the following code
which works! but I wanted to leave the date blank if it was null. I tried using Coalese but could not get that to work, that would give me the same answer.
So I tried the following and it worked;
if(empty(items('Apply_to_each')?['Assigned Date']),null,formatdatetime(items('Apply_to_each')?['Assigned Date'],'MM/dd/yyyy'))
Thanks!
