cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
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
Highlighted
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

Highlighted

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Kudoed Authors
Users online (9,844)