cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PeterKuehlian
Level: Powered On

Reduce decimals to 1

Hi 

 

I am trying to get a solution of a calculation in my flow with only one decimal. 

 

Here is my flow:

I am picking up the file Size of my document and want to create exact the same value in another column. The purpose of this is, that I want to check if the content of my document has changed or not. 

 

So in this flow my file size is at 53.100000000917841. I want it to be 53.1.

 

Once this is done i just add KB to the string and i can compare it to my metadata-field Document Size. (Hopefully 😉 )

 

Snag_1c2d43b.png

 

Thanks in advance

 

BR

Peter

 

2 REPLIES 2
Highlighted
Willemijn
Level 8

Re: Reduce decimals to 1

Hi!

 

You first need to convert the float to a string and then you could use substring in combination with indexOf for that: substring(string(variables('decimal Value')),0,add(2,indexOf(string(variables('decimal Value')),'.')))

result: 
image.png
PeterKuehlian
Level: Powered On

Re: Reduce decimals to 1

Hi 

 

That works great. 

 

Only one more thing I need to apply.

I have to round my decimal correctly. 

In the example in the picture, I want the full number to be 53.1

Snag_e0b08.png

Helpful resources

Announcements
firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

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!

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors
Users online (4,935)