Answered

flow mathematical functions

(0) Share

Report

Posted on by xavirb

Hi,
I'm learning a little bit of flow, and I can't multiply a couple of data entered by the user.
I enter the data as a number, and use the mul('number','number_1') function but it returns an error indicating:

the template language function 'mul' expects its first parameter to be an integer or a decimal numbre. The provided value is of type 'String'

can you help me?

Thanks!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

xavirb 5 on at

Like (0)

Report

the code don`t run:

{
"inputs": "@{triggerBody()['number']}@{triggerBody()['number_1']}"
}
{
"inputs": {
"host": {
"connection": {
"name": "@json(decodeBase64(triggerOutputs().headers['X-MS-APIM-Tokens']))['$connections']['shared_sharepointonline']['connectionId']"
}
},
"method": "post",
"body": {
"Title": "@base64ToString(triggerOutputs()['headers']['x-ms-user-email-encoded'])",
"ImportesinIVA": "@mul('number','number_1')"
},
"path": "/datasets/@{encodeURIComponent(encodeURIComponent('https://xxxx.sharepoint.com/sites/xxx'))}/tables/@{encodeURIComponent(encodeURIComponent('4609be9d-b6ec-4139-9d43-f3b4f5bb0d12'))}/items",
"authentication": {
"type": "Raw",
"value": "@json(decodeBase64(triggerOutputs().headers['X-MS-APIM-Tokens']))['$ConnectionKey']"
}
}
}

Was this reply helpful? Yes No
yashag2255 24,769 Super User 2024 Season 1 on at

Like (1)

Report

Hey @xavirb

Maybe you are providing the input as string (text) and the issue is coming due to that. You can convert the input to int and then use the mul function to multiply. The int() function can be used to convert the numbers entered as a string to a number format. Your expression would now look something like:

mul(int('number'),int('number_1'))

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Verified answer

v-bacao-msft on at

Like (0)

Report
Hi @xavirb ,

Perhaps you can try to use the float() function to convert string-type data to number. Like:

mul(triggerBody()['number'],triggerBody()['number_1'])

It's also worth noting that although you enter two numbers in the inputs, if they are not used for any calculations, they will be presented as strings instead of another number that is spliced into two numbers.

Best Regards,

Was this reply helpful? Yes No