web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Round the value to two...
Power Automate
Answered

Round the value to two decimal places

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi,

 

I have a column in Sharepoint (Calculated) which calculates a value of, for example, 21.412100. I want to round this value when sending an email to a user. 

 

OgOrowy_0-1654869054307.png

 

I tried various methods I found on the Internet. Unfortunately none of them works.

 

 

Thank you for your help

Categories:
I have the same question (0)
  • abm abm Profile Picture
    32,985 Most Valuable Professional on at

    Hi @Anonymous 

     

    Use the int() or float() expression to convert string value.

     

    Thanks

  • Verified answer
    Community Power Platform Member Profile Picture
    Microsoft Employee on at

     

     

    I tried int, unfortunately it didn't work, but float() did

    Thank you

     

  • abm abm Profile Picture
    32,985 Most Valuable Professional on at

    Hi @Anonymous 

     

    For decimals you need to use the float() and for integers use int(). If you happy with the reply I provided earlier please mark it as solution accepted as it helps others when they looking for solutions.

     

    Thanks

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 67

#2
David_MA Profile Picture

David_MA 64 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 39 Most Valuable Professional

Last 30 days Overall leaderboard