cancel
Showing results for
Did you mean:
Level: Powered On

## decimal place

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

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User

## Re: decimal place

Hi @sfoerst

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!

Super User

## Re: decimal place

Hi @sfoerst 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
Super User

## Re: decimal place

Hi @sfoerst

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!

Level: Powered On

## Re: decimal place

Where do i have to put in that code snipped?

I have a variable as a string.

Thanks

Super User

## Re: decimal place

Hi @sfoerst, 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!

Level: Powered On

## Re: decimal place

almost

Level: Powered On

Super User

## Re: decimal place

Hi @sfoerst 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!

Level: Powered On

## Re: decimal place

Thank you it works!!!

Level: Powered On

## Re: decimal place

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

Level: Powered On

## 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:

Highlighted
Level: Powered On

## 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:

Super User

## 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!

Level: Powered On

## 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.

Level 8

## Re: decimal place

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

Level: Powered On

## Re: decimal place

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

Level 8

## Re: decimal place

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

Announcements

#### Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

#### New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

#### Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

#### Power Platform World Tour

Find out where you can attend!

#### Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors
Users online (6,985)