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

decimal place

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

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Power Participant
Power Participant

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 : 

 

substring(string(variables('VARIABLE_NAME')),0,add(indexof(string(variables('VARIABLE_NAME')),'.'),3))

 

also, if is in a action:

 

substring(actionOutputs('ACTION_NAME'),0,add(indexof(actionOutputs('ACTION_NAME'),'.'),3))

 

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


Did I answer your question? Mark my post as a solution!

Gustavo Moraes, o astronauta brasileiro do Flow!


View solution in original post

Highlighted
Power Participant
Power Participant

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:

Flow 2.png

 

 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


Did I answer your question? Mark my post as a solution!

Gustavo Moraes, o astronauta brasileiro do Flow!


View solution in original post

15 REPLIES 15
Highlighted
Power Participant
Power Participant

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 : 

 

substring(string(variables('VARIABLE_NAME')),0,add(indexof(string(variables('VARIABLE_NAME')),'.'),3))

 

also, if is in a action:

 

substring(actionOutputs('ACTION_NAME'),0,add(indexof(actionOutputs('ACTION_NAME'),'.'),3))

 

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


Did I answer your question? Mark my post as a solution!

Gustavo Moraes, o astronauta brasileiro do Flow!


View solution in original post

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
Power Participant
Power Participant

Re: decimal place

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

Look the images:

 

 

How i didHow i did

 After yoiu can use this compose to do your flow.

 

 

ResultResult

 Hope Have Helped,

 

Gustavo Moraes

 

 


Did I answer your question? Mark my post as a solution!

Gustavo Moraes, o astronauta brasileiro do Flow!


Highlighted
Anonymous
Not applicable

Re: decimal place

Unbenannt.PNG

almost

Highlighted
Anonymous
Not applicable

Re: decimal place

substring(string(variables('4.68750000000000')),0,add(indexof(string(variables('4.68750000000000')),'.'),3))sub

Highlighted
Power Participant
Power Participant

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:

Flow 2.png

 

 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


Did I answer your question? Mark my post as a solution!

Gustavo Moraes, o astronauta brasileiro do Flow!


View solution in original post

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

substring(string(variables('TotalExpense')),0,add(indexof(string(variables('TotalExpense')),'.'),3))
Highlighted
Power Participant
Power Participant

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)

 

substring(string(outputs('Compose')),0,add(indexof(string(outputs('Compose')),'.'),3))
 
The correct function to remove decimal with 2 places are
 
substring(string(outputs('Compose')),0,add(indexof(string(outputs('Compose')),'.'),2))
 

Did I answer your question? Mark my post as a solution!

Gustavo Moraes, o astronauta brasileiro do Flow!


Highlighted
Advocate III
Advocate III

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
Advocate V
Advocate V

Re: decimal place

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

Highlighted
Helper II
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
Advocate V
Advocate V

Re: decimal place

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

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

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

thirdimage

Power Automate Community User Group Member Badge

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

Top Solution Authors
Top Kudoed Authors
Users online (7,454)