cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MontegoServices
New Member

Trouble converting numbers in a column

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!

1 ACCEPTED SOLUTION

Accepted Solutions
RobElliott
Super User
Super User

@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.

View solution in original post

2 REPLIES 2
RobElliott
Super User
Super User

@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.

View solution in original post

Thanks much! Worked!

Helpful resources

Announcements
MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (25,212)