Create item on sharepoint list without weight format errors

(0) Share

Report

Posted on by Sormick

566

I created a flow which get all the "2 decimals weight" values from an excel workbook column "Create table element"

Then i need to store these values on a sharepoint list using "Create item element".

On my sharepoint list the column which contains the weight values was created with "numbers 2 decimals" format.

The issue is that sometimes on this column there is no weight and sometimes i have a weight.When i trigger this flow i have a message error when i don't have weight for some items.

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

I could also have the same issue in the case if some weight values contains 3 decimals instead of 2 decimals.
Is there a function to skip these values to avaid errors?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

David_MA 14,199 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Since you don't show the flow or the expression you are using on the value where you are getting an error, it is difficult to give you the cause of the problem. However, the error message is quite clear. You have a field named "Date" that is a number field, and whatever expression you are using is not returning a number and appears to be returning double quotes (or an empty string). If you show your flow and the expression you are using, more specific help can be provided. Most likely you will need to use a coalesce expression to handle this issue: Blank, Coalesce, IsBlank, and IsEmpty functions - Power Platform | Microsoft Learn

Based on the error, I don't think the error has anything to do with you two-decimal weight field unless you named it Date, which wouldn't seem to make sense.

Was this reply helpful? Yes No
Sormick 566 on at

Like (0)

Report
Copy link

Link copied!

Dear @David,

Thank you for your reply.

Please find here a screenshot of my sharepoint columns:

i have two Columns named "EDM" and "EMI" which have date format

Another columns named "Weight which has number format with 2 decimals.

On my Create item Element of my flow i have yet not specified the "EMD" and "EMI" fields, so for the moment it should not retrieve the values of these elements.

But sure i will try next to retrieve also these values.

If some items are blank i will need to ceate if possible blank items . Is this possible?

what function would you suggest le to use?

Was this reply helpful? Yes No
David_MA 14,199 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

It looks like some of the configuration of the create item action is cut off at the top. Is there a field in that part named "Date"? The error message says the problem is what you are doing in trying to populate a field named date and I don't see that in your screen shots. For the fields you are filling in, if the value is null, you can use a coalesce expression to handle this when you create the item so it doesn't generate an error. Again, I refer you to this resource on how to use the coalesce expression: Blank, Coalesce, IsBlank, and IsEmpty functions - Power Platform | Microsoft Learn.

Can you share a screen shot of your flow showing the action that failed? It will be designated by an exclamation point in a red circle. For example:

Here is an example of the coalesce expression in an HTTP request to update fields in a list item. The expression checks to see if the status value is populated, and if not, it returns Rejected instead:

This is the coalesce expression on Status: coalesce(outputs('Get_item')?['body/Status/Value'],'Rejected')

Was this reply helpful? Yes No
Sormick 566 on at

Like (0)

Report
Copy link

Link copied!

Please find a screenshot showing the action that have failed below:

On Parameters i can see "Item:Date" but i do do have this date column on my sharepoint list, excepted for columns named "EMD" and "EMI"

'Please find below another screenshot of all my sharepoint columns.

I do have also such "Date" field on mu flow as well as on my Excel table, so i don't understand why i have an error with dates.

Was this reply helpful? Yes No