cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BClouded
Helper III
Helper III

Importing xlsx into SharePoint list - error on empty cells

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





1 ACCEPTED SOLUTION

Accepted Solutions
manuelstgomes
Super User II
Super User II

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

View solution in original post

2 REPLIES 2
manuelstgomes
Super User II
Super User II

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

View solution in original post

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



Helpful resources

Announcements
MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (49,430)