data type error

(0) Share

Report

Posted on by noorfar

Hello..

I'm facing this error:

error: The 'inputs.parameters' of workflow operation 'Run_script' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'ScriptParameters/grand_total' is required to be of type 'Number'. The source type/format 'Array' of the value '[{"grand_total":"\"293\""}]' is not convertible to type/format 'Number'.

this is my flow:

these are the details:

I'm trying to run this script just to test the flow:

excel script is :
//Main sheet
function main(workbook: ExcelScript.Workbook,
grand_total: number
) {
let selectedSheet = workbook.getActiveWorksheet();
// Set range D6 on selectedSheet
selectedSheet.getRange("D6").setValue(grand_total);

the whole thing is to fill a set of cells arranged the same as the image below:

Categories:

Using connectors

I have the same question (0)

All responses (2)

Answers (0)

Sundeep_Malik 6,484 on at

Like (0)

Report

Hey @noorfar
As you are using the select action, its making grand total an array. But it only accepts integer/Number.

So, you can use an apply to each and add the outputs of select in it and pass the value one by one in the grand total.
Or either save the output of select in an array and the use apply for each loop and one by one add the grand total.

Or if grand total contains only one value, you can directly write in grand total in expression:
outputs('Select')[0]

I hope this helps.

Was this reply helpful? Yes No
noorfar 52 on at

Like (0)

Report

@Sundeep_Malik the outputs('Select')[0] option didn't work and give this error:
The template language expression 'outputs('Select')[0]' cannot be evaluated because property '0' cannot be selected. Object properties can only be selected by names.

adding apply to each action gave the following error:
Input parameter 'ScriptParameters/grand_total' is required to be of type 'Number'. The source type/format 'Object' of the value '{"grand_total":293}' is not convertible to type/format 'Number'.

finally, adding variable and pass it to the apply each worked but couldn't see the output on excel and the output code for some reason can't be shown

Was this reply helpful? Yes No