Skip to content

Tools¹³ Blog¹¹ About Contact

Home Tools¹³ Blog¹¹ About Contact

Home /Power Automate Desktop Formula Reference /Trunc

Math

Trunc

Removes the decimal part of a number, rounding toward zero.

Syntax

Trunc(Number [, DecimalPlaces])

Examples

```
=Trunc(-3.7)
```
-3

Official documentation on Microsoft Learn ↗

← PreviousTrimEnds Next →UniChar

Explorer

Browse all 130 formulas with search, A–Z and categories.

Open in explorer →

More in Math

Abs Acos Acot Asin Atan Atan2 Average Cos Cot Degrees Exp Int Ln Log Max Min Mod Pi Power Radians Rand RandBetween Round RoundDown RoundUp Sin Sqrt StdevP Sum Tan VarP

Maker/ToolkitMaker/ToolkitMaker/ToolkitMaker/Toolkit

Free tools, guides and videos by Jayaprakash Murugan.

Power Apps Formula Reference
Regex Tester for Power Fx
SVG to Power Apps

Power Automate Expression Reference
Power Automate Desktop Formula Reference
Trigger Condition Builder
JSON Schema Helper
HTML Table Styler
Adaptive Card Builder

Dataverse/SharePoint

OData Filter Builder
List Copier

Developer Utilities

Expression Beautifier
Expression Picker

Site

Blog
About
Contact
What’s new

© 2026 Jayaprakash Murugan

Privacy & terms Report an issue

Independent project, not affiliated with Microsoft. Power Apps, Power Automate, Power Fx, Dataverse and SharePoint are trademarks of Microsoft Corporation. Product icons are Microsoft's official Power Platform icons, shown only to indicate which product each tool works with.

↑ ↓ moveEnter open