cancel
Showing results for
Did you mean:
Highlighted
Anonymous
Not applicable

## decimal place

Is it possible to limit a float to 2 decimal place?

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Memorable Member

## Re: decimal place

Hi @Anonymous

Limit the float variable no, but you can use an action to transform cutting the others decimals places.

The expression to do this is :

if the float value is in a variable :

also, if is in a action:

In this fuction the is the count of decimal places plus the dot place.

If you need more help, post here.

Hope Have Helped,

Gustavo Moraes

Gustavo Moraes, o astronauta brasileiro do Flow!

Highlighted
Memorable Member

## Re: decimal place

Hi @Anonymous you need to click inside dynamic content to use expression and put that function inside the red square,

like the print below:

OBS: I see the text inside variable is the float value, in the snippet that i post you need to put the Variable Action name, if you have direct value, can remove the literal text "variable"

Best Regards,

Gustvo Moraes

Gustavo Moraes, o astronauta brasileiro do Flow!

15 REPLIES 15
Highlighted
Memorable Member

## Re: decimal place

Hi @Anonymous

Limit the float variable no, but you can use an action to transform cutting the others decimals places.

The expression to do this is :

if the float value is in a variable :

also, if is in a action:

In this fuction the is the count of decimal places plus the dot place.

If you need more help, post here.

Hope Have Helped,

Gustavo Moraes

Gustavo Moraes, o astronauta brasileiro do Flow!

Highlighted
Anonymous
Not applicable

## Re: decimal place

Where do i have to put in that code snipped?

I have a variable as a string.

Thanks

Highlighted
Memorable Member

## Re: decimal place

Hi @Anonymous, i recommend you to use a 'Compose' action.

Look the images:

How i did

After yoiu can use this compose to do your flow.

Result

Hope Have Helped,

Gustavo Moraes

Gustavo Moraes, o astronauta brasileiro do Flow!

Highlighted
Anonymous
Not applicable

almost

Highlighted
Anonymous
Not applicable

Highlighted
Memorable Member

## Re: decimal place

Hi @Anonymous you need to click inside dynamic content to use expression and put that function inside the red square,

like the print below:

OBS: I see the text inside variable is the float value, in the snippet that i post you need to put the Variable Action name, if you have direct value, can remove the literal text "variable"

Best Regards,

Gustvo Moraes

Gustavo Moraes, o astronauta brasileiro do Flow!

Highlighted
Anonymous
Not applicable

## Re: decimal place

Thank you it works!!!

Highlighted
Regular Visitor

## Re: decimal place

@gamoraes You are my hero and if you were present I would buy you lunch! THANK YOU!!

Highlighted
Frequent Visitor

## Re: decimal place

Hi,

To overcome the problem of having a decimal number with only one decimal, simply add an insignificant number to it, like 0,00001.

This way you automatically always have more that 2 decimals.

Here is the formula:

`substring(string(add(triggerBody()['number'],0.000001)),0,add(indexof(string(add(triggerBody()['number'],0.000001)),'.'),3))`
Highlighted
Helper III

## Re: decimal place

This method does not work if You run numbers like. 390.00 or 290.00. I'm getting results 39 ir 29

Here is my formula:

Memorable Member

## Re: decimal place

Hi @LEARN_IT, the problem with your expression is in red, you need to put the length of decimal places(in your case 2)

The correct function to remove decimal with 2 places are

Gustavo Moraes, o astronauta brasileiro do Flow!

Highlighted

## Re: decimal place

One note here, it may be wise to convert it back into a float by adding float() as the last step of the formula.

`float(substring(string(outputs('Get_Running_Total')),0,add(indexof(string(outputs('Get_Running_Total')),'.'),3)))`

Highlighted

## Re: decimal place

I posted a solution that rounds a float to hundreths on another thread. The solutions above truncate.

Highlighted
Helper II

## Re: decimal place

the decimal solution worked for me, BUT do you also have a solution for adding the comma in appropriate places?

Highlighted

## Re: decimal place

Yup. See my post here. My 2nd post on that thread has the more robust, expanded version.

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

#### Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors
Users online (3,082)