Power Automate Error: Handling Empty Cells When Uploading Excel Data to SharePoint Lists

Error : 

The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/SST' is required to be of type 'Number/double'. The runtime value '""' to be converted doesn't have the expected format 'Number/double'.

When users attempt to upload Excel file data using Power Automate, this issue commonly happens. The reason is that the Excel table contains empty cells. Proper configuration in Power Automate is necessary to avoid this problem. It's a simple fix, and I'll show you how to implement it.

Before the fix, it looks like this:

items('Apply_to_each')['XXX'])

Just need to add a condition as below:

if(empty(items('Apply_to_each')['XXX']),null,items('Apply_to_each')['XXX'])

This formula describes the following:

• If the value of the 'XXX' field for the current item is empty, it will return null.
• If the value of the 'XXX' field for the current item is not empty, it will return the actual value of the 'XXX' field.

This expression ensures that if the value in the 'XXX' field is empty, it replaces it with null, which can be useful for downstream processing or handling within your Power Automate flow.