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

[Flowbginner]

I need to have a total of all numbers in an excel table column named "Scoring Weight" of type string.

When using int(items('Apply_to_each')?['Scoring Weight']) the value is not converted to integer and gives me error message: Unable to process template language expressions in action 'Increment_variable' inputs at line '1' and column '2684': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.

[ChristianAbata]

Hi @Flowbginner  you could try length("YOurARRAYEXCEL")

[v-alzhan-msft · Accepted solution]

Hi @Flowbginner ,

Could you please share a screenshot of the configuration of your flow?

Could you please share a screenshot of the excel table?

The error message told that the expression couldn't convert the parameter to the target type, could you please add a compose action with the expression items('Apply_to_each')?['Scoring Weight'] to see what is the value in the Compose action?

Best regards,

Alice       

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi,

Please could you share the solution? I am getting the exact error.

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