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'))
Solved! Go to Solution.
So many events happening this month - don't miss out!
Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.