Skip to main content

Notifications

Community site session details

Community site session details

Session Id : iy+v+QXv/DstonYusd5Llr
Power Automate - General Discussion
Answered

Round Off to 2 Decimal Places

Like (0) ShareShare
ReportReport
Posted on 30 Aug 2022 04:02:15 by 997 Super User 2024 Season 1

Hi, I have this flow to create items based on lists. For the Annual Leave, it is divided by 12 and it returns many decimal places. For example, 1.33333333333. I would want it to become only 1.33. How to do that?

anonymous21_0-1661831955904.png

 

I tried to set a variable and use the div but it says I cannot update the string with an integer so it has errors. Then I used Format Number to turn it into 1.33 only but due to the error on the set variable, It doesn't work.

 

Thank you.

 

  • syhrh Profile Picture
    997 Super User 2024 Season 1 on 30 Aug 2022 at 07:50:59
    Re: Round Off to 2 Decimal Places

    @Hardesh15 It works. Thank you.

  • Verified answer
    Hardesh15 Profile Picture
    7,087 Super User 2024 Season 1 on 30 Aug 2022 at 07:23:44
    Re: Round Off to 2 Decimal Places

    @syhrh Whatever you are passing into column just pass as input in Number format. Then use number format output in create item.

    Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

    @Hardesh /Gopenly.in

  • syhrh Profile Picture
    997 Super User 2024 Season 1 on 30 Aug 2022 at 05:42:40
    Re: Round Off to 2 Decimal Places

    @Hardesh15 it's not a variable so how to use Format Number?

  • Hardesh15 Profile Picture
    7,087 Super User 2024 Season 1 on 30 Aug 2022 at 05:22:18
    Re: Round Off to 2 Decimal Places

    @syhrh  Use format number-

    Hardesh15_0-1661836930363.png

    Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

    @Hardesh /Gopenly.in

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - General Discussion

#1
rpersad Profile Picture

rpersad 16

#2
David_MA Profile Picture

David_MA 10 Super User 2025 Season 1

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 8 Super User 2025 Season 1

Overall leaderboard
Loading started
Loading complete