web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Importing xlsx into Sh...
Power Automate
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





Categories:
I have the same question (0)
  • Verified answer
    manuelstgomes Profile Picture
    6,625 on at

    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 Profile Picture
    174 on at

    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



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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 315 Super User 2026 Season 1

#2
David_MA Profile Picture

David_MA 273 Super User 2026 Season 1

#3
Power Platform 1919 Profile Picture

Power Platform 1919 117 Super User 2026 Season 1

Last 30 days Overall leaderboard