Format Number in Email Body

Like (0) Share

Report

Posted on 24 Feb 2020 17:42:02 by chz

Hi,

I am relatively new to Power Automate and I am a numb business person so hopefully you understand.

I have a sharepoint list with a column with revenue numbers (formated in currency). In sharpoint the numbers are formatted
correctly (e.g. 40.520,86 € - I am from Germany)

Now I have created a flow which sends an email and it should put the revenue number from that field in the Email Body.

It all works fine but the number is formatted like this 40520.86

What do I have to do (and where) to get the number in the Email body formated to a German number Format?

Thanks a lot for you help!

Chris

I have the same question (0)

All responses (3)

Answers (0)

chz 4 on 25 Feb 2020 at 13:22:30

Like (0)

Report

Re: Format Number in Email Body

soory the screenshot was not attached

The error message is:

BadRequest. The variable 'PowerRevenue' of type 'Integer' cannot be initialized or updated with value '0' of type 'String'. The variable 'PowerRevenue' only supports values of types 'Integer'.

Was this reply helpful? Yes No
chz 4 on 25 Feb 2020 at 13:21:01

Like (0)

Report

Re: Format Number in Email Body

Thanks for the reply!

I have some troubles with initializing the variables - I believe I have to do this first?

Sometimes the value is zero and then I get the following error when running the flow:
The column in the sharepoint list is formatted as currency - do I see that currectly that it is translated into a string?

Was this reply helpful? Yes No
fchopo 7,972 Moderator on 24 Feb 2020 at 18:54:13

Like (0)

Report

Re: Format Number in Email Body

Hello @chz
In this post by @Pieter_Veenstra you will find the solution: https://powerusers.microsoft.com/t5/Building-Flows/Displaying-a-number-as-Currency-or-Decimal/td-p/176185
You should have to create an expression like the following:
concat(div(variables('value'),100),'.',if(less(mod(variables('value'),100),10),concat('0',mod(variables('value'),100)),mod(variables('value'),100)),' €')
where variables('value') should be "Power Revenue", "Storage Revenue" or "TSS Revenue" values from SharePoint.
Hope it helps!
Ferran

Was this reply helpful? Yes No