Create Item Sharepoint Connector Error

(0) Share

Report

Posted on by christianh2o

I have a flow that creates an item in a sharepoint list, where numbers entered into a form will make calculations in a new column. However the "require that this column contains information" is off. However, if left blank or unanswered on the form, my flow breaks, and I get this notification from the flow.

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

Is there any way around this? The calculated columns use sum and count, so I can't make an "if" case where it equals 0 because it will skew my data.

Please advise. Thanks.

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (0)

v-yujincui-msft on at

Like (0)

Report
Hi @christianh2o ,

Maybe you could consider adding a Condition Action to execute another branch if the specified field in the MS Forms is empty.

1.Here is my Form.

2. Here is my Flow.

empty(Dynamic Content)

Result Screenshot:

Here is a similar case for your reference.

https://powerusers.microsoft.com/t5/Building-Flows/Error-The-specified-user-could-not-be-found-when-new-item-is/m-p/1631296#M181499

Best Regards,
Charlie Choi

Was this reply helpful? Yes No