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:
