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 –
- 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
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!