Hello!
Let me start by saying I have been reading through similar problems and I have tried out:
- if(equals(x,''),null,x)
- if(empty(x),null)
- DateTime Format is set to ISO 8601
My flow takes data from Excel (table) and adds it to a SharePoint List. I am running into two issues:
1. My blank date fields throw an error
2. My flow creates 4x of the records
1. I've seen this all over the place but the error it gives me is:
"The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/field_23' is required to be of type 'String/date'. The runtime value '""' to be converted doesn't have the expected format 'String/date'."
My function currently has: If(empty(item()?['Award Date']),null,item()?['Award Date'])
where 'Award Date' is the Dynamic content field from Excel.
2. I'm not sure what I messed up in my flow, but each record is getting added 4 times. I will unclude screenshots.
---------- Overview of Flow ----------
---------- Apply to each ----------
---------- List Rows ----------
---------- Apply to each ----------
---------- Create Item ----------
---------- Error ----------