Skip to main content

Notifications

Power Automate - General Discussion
Answered

Importing xlsx into SharePoint list - error on empty cells

(0) ShareShare
ReportReport
Posted on by 174

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





  • BClouded Profile Picture
    BClouded 174 on at
    Re: Importing xlsx into SharePoint list - error on empty cells

    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



  • Verified answer
    manuelstgomes Profile Picture
    manuelstgomes 6,625 on at
    Re: Importing xlsx into SharePoint list - error on empty cells

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,434

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,722

Leaderboard