Importing xlsx into SharePoint list - error on empty cells

[BClouded]

Dear Community

I need to create a flow which imports records from Excel into a SharePoint list.
It works well when all fields are filled in, but fails on empty cells. 

The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/ITZA' is required to be of type 'Number/double'. The runtime value '""' to be converted doesn't have the expected format 'Number/double'.

Here I have an error on the ColumnName ITZA, which is of type number and left empty. 

I tried this:  if(empty(['ITZA']),null,['ITZA'])  But the Expression is invalid. What is wrong with my syntax?

Or any other solutions that comes in mind?

Thanks a lot!
Bart

[manuelstgomes · Accepted solution]

HI @BClouded 

Can you please check if the column is mandatory? If so that's why it's requiring that you provide a valid number/double.

The syntax is incorrect. You need to prefix the ['ITZA'] that contains it. For example if you're using a for each it should be something like:

items('Apply_to_each')?['ITZA']

Where "Apply_to_each" is the name of the loop. So what you're asking is, in the array that contains all objects, try to find one that is called ITZA..

If you can define a default value for empty like zero try the following:

if(empty(items('Apply_to_each')?['ITZA']),0,items('Apply_to_each')?['ITZA']) 

Can you please check if and let me know if you have any questions?

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

[BClouded]

Thanks @manuelstgomes !

With the correct syntax it now continues but error on the next empty column. Looks like all number columns can't handle empty cells in Excel. 

Best,
Bart