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.

Level: Powered On

It would be nice to provide a function for formatting numbers as thousands i.e. thousand separator to display large amount of money

Level: Power Up

Yes is always being requested at my organisation. 

It would make a big difference to how readable the number is 

Level: Powered On

I have a SPList, with simple title and some information in  Currency format.

When i use this column in my flow the value is became 1000000 instead of US$ 1.000.000.

I just want to show this value in its original format ( US$ 1.000.000) .


I cant find any clue how to do this...

Do i have to use substring to do this and super complex algorithm to do this ?

Level: Powered On

I've tried the Text expression from PowerApps to do the formating in a MS Flow Compose Body, with no luck working in Flow. Adding this support or at least using the same formating of the field in a Sharepoint list.

Level: Powered On

Yes my organization is requesting this now.  Please add!