cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PeterKuehlian
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
Willemijn
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

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
User Groups Public Preview

Join us for our User Group Public Preview!

Power Automate User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (76,998)