Answered

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.'.

(1) Share

Report

Posted on by 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.'.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

ChristianAbata 8,953 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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.'.

Was this reply helpful? Yes No