int function not working

(1) Share

Report

Posted on by mfritter

I am trying to change a value using numberformat to a percentage. I can confirm that the value being pulled from a table is a string as indicated by the double quotes:

when trying to convert it gives the error "Unable to process template language expressions in action 'Compose_2' inputs at line '0' and column '0': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'." I have tried this with a value entered through a form and a calculated value from the excel sheet. I have confirmed all my connectors are 'connected', I have tried to use a variable to ensure it it shown as a string then use the int conversion but everything fails. I believe the flow should work as I set up a manually triggered flow and that worked using the following:

This results in a percentage when manually triggered using the value '5:

All responses (3)

Answers (1)

trice602 13,760 Super User 2025 Season 1 on at

Like (0)

Report

Re: int function not working

Glad you are up and running!
mfritter 9 on at

Like (1)

Report

Re: int function not working

Woohoo Tom, you are a star! made the change as suggested swapping out the INT for the float, value converted and email worked fine!
Verified answer

trice602 13,760 Super User 2025 Season 1 on at

Like (1)

Report

Re: int function not working

Hi @mfritter ,

Please try float() .

float(variables('test1'))