{"id":23388,"date":"2020-04-20T12:46:32","date_gmt":"2020-04-20T12:46:32","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=23388"},"modified":"2022-06-14T15:14:48","modified_gmt":"2022-06-14T09:44:48","slug":"format-number-in-microsoft-power-automate","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2020\/04\/format-number-in-microsoft-power-automate\/","title":{"rendered":"Format Number in Microsoft Power Automate"},"content":{"rendered":"

Introduction<\/strong><\/h2>\n

As Microsoft comes up with new connectors in Power Automate frequently, one more useful action has been added which is going to simplify the number formatting while working with Power Automate.<\/p>\n

In many scenarios, when we work with invoices where the amount required should be in the specific currency format, the format number action can be used highly while working with Power Automate which can easily format the amount of the invoice in the specific currency.<\/p>\n

In this blog, we will see how it going to help us to format numbers or currency in the required format with the help of this action.<\/p>\n

For instance, suppose I want to retrieve Dynamics 365 entity fields (numeric\/currency) and perform further action like send an email, I want the currency should be formatted.<\/p>\n

Before I start, first quickly see how we will get the currency value from the fields without using the number format action.<\/p>\n

I have retrieved lead to show you the Annual revenue of the same. So, we will get the revenue as shown in the below screenshot:<\/p>\n

\"Format<\/p>\n

As we can see in the above screenshot, if I want to use the currency, there is lots of work required to get the same in the required format.<\/p>\n

So, now I will use the \u201cFormat Number\u201d action to format this currency in my required format. Post List Records I am adding the Format Number action as shown below:<\/p>\n

\"Format<\/p>\n

It will look like below:<\/p>\n

\"Format<\/p>\n

You will have the options to choose as below:<\/p>\n

Number<\/strong>: You can manually enter the number or select the field which you want to format.<\/p>\n

Format<\/strong>: Select the required format from the provided list or you can enter your custom format as well.<\/p>\n

Locale<\/strong>: This option can be used to format the currency based on the country. The default option is \u201cen-us\u201d.<\/p>\n

Post running the flow, as shown in below screenshot, the Annual revenue has been formatted:<\/p>\n

\"Format<\/p>\n

Similarly, we can format the number using the custom format as well as shown in the screenshot below:<\/p>\n

\"Format<\/p>\n

Conclusion<\/strong><\/p>\n

Using the \u201cFormat Number\u201d action we can format the numbers in the required format using Power Automate.<\/p>\n

One Pic = 1000 words! Analyze data 90% faster with visualization apps!<\/div><\/div><\/h2>\n

Get optimum visualization of Dynamics 365 CRM data with –<\/em>
\nKanban Board<\/a> <\/strong>\u2013 Visualize Dynamics 365 CRM data in Kanban view by categorizing entity records in lanes and rows as per their status, priority, etc.<\/em>
\nMap My Relationships<\/a><\/strong> \u2013 Map My Relationships \u2013 Visualize connections and relationships between Dynamics 365 CRM entities or related records in a Mind Map view.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"

Introduction As Microsoft comes up with new connectors in Power Automate frequently, one more useful action has been added which is going to simplify the number formatting while working with Power Automate. In many scenarios, when we work with invoices where the amount required should be in the specific currency format, the format number action\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":23394,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[16,18,1913,44],"tags":[],"class_list":["post-23388","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dynamics-365","category-dynamics-365-v9-2","category-microsoft-power-platform-services","category-power-apps"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/23388","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=23388"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/23388\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media\/23394"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=23388"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=23388"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=23388"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}