Unanswered

Multiplication in PowerAutomate

(0) Share

Report

Posted on by janineb

Good day

I have a Flow that takes info from Form, enter it in Excel and then I must Initialize 3x variables (because values later on will be multiplied by Fifteen, Ten and Five percent. At first I chose "Type" Integer, but it gave me an error and I changed it to a Type String. The error has now disappeared.

The problem comes at this point where I initialize a variable for another value (Integer) and multiply it with the Fifteen percent.

Please see error: InvalidTemplate. Unable to process template language expressions in action 'mul3KeyRisks' inputs at line '0' and column '0': 'The template language function 'mul' expects its second parameter to be an integer or a decimal number. The provided value is of type 'String'. Please see https://aka.ms/logicexpressions#div for usage details.'.

Can you perhaps help me with the formula in the Compose section?

thank you

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

David- 1,254 on at

Like (1)

Report
Copy link

Link copied!

You need to use a floating decimal number. Set up your variables like:
Integers are whole numbers.

Was this reply helpful? Yes No
janineb on at

Like (0)

Report
Copy link

Link copied!

Sorry, it was a Float and not an integer before, but then the system gave me this error and I had to change it to String:
The variable 'varFifteen' of type 'Float' cannot be initialized or updated with value of type 'String'. The variable 'varFifteen' only supports values of types 'Float, Integer'.

Was this reply helpful? Yes No
janineb on at

Like (1)

Report
Copy link

Link copied!

sorry, I understand that I have to put the "0" in front of the .15 ... it is working fine now - thanks

Was this reply helpful? Yes No