Answered

Limit the number of decimal places in dynamic content?

(1) Share

Report

Posted on by meinecke

Hello, I'm developing an automated report where a team member completes a form, the form results are added to a sharepoint list, and then the results are sent in a formatted email to the client.

I'm having trouble with the appearance of a percentage being pulled via dynamic content from a calculated column (which is formatted as a number and limited to two decimal places). When the dynamic content is added to the send an email action, it shows up as a percentage with 13 decimal places, which is not visually appealing and is unnecessary to have more than two decimal places. How can I limit the number of decimal places?

Thanks.

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Verified answer

RezaDorrani 12,145 on at

Like (3)

Report
Copy link

Link copied!

Hi @meinecke

Use the new format number action to truncate your data to 2 decimal places

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

Thanks,
Reza Dorrani, MVP
YouTube
Twitter

Was this reply helpful? Yes No
meinecke 4 on at

Like (1)

Report
Copy link

Link copied!

Hi @RezaDorrani thanks for your quick response. Can you please help me figure out where to put this in my flow? I don't want to apply this formatting to all numbers that are in the report, only this one specific number. Current steps are in the screenshot:

Was this reply helpful? Yes No
RezaDorrani 12,145 on at

Like (1)

Report
Copy link

Link copied!

Hi @meinecke

Add it before send email action.

And then use output of format number in email action

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

Thanks,
Reza Dorrani, MVP
YouTube
Twitter

Was this reply helpful? Yes No
Suggested answer

karenmeinecke 2 on at

Like (2)

Report
Copy link

Link copied!

I've learned a lot since I made this post 4 years ago...

Instead of using the "Format Number" action, I wound up achieving the desired output with the Substring function in Compose:

This approach allowed me to control the format more strictly like "XX.XX" or "XXX.X".
Note that the decimal point itself counts as a character, which is why I used 5 instead of 4.

I also wound up adding the % sign manually in the body of my email so that the number could be more accurate, something seemed to be getting lost in translation when I had my calculated column set up as a percentage with 2 decimal places.

Was this reply helpful? Yes No
Suggested answer

Michael E. Gernaey 53,974 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi

in your case that is true, however, not everyone wants to turn a number especially a decimal/float into a string.

Substring works, I can even do left or right and make it work, but the proper way is to use the first answer.

Was this reply helpful? Yes No
Suggested answer

SaiRT14 1,990 Super User 2025 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Add the "Format number" Action:

In your flow, after the step where the data is pulled from SharePoint, click + New step and search for the "Format number" action.

Configure the "Format number" Action:

In the Number field, select the dynamic content that contains the percentage or number value from your SharePoint calculated column.

In the Format field, enter N2 to format the number to two decimal places.

Example configuration:

Number: Select your dynamic content, such as CalculatedColumn or PercentageColumn.

Format: N2.

Use the Formatted Value in the "Send an Email" Action:

After the "Format number" action, the formatted number will be available as dynamic content.

In the "Send an email" action, insert the formatted number from the Format number action as the dynamic content in your email body.

Was this reply helpful? Yes No