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
Microsoft Employee

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.

Super User

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

Level 8

@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.

 

Level: Powered On

Would love this as well Smiley Happy

Level: Power Up

Yes please!