Issue - The template language function 'sub' expects its second parameter to be an integer or a decimal number. The provided value is of type 'String'.

Like (0) Share

Report

Posted on 24 Dec 2020 11:33:21 by jbrines

1,119

Hi Guys,

Hope all are well and safe.

In my flow I am getting the following error, hope someone can help me 😊

InvalidTemplate. Unable to process template language expressions in action 'Compose_-_calculate_difference_in_days' inputs at line '1' and column '13923': 'The template language function 'sub' 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#sub for usage details.'.

This is the flow

I have the same question (0)

All responses (2)

Answers (0)

jbrines 1,119 on 28 Dec 2020 at 18:11:03

Like (0)

Report
Re: Issue - The template language function 'sub' expects its second parameter to be an integer or a decimal number. The provided value is of type 'String'.

@RezaDorrani

Do you mean like the following?

int(div(div(div(div(mul(sub(variables('ticksUTCNow'),variables('ticksCreated')),100),1000000000),60),60),24))

Then it still fails.

Was this reply helpful? Yes No
RezaDorrani 12,141 on 24 Dec 2020 at 16:22:13

Like (1)

Report

Re: Issue - The template language function 'sub' expects its second parameter to be an integer or a decimal number. The provided value is of type 'String'.

Hi @jbrines

sub expects arguments of type int or decimal only.

try typecasting your compose value as int(compose dynamic value)

To learn more about expressions, check this video series : aka.ms/learnexpressions

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thanks,
Reza Dorrani, MVP
YouTube
Twitter

Was this reply helpful? Yes No