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

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

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
Users online (8,269)