{"id":78,"date":"2024-09-06T11:39:41","date_gmt":"2024-09-06T18:39:41","guid":{"rendered":"https:\/\/gilosoftblogcom.wordpress.com\/?p=78"},"modified":"2024-09-06T11:39:41","modified_gmt":"2024-09-06T18:39:41","slug":"using-format-number-function-in-power-automate","status":"publish","type":"post","link":"https:\/\/blog.gilosoft.com\/index.php\/2024\/09\/06\/using-format-number-function-in-power-automate\/","title":{"rendered":"Using Format Number function in Power Automate"},"content":{"rendered":"\n

Power Automate, formerly Microsoft Flow, enables the automation of repetitive tasks through custom workflows. Among its key features is the formatNumber<\/code> function, which allows for precise number formatting. In this blog post, we\u2019ll demonstrate how to utilize the formatNumber<\/code> function to format numerical values effectively within your workflows.<\/p>\n\n\n\n

What is the Format Number Function?<\/strong><\/p>\n\n\n\n

The ‘formatNumber'<\/code> function in Power Automate is used to format a number into a string representation based on a specified format. This function is particularly useful when you need to ensure numbers are displayed in a consistent and readable manner, such as formatting currency values, percentages, or adding leading zeros.<\/p>\n\n\n\n

Syntax of the Format Number Function<\/p>\n\n\n

\nformatNumber(number, format)\n<\/pre><\/div>\n\n\n
Where ‘number'<\/code> is the numerical value you want to format, and format<\/code> is the string that defines the formatting pattern.<\/p>\n\n\n\n
Step-by-Step Guide to Using the Format Number Function in Power Automate<\/strong><\/p>\n\n\n\n
Step 1:<\/strong> Create New Flow<\/p>\n\n\n\n
Go to Power Automate (flow.microsoft.com<\/a>) and create a instant cloud flow with a manual trigger. After you have created a title select “Create” to begin building the flow.<\/p>\n\n\n\n
Step 2:<\/strong> Initialize Variables<\/p>\n\n\n\n
Add a new action, “Initialize variable”, to store the number you want to format
Set the name to ‘numberToFormat’, type to ‘Float’, and provide a sample value<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Step 3:<\/strong> Format Number Function in Compose Action<\/p>\n\n\n\n
Add a “Compose” action to use the ‘formatNumber’ function
Set the input to the following expression to format the number as percentage with two decimal places:<\/p>\n\n\n
\nfomatNumber(variables('numberToFomat'), 'P2')\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
Step 4:<\/strong> Output the Result<\/p>\n\n\n\n
Add a new action, “Compose”, to output the formatted number.
Set the input to the result of the previous “Compose” action.<\/p>\n\n\n\n
\"\"<\/figure>\n","protected":false},"excerpt":{"rendered":"
Power Automate, formerly Microsoft Flow, enables the automation of repetitive tasks through custom workflows. Among its key features is the formatNumber function, which allows for precise number formatting. In this blog post, we\u2019ll demonstrate how to utilize the formatNumber function to format numerical values effectively within your workflows. What is the Format Number Function? The ‘formatNumber’ function in Power Automate […]<\/p>\n","protected":false},"author":2,"featured_media":80,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-78","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-power-automate-text-functions"],"_links":{"self":[{"href":"https:\/\/blog.gilosoft.com\/index.php\/wp-json\/wp\/v2\/posts\/78","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.gilosoft.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.gilosoft.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.gilosoft.com\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.gilosoft.com\/index.php\/wp-json\/wp\/v2\/comments?post=78"}],"version-history":[{"count":0,"href":"https:\/\/blog.gilosoft.com\/index.php\/wp-json\/wp\/v2\/posts\/78\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.gilosoft.com\/index.php\/wp-json\/wp\/v2\/media\/80"}],"wp:attachment":[{"href":"https:\/\/blog.gilosoft.com\/index.php\/wp-json\/wp\/v2\/media?parent=78"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.gilosoft.com\/index.php\/wp-json\/wp\/v2\/categories?post=78"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.gilosoft.com\/index.php\/wp-json\/wp\/v2\/tags?post=78"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}