Quite obviously this is one of the most common asks in Flow to format a number. Here are some ways to do so using Format number Action in Flow (Power Automate).
This is available in Format number action in a Flow in Power Automate. This is available in Number Functions connector.
Commas and Decimals
- For a standard simple number, you can simply denote by # and commas or other symbols where needed. Here, I won’t select any locale.
- And it would render into this –
Phone Number
- US phone is an example where it is denoted by brackets and dashes in between. I’ll select English (United States) (en-US) in the locale among others. So, my format would be.
- And the resultant phone number will be set as below
Currency Input
For currency, this is what I did –
- Added ₹ followed by ##,###,###. I’ll select English (India) (en-IN) in the Locale field.
- So even though my number value i.e. (50000) is in thousands and not hundred-thousands as I covered in my format, it’ll consider the correct format used and my output will be –
Here’s where you can look at other ways to format numbers –
1. Standard numeric format strings
2. Custom numeric format strings
If you’re looking for some more posts on Flow / Power Automate, I’ve written some in the past. Check these –
- Create a To-Do List Item of Important Outlook Emails using Power Automate
- Get N:N records in a Canvas Power App using Common Data Service connector | Power Platform
- Call a Dynamics 365 Action from Flow [Bound and Unbound Actions] | Power Automate
- Switch-Case in a Flow | Power Automate
- Setting Retry Policy for an HTTP request in a Flow | Power Automate
- Make HTTP request from Flow in Power Automate
- Using Parse JSON to read individual List Records in Flow|Power Automate
- Secure Input/Output in Power Automate Run History
- Button Flow in Power Automate to replicate a Quick Create Form in D365 CE
- Enable Flow button on D365 Ribbon
Hope this helps!
[…] Number Formatting in a Flow | Power Automate […]
LikeLike
[…] Number Formatting in a Flow | Power Automate […]
LikeLike
You no longer need to use this action.
You can use a function called formatNumber(object, formatString, locale?).
It works the same as the action above, however this allows for multiple conversions within an action and helps keep the dynamic content amount down.
LikeLike
That’s right, Grant!!
LikeLike