cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper II
Helper II

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
Resolver III
Resolver III

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
Highlighted

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

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

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