Answered

float will not convert to int

(0) Share

Report

Posted on by Ventit

422

I have never experienced this issue before. I have a SharePoint Number Column. In my flow I want this number to be an integer, so I simply take it and put inside the expression int(). Till now this has worked but now in a new flow I get the logic error:

"InvalidTemplate. Unable to process template language expressions in action 'Compose' 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.'.

The number I am testing is

1.42857142857143

The column in SP is set to number with no decimals, but as always it still returns decimals in flow if it is not whole.

I must be missing some logic. The error above is a compose, but it also fails in a another variable of type integer. It does return in a float variable OK, but I must have an integer

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Ventit 422 on at

Like (0)

Report
Copy link

Link copied!
In order to resolve this I had to:
Initialize a string variable that capture the column as a float
Using a compose I then converted to an int by using a substring to remove after the decimal point
I see this as a significant work around for something that was very simple in past so not sure what is actually different

Was this reply helpful? Yes No
Manish Solanki 15,167 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @Ventit

To extract only the integer and ignore the decimal part, pls use the below expression:
int(first(split('1.42857142857143','.')))
pls pass the variable in place of float number in the above expression.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
Ventit 422 on at

Like (0)

Report
Copy link

Link copied!

Does it give an error if there is no decimal point

Was this reply helpful? Yes No
Verified answer

Manish Solanki 15,167 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Ventit

No, it wouldn't give an error if decimal point is not present in the input sting.

If my reply helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Thanks

Was this reply helpful? Yes No
FA-22072253-0 3 on at

Like (0)

Report
Copy link

Link copied!

It worked!

Was this reply helpful? Yes No