Currency and decimal format in Microsoft Flows

[Anonymous]

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.

[EG]

I'm using flow to send my group emails when PowerBI alerts have triggered. The only problem is the lack for formatting available for my number variables. I would like 5000000 is displayed rather than 5,000,000 or 5M. It would be great to add expressions or actions that will format a number to a friendly value.

[gamoraes]

HI @Anonymous  follow this post. I did it and post to solution a problem

https://powerusers.microsoft.com/t5/Building-Flows/decimal-place/m-p/50986#M4710

Best Regards,

Gustavo Moraes

[AlexN]

@gamoraes: Your soultion unfortunately only works when the decimal place are equal or more than 2.

But for numbers like 0, 0.0, 7.8, 0.1 your workaround doesn't work (more than that, it crashes the flow because the substring selection is out of bounds...)

Another problem for me as I'm located in Germany is that we use a comma for the decimal places in currency. This is another thing I have to do by replacing substrings which is pretty annoying.

[appieschot]

Would love this as well :), 

[EricDubbelaar]

Yes please!