cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Flowbginner
Advocate V
Advocate V

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

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-alzhan-msft
Community Support
Community Support

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.

View solution in original post

3 REPLIES 3
ChristianAbata
Super User
Super User

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



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA
v-alzhan-msft
Community Support
Community Support

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
Not applicable

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

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (1,533)