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.
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
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