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

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Trouble converting num...
Power Automate
Unanswered

Trouble converting numbers in a column

(0) ShareShare
ReportReport
Posted on by 21

I have a  notification workflow that sends the score of a quiz to the user after they have taken the quiz. The SharePoint list column is formatted as a calculated column which adds up the scores based on the questions given. When I look at the SharePoint TotalScore column its formatted correctly with the correct number example 70. When I send out the notification though its sends the email with the column embedded in the body as 70.000000000000. How can I get Power Automate to send the exact number given in the list column and leave off the decimal and extra zeros? I have tried different changes on the SharePoint column example: instead of using automatic I used 0 for adding the decimal. I have even tried using the percentage format as well on the column and its comes out 70,000%. Any help would be appreciated!

Categories:
I have the same question (0)
  • Verified answer
    RobElliott Profile Picture
    10,313 Super User 2025 Season 2 on at
    Re: Trouble converting numbers in a column

    @MontegoServices try formatting your calculated column (changing my column TotalScore to whatever yours is) as follows:

    =TEXT([TotalScore], "#")

     

    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.

  • MontegoServices Profile Picture
    21 on at
    Re: Trouble converting numbers in a column

    Thanks much! Worked!

  • cb23 Profile Picture
    326 on at
    Re: Trouble converting numbers in a column

    Hi @RobElliott, I have the same issue but am already using a formula (see my original post here: Re: Help working with data from Get Items - Power Platform Community (microsoft.com)). 

     

    How would I integrate your TEXT formula into mine? Currently: 

     

    =IF([Attendance 1]="Absent",1,0)+IF([Attendance 2]="Absent",1,0)

     

    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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard