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 Automate - Process Mining
Answered

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,276 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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 788 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 452 Moderator

#3
developerAJ Profile Picture

developerAJ 302

Last 30 days Overall leaderboard