Create item from Form - Numeric error

[mtagliaferri]

I have a form with a dropdown numeric answer, this is set at branching and only required on selction of the previous answer. If requested on the form the options are 1,2 and 3 from the dropdown; should the branching not require an answer on the form the answer is empty.

the create item from getting the form results worrk fine if the braching is selected and there is an input from the dropdown column, however if nothing is selected I run into the below error:

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

I have changed the update column to the expression:

int(outputs('Get_response_details')?['body/rab59e548acbf4f4689de9cc470a73b6d'])

but I get the error:

Unable to process template language expressions in action 'Create_item' inputs at line '1' and column '41274': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.

I have changed the sharepoint library column to be a text and also have a default value set to 3 as if the branching is not selected then the item created should reflect 3 and not anything selected from the drop down.

Basically what I need is that if the form braching allows to enter a number from the drop down, the item created has to reflect what selected, if the question is not asked from the form then the value 3 must be created.

[StalinPonnusamy]

On the flow, create a variable to set a default value (3) and set the variable if the value present. In this case, we can always use the variable which has value.

I created the below flow just for analogy

[mtagliaferri]

Hi @StalinPonnusamy 

I have updated the flow as suggested

I still receive the error:

The variable 'QuantityUpdated' of type 'Integer' cannot be initialized or updated with value of type 'String'. The variable 'QuantityUpdated' only supports values of types 'Integer'.

The quantity from the form is a dropdown list (which _i believe is causing the issue as the dropdown can contain text or numbers),

I changed the set variable to the expression:

int(outputs('Get_response_details')?['body/rab59e548acbf4f4689de9cc470a73b6d'])

But by changing the above I get this error in the set variable:

Unable to process template language expressions in action 'Set_variable' inputs at line '1' and column '41346': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.

[StalinPonnusamy · Accepted solution]

Hi @mtagliaferri 

Use Compose action to convert string to int. In this example, I converted string to int, and should works.

[mtagliaferri]

Hi @StalinPonnusamy this solved the error!!