Support for simplified number formatting
|Enabled for||Public preview||Early access||General availability|
|Admins, makers, or analysts, automatically||-||-||Jan 23, 2020|
To extend the built-in actions for an improved experience for all flow makers, the Power Automate team is happy to release the new Format number action. This new action enables you to perform a variety of number formatting options with little effort, and by leveraging number formatting patterns which exist across Microsoft Power Platform.
Select a format from the list of options:
You can also create your own custom number format, just like you do in Microsoft Excel using Enter custom value:
This new action is helpful in many scenarios for both citizen and professional developers. Here are some of the value highlights:
- Maintain numeric values as numbers for in-process calculations and format the appearance of the number based on typical patterns such as currency formats.
- Leverage past knowledge with custom formatting patterns you've learned in Excel, Microsoft Power BI, and Power Apps expressions.
- Vary currency formats per the business process requirements, rather than only the maker’s locale.
- Includes developer-friendly patterns, such as C2 (currency with two decimal places), and N2 (negative number with two decimal places). Learn more about these .NET formatting standards.
Simplified number formatting (blog)