cancel
Showing results for 
Search instead for 
Did you mean: 

Currency and decimal format in Microsoft Flows

I am building an email output where I am retreiving currency, ie formatted as currency in SharePoint.  It would be good to be able to format the "float" to 2 decimal places using workflow definition language.  I have been able to use substring but it fails when the number from the SharePoint list is 0.  It appears that 0 is actually represented as 0.0 and not presenting a second decimal place as integer numbers do.

Status: Under Review

Thanks for the input, we will evaluate this for a future release.

Comments
Regular Visitor

I was shocked not finding such basic functions like rounding or formatting for numbers in Microsoft Flow. This should be top priority and OOB.

Advocate IV

Somehwat shocked that formatting numbers to text is not Out Of The Box...

Text({Variable},'00,00') / Text({Variable},'#,##')

Super User

HI @Maeni and @Django .

 

I feel the same.

To work more easy  i create a WebApi to host basic functions and use in flow like this.

Advocate V

@gamoraes wrote:

I am building an email output where I am retreiving currency, ie formatted as currency in SharePoint.  It would be good to be able to format the "float" to 2 decimal places using workflow definition language.  I have been able to use substring but it fails when the number from the SharePoint list is 0.  It appears that 0 is actually represented as 0.0 and not presenting a second decimal place as integer numbers do.


Thanks for the advice, but I still think a basic support of formatting features for decimal (better also with currency and time/date) values is needed. It is a pain in the ass to have to make send mails with lots of numbers and format every single number output by hand.

Even more, because copy actions is not available and you have to make complex formatting for every send mail for every value.

 

There should be some ...

- "corporate global" or
- "flow global" or

- "personal individual"  

- or at least “send mail action item” settings,

... where you can change things like decimal behavior (dot or comma), the decimal places you want to show on floats, time / date format would also be very handy.

 

And still and in addition ... I can't understand why there is no "round" function (round a float to certain decimal places) available. Rounding numbers should be a really basic available function.

 

Helper V

Hi!

 

You can create HTML with currency and decimal format using Plumsail Documents

 

There is an action called Create HTML from template.

 

You can specify locale, currency, number format or custom format like this:

 

2019-03-26_16-54-04.png

As result you will get:

2019-03-26_16-54-59.png

 

Then you can use the result HTML in your messages or somewhere else.

Regular Visitor

I would really like to have this as well!  Please consider doing it!

Super User
Regular Visitor

Thank you @gamoraes .  While I would like to see an intrinsic function, it is nice to know it can be done.

Advocate V

@gamoraes

 

For me it's no real-world solution.

1. Substring is not "rounding" floats, it's simply cut it.

2. To round manually, it is much more complicated code. (plus change the . to , an vise versa. And everything else you have to do manually per every value per hand when you want to convert it to your country and to your design.)

 

More about it:

https://powerusers.microsoft.com/t5/Flow-Ideas/Currency-and-decimal-format-in-Microsoft-Flows/idc-p/...

Kudo Collector

This obvious lack of currency format (not even via expressions) prevents me from using Flow as a financial orchestrator.... 😞

 

If MS would provide a similar list of action like they do for date/time for currency management, it would be really valuable (convert numbers to currency, (auto trim and rounding), etc...)