web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate UpRound float value

Power Automate

Answered

UpRound float value

(0) Share

Report

Report

Posted on by Belasor

139

Hello,

I want to round up a float value in a WF to the next higher number.

I couldn´t find a solution/function for this, is this even possible?

I already found a possible solution, but this is only removing the values after the '.'

https://powerusers.microsoft.com/t5/AI-Builder/Round-a-Float/m-p/317574#M80

Categories:

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

RobElliott 10,323 Super User 2025 Season 2 on at

Like (2)

Report

@Belasor just use the Format number action:

Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.

Was this reply helpful? Yes No
Belasor 139 on at

Like (0)

Report

thank you for the answer, unfortunately if the value is 21.1 it´s down rounding.

By adding 0.5 and an condition I should be able to fix that problem right?
In this case I have to check if the decimal is equal to 0 if not add 0.5 and then using "Format number" to round it up.
Unfortunately I couldn´t find a way to check the decimal number 😕

Or is there any easier way? I just need a function similar to Math.ceil in JS :).

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft on at

Like (1)

Report
Hi @Belasor ,

Please refer to screenshot below to create the flow:

if(and(greater(last(split(string(variables('test')),'.')),'0'),contains(string(variables('test')),'.')),add(variables('test'),1),variables('test'))

Best regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No

Join the conversation