Follow my blog for more interesting topics on Dynamics 365, Portals and Power Platform. For training and consulting, write to us at info@xrmforyou.com
With every release of Power Automate, it continue to evolve in terms of performance and features. Every release come with some new actions and triggers which make implementation of real life solutions much easier.
And one such feature is the capability to introduce format currencies or for that any number in Power Automate. Before I go ahead and introduce the action to format currencies and all, it’s important to understand when you need to format numbers in Power Automate flow.
The first one that come to mind is to display a currency in specified format. For example – We have an incoming currency value – 800000. While the number is accurate, to display this in reports or emails, it should be formatted. And in this case, let’s assume we want to display it as $800,000. The action will come in handly. Similarly if you want to format decimal places and stuff, this action can be useful.
By now, you might have already guessed it right. The action name is FormatNumber. And yes it is an Action and not a function. So let’s see a quick demo of it in action.
Create a flow with blank template and choose manually trigger a flow as flow trigger.
Add a step to initialize a variable to capture the output of the formatted number from the format number action.
Check for related posts
Next Add a step and search for an action “Format Number” as shown below:
Format number action has three inputs
- Number: <number_input>
- Format: <format>
- Locale: <Language>
The format parameter have three built in formats.
However you can specify your custom format as per your requirement. For example, I am using a custom format using “Enter Custom value” as shown below. My format is (###)-###-###
Save the flow and check for results.
As you can see, we can output any number in the desired format as per our requirement. And this function can be pretty simple and yet quite powerful.
No longer struggling with workarounds to achieve this simple and yet such a common requirement.
Hope this helps!
Debajit Dutta
(Business Solutions MVP)