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.'.
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.'.
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.
Hi @Flowbginner you could try length("YOurARRAYEXCEL")