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 / Too many decimal place...
Power Automate
Unanswered

Too many decimal places in flow email

(0) ShareShare
ReportReport
Posted on by 44

Hi All,

 

I've been struggling with this issue for hours and it's driving me crazy!

I have a sharepoint list that is maintained by another flow (ultimate source is excel). This is used by flow to send an email to users as designated by the data in the sharepoint.

 

There is a % target field that is being pulled from excel into the sharepoint with 2 decimal places, but when I use it in the email it has loads more. I tried using a calculated column too and the exact same issue. I've been reading for hours on this but can't figure it out. Any help would be amazing!

 

Kind regards,

Categories:
  • jinivthakkar Profile Picture
    4,187 on at

    @Danb3434 You can use truncate function as shown below:

     

    jinivthakkar_0-1614783265123.png

    substring(variables('Test'),0,4)

     

    Hope this helps.

     

    --------------------------------------------------------------------------------

    If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

  • jinivthakkar Profile Picture
    4,187 on at

    @Danb3434 

    jinivthakkar_1-1614783788661.png

     

    Please check this out as well:

     

    https://powerusers.microsoft.com/t5/Building-Flows/decimal-place/td-p/50303

     

    --------------------------------------------------------------------------------

    If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

     

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 424

#2
11manish Profile Picture

11manish 328 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 274

Last 30 days Overall leaderboard