Format Number Expression

[Kmayes]

Hi 

I have a flow that uses dynamic content in an array, the data comes from a SP list and I need to format the value as the number that comes back is 9.00000000. So I would like to format it so that it just displays the number before the decimal. The dynamic content is within an apply to each I have used the expression:

formatNumber(items('Apply_to_each')?['Column_Name'],'######')

Can anyone support on this?

[Expiscornovus · Accepted solution]

Hi @Kmayes,

You could use the int function instead of the formatNumber function:

int(items('Apply_to_each')?['Column_Name'])

[CFXtomayur]

The following expression worked for me.  In this example, I am adding three variables, then formatting the number and coverting into float value to be saved in a float type Variable.

float(string(formatNumber(add(variables('CostReg'), add(variables('CostOT'), variables('CostPrOT'))),'00.00')))

[DPozzi]

anyone have ever found the formatnumber (the FX not the flow component) syntax? 

[Expiscornovus]

Hi @DPozzi,

There is documentation about the formatnumber function:

https://aka.ms/logicexpressions#formatnumber

And there is also documentation about the formatters itself:

https://docs.microsoft.com/en-us/dotnet/standard/base-types/standard-numeric-format-strings#standard...