Unanswered

Round decimal figures

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi all,

In Sharepoint I have a calculated column for number of days left to do an operation. Flow sees it as a string. How do I round that number to integer with a 'select' action?

Thanks for assisting.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

v-bacao-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous,

You could try to convert it by using the int() function.

Like：int(Dynamic content)

Please take a try.

Best Regards,

Barry

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @v-bacao-msft,

thanks for the suggestion. Here is the error I get:

InvalidTemplate. The execution of template action 'Select' failed: The evaluation of 'query' action 'where' expression '{ "DaysLeft": "@item()['DaysLeft']", "DaysLeftRounded": "@int(item()['DaysLeft'])" }' failed: 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.

There is this thread with more details, I inadvertently created another request.

Was this reply helpful? Yes No
Wilhelm 34 on at

Like (0)

Report
Copy link

Link copied!

I'd select it as is, and then compose it into an integer.
Here's a recipe I use to round numbers - you'll notice I change the number to a string, then split on the decimal point, and then turn it back into an integer. (You won't need the multiply and divide by 100.)
The value I'm rounding is varMonthlyAmount.
I'm rounding to two decimal places, hence multiply and divide by 100.

div(int(first(split(string(add(mul(variables('varMonthlyAmount'),float(100)),0.5)),'.'))),float(100))

Was this reply helpful? Yes No