Skip to main content

Notifications

Power Automate - Building Flows
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) ShareShare
ReportReport
Posted on by 38

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

 

 

  • Re: 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.'.

  • Verified answer
    Re: 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 @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.

  • ChristianAbata Profile Picture
    ChristianAbata 8,947 on at
    Re: 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 @Flowbginner  you could try length("YOurARRAYEXCEL")

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard